JSON Dynamic Field Values when Updating API records with the Download Tool

[dshay248]

Hi all,

I want to update a JSON file with dynamic values from a field in a table when updating an API through a PUT in the download tool.

So for example : {"id": "XXXXX"}  should become {"id": [Field1]}     where [field 1] is a field in the record and the  JSON is in a field [body] in the record.

The issue is if I use a field in the record to put the JSON into a field for the download tool, you need to put it in quotes to be interpreted as text.

Is it possible to do this?  In other words update the JSON code dynamically through field values from a record?

Thanks any help or experience with this will be appreciated.

[AkimasaKajitani · Accepted solution]

We can update dynamically the JSON Value.

Does below formula fit what you want to do?

'{"id":"'+[Field 1]+'"}'

If the "Field 1" have the value "AAAA", the formula will output {"id":"AAAA"}.

[dshay248]

Thanks that works and thank you @AkimasaKajitani for the quick response!