Parse Long String into Array Variables

Hi,

I know this is a newb question, but I can’t seem to figure out how to parse a response I am getting from an API call. The response returns a “Body” of type “Long String”. The Long String is a giant list of the 3 values I asked for separated by semi-colons and a hard return.

Can someone provide some direction on how I could parse these values into a usable array?

Here’s a snip of the Output of the call.

1 Like

Welcome to the Make community!

That looks like a CSV (semi-colon) delimited data. You can try using the Parse CSV module.

If you need further assistance, can you please upload a copy of the string?

Output bundles

Please provide the output bundles of the modules by running the scenario, then click the white speech bubble on the top-right of each module, save the bundle contents in your text editor as a bundle.json file, and upload it here into this discussion thread.
Screenshot_2023-10-06_141025

Providing the output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

Following these steps will allow others to assist you here. Thanks!

4 Likes

@samliew thank you for the direction. I didn’t know the CSV module existed. It’s hard to find little tools like this sometimes. Thank you for pointing it out. Let me try it and report back shortly.

Thanks!
Matt

3 Likes

@samliew - you were exactly right. This module was perfect! Thank you for the direction.

2 Likes