-
Parsing Object with Quotes into Array
My frontend is providing me with this: { "2": { "domEvent": {} "value": [ 3, 4, 5 ] } "3": { "domEvent": {} "value": [ 7, 10, 11 ] } } I'm trying to get the values as a list. What sequence of filters would I need to use to transform this into an integer list / array of [3, 4, 5, 7, 10, 11]? These are coming from a sidebar…
-
How to push/remove a value in the list while editing the record in 1 step?
Hi I am new to Xano. So this might be a stupid question. But I didn't manage to find a good answer online. I have a table "files" with column "variants" that is a list of integers. I want to remove/push the value in this list. Right now, I need to do 2 steps Get a record to basically get the current list ("variants_id")…
-
Getting an error when trying to add a very long array.
Hi there. Getting this error: Trying to add this like array more than 3000 items: It works when I try to add an array when 2731 items are inside, but 2732 items retruns the error above. Im trying to add a geo_linestrings object. Did i reach xano limits? More photos for context:
-
Array data
Hi, I'd like to get the values (2,6,7,3, etc) out from the data[] section of a variable that looks like this, and can't figure out a way. Please help. Thank you. [{index: 0,data: [[2,6,7,3,1,1,1,1,1,1,... +93 more]]}]
-
'Add to End of Array' is adding an Array to the end of an Existing Array
Hello, I have an existing array, which is labeled "ShowHostArray" below. When I add an integer to that array, it adds another array, which ultimately breaks my schema. Any thoughts on how to fix this?
-
Provide a meaningful key name when adding to the end of an existing array
Hi Xano community! I have hopefully a simple question. See below image. Currently, I add a variable to the end of an existing array but when it's added the key name is 0. Is there a way to give the key name a proper name so that I can easily reference it on my front end application? Thank you, Tim
-
Get request with Array Query works in debugger but not in live
Hi, Been trying to figure this out for a while now, I have a get request that has an input for an array in the debugger it's passed like this { "color_in": ["Red","Green"]} And when I try to do the same in postman it doesn't work, and I tried all different alternatives but nothing it only works in postman if I try it with…
-
Exception: Param: transactionAmount - Text filter requires a scalar
Hello! I am trying to run a loop to save multiple records from an external API to my DB. When doing an API call (without loop) it is workign fine and returning all data. (screen 1) Once I add the loop it runs into an "Exception: Param transactionAmount - Text filter requires a scalar." The custom function is the working…
-
How to update the value of object
Hello, ran into a strange issue while using an external API, { "id": 1, "lat": 55.082226, "lng": 22.76919399999946, "rank": 2 }, { "id": 2, "lat": 55.082226, "lng": 22.76919399999946, "rank": false } This is the response that I get, and in my database, I have 'rank' field as an integer. Is there a way to replace those…
-
Append suffix to integer value inside object array
Hi community, I'm currently working on this workout logger app, where frontend sends repetitions and weight values in the form of integer to Xano. The issue I'm having is, that I would like to add a measurement unit suffix to the weight value received from the frontend. Ex.: Frontend send to Xano: 99. Xano returns to…