Convert Type to JSON in Workflow for API consumption

[GusBricker]

Hello,

I have a workflow which needs to post some data to an API endpoint using the API connector. The API expects a JSON formatted input and I want to pass a Data Type I have stored. However I cannot figure out how to convert the Data Type into JSON.

Any advice?

Thanks

[mishav]

There are several techniques discussed already on the forum. You’d need to provide more information to work out which is appropriate.

To summarise …

• The JSON body is a string, which you can build up with text operations.

• If there is a single instance of the data type (not a list), or a fixed length list (example, always two items), it can be built up at the time of the API call.

• If there is a variable length list of the data type, there are two alternatives:

• Build up each item’s JSON structure as it is created or modified, and store it in the database. Then at the time of the API call, retrieve the list of JSON objects and join them together into a JSON array.

• Use the List Item Expression to build the entire JSON array at once. This only works on the client, so if your API call is happening from an API workflow triggered outside of Bubble, it would need to be done earlier by a client operation, and stored somewhere, i.e. similar to the first alternative.

Plugin API Connector with POST Request & JSON Array

I’ve a POST Request that consists of an array { “name”: “string”, “levels”: [ { “name”: “string”, “desc”: “string”, “order”: 0 }, { “name”: “string”, “desc”: “string”, “order”: 1 } ] } The number of levels is defined by user input. How can I configure this in the API Connector. I can only configure the JSON body with definite number of array elements

[GusBricker]

I got it working using text operations, it doesn’t look the prettiest but its functional!

Thanks for the advice!