-
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…
-
Help with For Each Loop and Array
Hey all, I have a peculiar problem in which I've tried every manipulation possible to fix. Here's the core problem: I'm running an aggregate result on a table, it also has add-ons. Here is the output. It is an array of objects and works as expected. Then, I want to do a for each loop to multiply…
-
External API requests depending on the number of records returned in previous response
Hello, I am struggling with adjusting my function stack to do external API requests depending on the number of records returned. I have built an app that fetches bank account details. It is working fine with a single account where first API gets the account number (if 1 account is returned it is fine): and second API does…
-
Objects vs Table Reference, which one should I use and which direction?
Hiya! Noob here. I watched some of your YT videos, which were helpful, I had my structure all setup and I understood it, It had Table References, life was great. 😎 Then Objects were thrown in and it all got confusing again 😩. In the application I have in my head I had a products table and a products_type table. I had a…
-
Responce in Object
I'm getting this output: {"availabilities": …} {"availabilities":[{"id":1,"productId":"prod123","dateTime":"2023-09-03T10:00:00+02:00","vacancies":10},{"id":2,"productId":"prod123","dateTime":"2023-09-03T15:00:00+02:00","vacancies":8}]} but I'm looking to get the following output: {"data": {"availabilities": …}} {"data":…
-
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…
-
Posting into an array via API
Hi, I'm currently working with an post API call, which I would like to post into an array with each row being separate. I have my db set up with an field called Risk_1 (type: object/Structure: single). Within this I then have two fields "What could go wrong" and "Who is at risk" (type: text/ Structure: list). I've tried…
-
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…
-
Return an ID each time a value is found in a object array from an array
Hi there, I know it's possible but can't get my mind into it: I am quering a database to have all the result matching a specific request. It comes out as an array (list of results). In this array, there is this "selected_club" section that has a specific array of objects I am interested in, I would like to see if my…
-
Filter objects in an array
Hi, I am getting an array of products (json objects) as response from an external api call: Example: products = [ { id: 1, name: 'Product 1', price: 9.99, description: 'Description of product 1' }, { id: 2, name: 'Product 2', price: 19.99, description: 'Description of product 2' } ] I'd like to create a new array…