REST API - POST request body

[jeremiah-blessing]

I am sending Budibase form data to an external POST request API. The schema looks like below

{
description : String,
countries : Array,
type : String,
subType : String
}

In that Budibase form, I have a text field called countries. In that field, the user can type by commas like US,UK,CH. While submitting I need to split this string and send it as an array field instead of a string(Screenshot below).

Thanks!

Screenshots :

[mjashanks]

You will need to do split when you are passing parameters in from the design section:

then...

[jeremiah-blessing]

I did this and then in the request body, the array is automatically turned into a string in request body.

Eg:

Value	State
US,UK	In Budibase Input Component
["US","UK"]	After splitting by using Javascript
"US,UK"	REST API Parser

[mjashanks]

ah. I see.

Try passing the stringified array ... i.e. from the Design section....

return JSON.stringify($("Form.Fields.countries").split(","));

[mjashanks]

and your REST body is

{
 ....
 "countries": {{ countries }},
...
}

i.e. no quotes around the parameters

[jeremiah-blessing]

I tried this but didn't work though. I will try other methods if I am able to fix this. Thanks : )

[oswaldB]

Hello,

I face exaclty the same problem and it is not working...

any idea?

Tahnk you

[shogunpurple]

Can you provide some more details please @oswaldB ?

[oswaldB]

Hello I succeeded by doing so:

let a = $("new_dossier_form.Fields.test-toto");
b = a.map(x=>parseInt(x))
return "["+b.join(',')+"]"

[ShinJustinHolly3317]

hey try using

{
    countries: [ {{ countries }} ]
}

and in your form submit actions you just keep the same

$("Form.Fields.countries").split(",")

[ShinJustinHolly3317]

I think it's a bug in budibase, no idea why it changes into string

[tugay-radity]

Using a simple helper function did the trick. Directly returning an array in bindings doesn't work.

function arrayToString(arr) {
  return `[${arr.map(item => `"${item}"`).join(", ")}]`;
}

return arrayToString($("Create User Form.Fields.roles"))