Hello,
I am trying to do apparently simple thing but it turns out to be pretty complicated.
I need to update the value of one field in collection. This field's type is an array. This field is called PortionArray. I need to set its value to [] because when it is empty, array mappings fail and I got critical JS error during service execution.
I have studied this manual:
https://docs.appery.io/reference#data...
and decided to try following approaches:
1) Use built-in Appery tool:
with this query:
{"$set":{"PortionArray”:[]}}
2) Use this curl command via Terminal on my MAC:
curl -X PUT -H "X-Appery-Database-Id: mydbID" -H "Content-Type: application/json" -d 'operations={"$set":{"PortionArray”:[]}}’ https://api.appery.io/rest/1/db/colle...
where:
mydbID is the ID of my database
myCollection is the name of the collection containing PortionArray field
In the first approach I get "incorrect query" (looks like this option is only for find queries)
In the second approach I get nothing - after entering cURL command on my MAC and pressing ENTER I get no response at all.
So any help before I START TO CHANGE COUPLE OF THOUSAND ROWS MANUALLY appreciated.