I wouldn’t run this loop / update on a GET all endpoint, it will take an age, and is not needed every time. You should do this as a batch, not on a public endpoint, and on the create or edit endpoints if necessary.
Michael from Xano has a video about updating relationships like this.
thanks @Rozza I have resolved it.
if I want to update or edit in Adalo, do I just do the Update action?
Hi Agung,
Are you using the help documentation from Adalo! The Xano integration section covers this.
The important thing to remember is that Xano expects a full record of data for an update. No PATCH possible.
Your endpoint is not returning any records. That’s the problem.
Check the request history on your endpoint.
Check the inputs that are being passed from Adalo on the request.
There is no error message, you are just returning 0 results. So I suspect the params not being passed.
I created a new reference table in the selector that takes from the user table.
but I got a notification like this
Hello
Include variable details during run and check in the debugger tab where it stops.
That is where your field_value err will be.
Can’t run due to huge dataset busting the memory? Then limit the dataset and run it again.
check in your function stack the value of the “field_value”
maybe it is set to text instead of var.
blank record or blank field in one of your records?
what do these say when you expand them?
The answer will be in the xano request history OR in the API that Adalo sends.
Check in the xano request history
Check in the inspector view Network tabm when you run the action.
Post up the responses in detail.
In Xano I didn’t find anything strange, I have posted this in the Xano community, but I haven’t gotten an answer yet.
I’m confused about what to do, I’ve looked for a discussion on ADALO about this, it turns out like others have experienced this problem, and they mostly delete and recreate and their problem is solved, I’ve tried following them, but it doesn’t work
Hi @Agung
Without error logs from the inspector window and from Xano it’s not possible to begin troubleshooting.
If you are posting a problem like that then always include them.
Does the same request work from Postman or Insomnia?
Hi
this problem is solved.
Oh yes, Rozza, do you know why the names/numbers don’t appear in the preview?
How was it solved?
Your second issue… I have had problems with preceding underscores.
Also are you returning a list in that add on? It will need to be a single item for Adalo to interpret.
If you want a list add on. You can’t. You just have to have another endpoint then pass the ID of the parent record from Adalo to Xano to filter.
ya
