I'm looking for some help on how to extract particular data from a JSON response from an external API call made with Smartsheet Bridge.
The API call is working fine, and I'm getting the JSON response. Part of the response is an indexed set of data within the response, that includes HTML formatting tags. I'd like to strip out the HTML tags and just get the data points.
port: Port Canaveral / date: 09 Mar
port: Cozumel / date: 11 Mar
Then, once I have removed the HTML and have the Date and the Port, I'd like to take that information, and write the Port into a Smartsheet Column for "Destination", matching the date extracted with a "Date" column. (The date column will be pre-populated with a year's worth of sequential dates - 1 per row). Here's a mockup. (Not an actual screenshot from my Smartsheet)
I'm very new to using Bridge, any help you could provide would be highly appreciated.