Stop Retool Adding Double Quotes in JSON

[klautier]

I am passing in values that I want to use directly in the body (raw) of an API call. This fails as double quotes get added around my values: how can I stop this behaviour and have the output exactly the same as the input, i.e I don’t want "10000183988,10000185382", I want 10000183988,10000185382?

Input:

API body, with error:

[pyrrho]

Hello @klautier !

If you want an array, I recommend passing an array. For example, 10000183988,10000185382 will be interpreted as a string but [1000183988,10000185382] is an array and should be processed as an array and when using the value you can just write:

{
  "common": { 
    "car_identification": { 
      "car_ids": {{ params.BatchItems }} 
    }
  }
}

[klautier]

Thanks, that works if I use hardcoded values, but when I try passing into a loop it fails.

1. I hardcode the loop input to the function as [1000183988,10000185382] and it works correctly with the loop function
2. I pass in [{{ value.items }}] and it fails due to formatting in the JSON body of the API call
3. I pass in {{ value.Items }} and then add square brackets in a code block (return '[' + params.MachineIds + ']') and it fails due to formatting in the JSON body of the API call
4. I pass in [{{ value.Items }}] and then again add square brackets in the API raw body and it fails due to formatting in the JSON body of the API call

I am unsure how to proceed to pass the data through.

[pyrrho]

It looks like you need to create the array from a string. Your table column items seems to be returning a comma delimited string (a la 10000284542,10000284534). If this is always the case (comma separated values) probably the most straightforward thing to do is to use the .split() function with a comma as the delimiter.

In doing this, you would also need to drop the Array brackets ([<-- {{ yourValue }} -->]) from your MachineIds input. Instead you would send the array using {{ value.items.split(‘,’) }} which should send the MachineIds parameter as an array value: [10000284542,10000284534]

ETA: You could do the string split in the function block you are building as well. It has to be converted to the proper array format before being sent in the payload one way or another.

[klautier]

You are correct that I am using a comma delimited list as input.

I have tried using split as well as square brackets, but it still fails.

[pyrrho]

You are still sending your value with [ ] – don’t do that.

[klautier]

Thanks, that is now working. Much appreciated.

[pyrrho]

No problem!