-
External API Request - Adding arbitrary string data before the JSON.
Hi, I am using the External API Request function and it works fine when loading JSON parameters. However I am hoping to see if I can add some arbitary string data BEFORE the JSON paramters are sent. The remote location can happily receive a string before the JSON data. For example, I am trying to add the word WARN as a…
-
How to access/reference JSON payload accepted at endpoint later in the function stack?
Hello, I've created an endpoint to accept a POST from TypeForm, which has a JSON payload. How do I reference the payload received in the request to the endpoint? I can see the payload when I click "Request History" in the menu for the endpoint, and can traverse the JSON there. But, when I try to reference it in the…
-
How to modify api input params to dynamically add columns and values ??
I am using metadata API, I need help with how to add columns in table dynamically along with the data. I figured out the column adding, but stuck on how to add the value in the table for that newly added column. Ex. { "data": "test", "int" : 123 } this is first object which has int as a new variable and need to add that in…
-
Need advice on JSON field
Hello everyone! I am new to Xano and using code as well but I need to learn so here I am. I have a database that has a list of weeks in them and then a JSON field that will sort a list of "splits", Inside each split is a list of "exercises" and inside each exercise is a list of "sets" (along with other information too).…
-
Find a key/value in a json object
I am wondering if there is a universal way to find an element within an object without knowing the path. E.g. get the "id" value, without knowing the top level of the object (one/two/three). { "one": { "from": { "id": 123 } }} { "two": { "from": { "id": 123 } }} { "three": { "from": { "id": 123 } }} What is known and…
-
Handling JSON array inputs
I have a list of id's being passed from my front end, and when I copy the inputs this is the format they are arriving in: {"idList":"[4,5,6]","lessonID":"6","idListRef":"[1,2,3]"} The result is empty, which is not right. If I copy and past how it is received into the run and debug and remove the "" around the [], like…
-
Using JSON Schema in Xano
Hi, I want to define a JSON Schema in Xano in order to use the new function calling of OpenAI/GPT. Couldn't get it to work as the normal Object tries to treat the schema as an object and gives an error. Does somebody has a hint how to save the JSOn Schema in a variable?
-
Reference variable in a variable?
Hi, I'm using a loop to manipulate an object. I need each loop to use a succesive element in my JSON data. For example: Loop 0 —> user.preference.0 Loop 1 —> user.preference.1 Loop 2 —> user.preference.2 Initially I thought I could simply use the loop's "index" variable (which tracks the loop's current iteration number) in…
-
I am passing 148 objects as a JSON input to an endpoint but only 67 are received, why?
Hi, I am passing information of 148 products like this ones (this products are retrieved from Meta's API): This list is passed as JSON variable "client_variants_meta" to another endpoint that uses this as an input. However, if we use the requests history to check the inputs of that other endpoint, it says that there were…
-
How can I ensure the create_object filter returns a null value in the object?
I have two lists, key_list = ["a", "b", "c"], values_list = [1,2,null]. The create_object filter will return {"a":1, "b":2}, the entry with null will not be included. What can I do to ensure {"a":1, "b":2, "c":null}?