API Text Response Appears as Comma-Separated Characters in Workflow

[dmytro.prozorovskyi]

Hi there,

When I initialize a request in the Plugin Editor, the data is returned correctly as text. However, when I try to do the same in a workflow, each character is returned separated by a comma. What could be causing this issue?

I’m currently using a text element as a container, and I’ve set its data source to an external API call. At the moment, I have to predefine the dataset_id and API key, and the data is displayed automatically. But what I want to achieve is the following:

• The user inputs the dataset_id and API key
• Then presses a button
• A workflow is triggered to fetch the data
• Finally, the result is displayed in the text element

How can I set this up in Bubble?

Also, could this data somehow be structured as JSON? I’m currently receiving it as plain text because the goal is to let users fetch different datasets. If I structure it as JSON, Bubble will expect a fixed data format. But since each dataset can have a different structure, using JSON would cause issues with flexibility and compatibility.

Thanks!

[Jici]

You can use a plugin to parse it as JSON.
As for th CSV… I think you should create a support request. This shouln’t happen.
However, here’s two workaround
A) use :join with ,
B) Activate detect header and continue workflow if error and use raw body instead (you could also activate JSON at this moment and the raw body will be available as text).

[douglas.epr]

To convert the JSON string to JSON object you can follow this video: https://studio.youtube.com/video/LvJaLzTHYow/edit

[dmytro.prozorovskyi]

The result of the API call is evaluated as a list of text. How can I get the raw result as plain text and place it in a text container without treating each character as an item in a list?