Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I must call an API with PUT http method.
I have an JSON file but this API must have an JSON array.
I search and I search any solution (with tWriteJSONField or with "tConvertType"/"tReplace") but none solution is OK.
Has anyone ever had this use case ?
Kind regards.
Hi
Can you show an example to explain what the Json data looks like? With tWriteJSONField, we can create a Json string as seen below, it contains an array element.
Hello,
I still have the problem.
I have this :
and this is the description of tWriteJSONField :
But at the end, I don't have my JSON in array format. 😩
I'm not an expert of JSON format.
Kind regards
I would like to add this precision :
the start of "logrow6"
Finaly, insert with API not working.
My main problem is the my JSON file is not an array.
The API must have an JSON array.
@Eric Vincent , see below screenshot which showing how to define an array element.
Please try again and let me know if you have any problem.
Regards
Shong
Hello,
thanks for your proposition.
I try to add this in my job but the result is not good.
When I add with CURL, I have this code :
curl -X PUT "https://myURL/api/table/rows" -H "accept: application/json" -H "Authorization: Basic XXX" -H "Content-Type: application/json" -d "[ { \"logindelagent\": \"XXX\", \"identifiantastre\": \"111\", \"projetservice\": \"XXX\", \"rattachement\": \"XXX\", \"responsable\": \"XXX\", \"statut\": \"XXX\" }]"
it is this code that I want to reproduce in json.
Kind regards.
oh, I will try to add with CURL by removing "\" before each data and it's KO.
So, I must have this caracter before each element 😞