SQLSTATE[55000] error from Bulk Add Record
![Jhon Michael Revilla](https://us.v-cdn.net/6037124/user_avatars/2263473.jpg)
We encountered this error . we add 2 row record using Bulk Add Record
this is working yesterday. thank you for your help sir Chris
Error is:
Answers
-
Hi @Jhon Michael Revilla - can you please shoot us a message on the support chat with this and the URL to the function stack?
-
This Test Data:
https://xauu-f7yc-ygdu.s2.xano.io/api:GhcgiZX4/CRT_saveEmployee_Bulk_UAT_v2
Authorization: ****************
{
"raw_Data": [
{
"FirstName": "Wilma",
"MiddleName": "Teves",
"LastName":"Albina",
"Suffix":"",
"BirthDate": "1983-08-23",
"Branch": "Nort",
"Account_Type": "Easy Savings",
"TIN": "292075499",
"EmployeeID": "434679"
}
],
"company_code": "rrr"
}
-
Hi there,
It looks like this bug is caused when bulk add records tries to add 0 records.
I took a look at your logs and I see that your lambda request before the bulk add records is complaining about an error and returning 0 records to be added. Try using run&debug with variable details included and you can see the exact error.
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