Text filter requires a scalar value.
![Oliver Burrell](https://us.v-cdn.net/6037124/user_avatars/1677616.jpg)
I am trying to delete a record and feed the id from a variable like this:
If I run it I get an error: Text filter requires a scalar value.
I then tried to enter the id directly as a number and it worked fine.
I also tried to do it with a get filter but that doesn't work either.
Here is how the variable looks like when it comes to that error in the debugger:
So, I don't understand what's wrong with the id I feed in?
Could anybody help please?
Best Answer
-
Found out what this caused:
I did a query all further up into a variable and returned a list instead of a single record. Switched to single and it worked.
Answers
-
Great detective work @Oliver Burrell! For other members, as you can see by the debug info the field_value is wrapped in flat brackets, signifying that it is in fact an array and not a scalar value
-
Hey @Oliver Burrell @Michael Udinski , I get the same error when I return a single item. Do you have any idea?
-
@Clem - the sport_event var contains an entire JSON object. You want to use dot notation or the GET filter in order to get the key within the object that you want to reference. For example, "var: sport_event.Event_Sport"
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