Passing entire thing as a json object to an external API

[mills41]

Hello,

I’ve got a simple question. I’m trying to send POST to an external API the complete Thing itself. So I’ve got a whole bunch of things that I’m trying to put together into a JSON.

{“Thing1”:"",“Thing2”:"",“Thing3”:""}

and send it over API post to an external API.

I don’t want to be going through each ‘THING’ and defining each field. Which is very very time consuming as each THING has about 20 fields and I’m looking at about 5 Things in total… so apart from me going through and mapping every single field, any other way like to do a JSON stringify and put it into a text field and then POSTING it?

[viquarahmed07]

Hi @mills41

You can do something like this

& results will be like this

[ritzygem13]

Do a search for where the data is in your database and then

format has text

with your JSON formatted correct add your values and in the delimiter add a

,

[yigal]

I’d also advise using :formatted as JSON-safe