Hello,
I have been trying to connect the AppSheets via HHTP Request for the last 3 hours, without any progress. I would really appreciate if somebody could help me with the parameters…The API is connected and working (at least I dont get any erros here anymore) But the Output is: No fields - node executed, but no items were sent on this branch. These are my parameters, maybe somebody could help? I would REALLY appreciate this! Thank you so much in advance! Kind regards,
Marcy
According to the AppSheet documentation, a Find request requires you to specify filters or criteria to find data.
Your current body:
{
"Action": "Find",
"Properties": {
"Locale": "en-US"
}
}
It’s valid, but it doesn’t include search criteria, so it won’t find anything (hence the “no items sent” message).
Example of a functional body:
{
"Action": "Find",
"Properties": {
"Locale": "en-US"
},
"Rows": [
{
"CustomerID": "12345"
}
]
}
According to the AppSheet REST API guide, here’s what you need to know:
-Body Properties (HTTP request body)
Action: Must be “Find” to read existing records.
Properties: Includes optional settings such as:
Rows:
If you use “Find”, you can:
"Rows":[ { "FirstName": "Jan", "LastName": "Jones" } ]
This returns the exact rows that match those keys.
Or, leave Rows: and use Properties.Selector to apply filters like Filter() or Select() .
Thank you so much for the effort! I changed the body around and tried out multiple ways…also gave the instruction to claude and went through it one by one…just no result…who knows what I am doing wrong…Are there freelancers we can hire around here to have a look?