This is my JSON file.
I want to insert, in "structure_ids" array, the value 79538.
Maybe the problem is my value, I can't write it like that.
Thanks for your help
Best answer by david_r
View original
Hi! I have a question about JSONUpdater. I want to insert a new value in a array. I read some articles about JSONUpdater on FME Community but I don't find a solution to my problem.
Userlevel 4
- 8178 replies
-
17 October 2022
- Best Answer
I believe the issue is that the JSON Path does not contain the target array name. Also, the Array Index should not contain the array name, but an integer index. Alternatively, you can set the update type to Append to avoid having to specify the index. For example:
Thank you so much, it works!
I just have an additional question. Do you know why, when I look at json text resulting from this transformation, the inserted value has double quotes.
Userlevel 4
- 8178 replies
-
17 October 2022
Thank you so much, it works!
I just have an additional question. Do you know why, when I look at json text resulting from this transformation, the inserted value has double quotes.
Unless FME is completely certain, it has a tendency to default to string data types, which is why you get the double quotes.
You can cast (force) the values to int by using the following expression in the JSONUpdater:
ok thank you for this explanation
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.