Updating Array with API
Options
Riaan Backer
Member ✭
Hi Guys, hope you can help.
I try to update and array in the user table field called portfolio_id with an id that gets generated from a newly created record in the portfolio table by doing a merge,so keeping existing values and adding a new value.
What is strange is that it does not want to work when I make use of the var id called portfolio.id after I have added the new record but only works when I pass a value through the input field marked in yellow. The current screen shots are configured by trying to make use of the var portfolio.id after the record have been created
Any recommendations for me please.
I did had a look at this link (https://www.loom.com/share/79ff965fa7784ff3949e18c5ca1ed219).
[a.PNG]
[1.PNG]
[2.PNG]
I try to update and array in the user table field called portfolio_id with an id that gets generated from a newly created record in the portfolio table by doing a merge,so keeping existing values and adding a new value.
What is strange is that it does not want to work when I make use of the var id called portfolio.id after I have added the new record but only works when I pass a value through the input field marked in yellow. The current screen shots are configured by trying to make use of the var portfolio.id after the record have been created
Any recommendations for me please.
I did had a look at this link (https://www.loom.com/share/79ff965fa7784ff3949e18c5ca1ed219).
[a.PNG]
[1.PNG]
[2.PNG]
Comments
-
Hi merge is going to be used from array to array. Your set up here looks like an array to a scalar (or single integer). So you will need to use a filter like append, for example, instead of merge.
-
Hi Michael.
Apologies for only coming back to you. I can confirm that its working, my bad.
Categories
- All Categories
- 53 ? Announcements
- 47 ? Releases
- 37 ? Welcome
- 983 ? Help! I'm a Noob
- 125 ? No-Code Front-Ends
- 633 ? Working with APIs
- 439 ? Transforming data
- 126 ? Connect Xano to ...
- 50 ?? Find an Expert
- 348 ❓Other questions
- 35 ? Security
- 22 ✂️ Snippets
- 19 ? Showcase
- 7 ?️ Xano Chatter
- 62 ? Video Tutorials
- 171 ? Request a feature
- 229 ? Report a Bug
- 19 ? Templates & Extensions
- 7 ? Feedback