I heard some people are having issues with Ninox API functions. Especially talking about API responses. Ninox had an update around the first of this month and that broke some functions that worked before. To discuss this issue and the solution we have to go through a few things first.
When we receive an API response for a request we receive a JSON Object. An object has properties that we can access. Example:

{
id: 1,
name: “Jon Doe”,
age: 35
}

This is a simple object. Let’s see an example for an array:

[
{
id: 1,
name: “Jon Doe”,
age: 35
},
{
id: 2,
name: “Jane Doe”,
age: 33
}
]

Notice in the first example only a curly braces surrounding the response that includes key-value pairs versus in the second example we have the square brackets surrounding the individual objects and the objects are separated by a comma. This will be important later.

A typical request looks like:

let REQUEST := do as server
http(“GET”, “https://api.ninox.com/…“, {Authorization: “Bearer ” + TOKEN,‘Content-Type’: “application/json”}, {})
end;

Then we get a response. If we receive an object as a response instead of an array we can access the properties immediately (note that that first property is always “result” and properties are case sensitive) by adding a “dot” after the variable name we used to store the response. Usually we have to “wrap” this around with the text() function to be able to save it in a text field or print it, etc:

text(REQUEST.result)

If we would like to access what’s inside that object then we just add another “dot” and then the KEY name:
text(REQUEST.result.name)
This is where issue happens. The line above worked before. Now it has stopped working. To fix this we need to modify the code. First we have to wrap the response around with the text() function then with the parseJSON() to covert the result object. Now we are able to continue as before:

parseJSON(text(REQUEST.result)).name

This will return the desired result, it will read out the name from the name property.

If the result returns an array then we have to loop though the retuned objects by using the “for i in range(cnt(REQUEST.result)) do…” loop combined with the item(REQUEST.result, i).name to access the name property from each objects for example.