I use nintex Xtension to interact with Google Sheet V4 API.
In the body request I need to send JSON structure, but I don't know how to Build a JSON.
The structure that I want to build is a json multi dimensional array, (an Array of Array).
For exemple :
In the action "Add item to collection" we can't add collection, only text, int...
anyone knows how to achieve this ?
Hi, No I can't, because if I store my JSON value in a string variable when the query is sent, the body value is transformed as a string and not array, and I get an error because I pass an array who contains string value and not an Array who contains Array Who contains string value.
For exemple, my array is called "values" and I put my JSON array as string in it, the query will be
And not :