Appsheet API is kicking my butt

School_Bus · 08-17-2021 07:48 PM

So I’ve been trying to get this thing working all day with no luck. I’m using integromat to hit the API, here is my JSON

{
"Action": "Edit",
"Properties": {
   "Locale": "en-US"
   }
},
"Rows": [
{
 "UID": "4d9bf884",
 "Rep 1 Position": "Fake",
 "Name": "Sally"
}
]
}

When I check my Audit Log I have this.

REST API:
{
  "Action": "Edit",
  "Properties": {},
  "Rows": []
}

Properties:
 {
  "RestAPIVersion": 2,
  "TableName": "User_Information",
  "AppTemplateVersion": "1.000082",
  "Action": "Edit",
  "Errors": "No rows are present.",
  "AppTemplateName": "23d2858a-bb0a-4dd8-9c65-b150a9c50c05",
  "Operation": "REST API invoke",
  "RecordType": "Start",
  "Result": "Failure"
}

What the heck does it mean no rows are present? I am at a loss.
If anyone has any idea on what I might try, I’d really appreciate it.

thanks

aforrester

I’ve sunk not-a-few hours into troubleshooting the API. I feel your pain.

Can you get it working with Postman? What about adding a row fake row?

pravse

Seems like there may be an extra closing brace in your JSON…

{
“Action”: “Edit”,
“Properties”: {
“Locale”: “en-US”
} < --- THIS SEEMS EXTRA
},
“Rows”: [
{
“UID”: “4d9bf884”,
“Rep 1 Position”: “Fake”,
“Name”: “Sally”
}
]
}

School_Bus

Yay… Sort of… removing the bracket got it to work… sort of… now I have a 500 error. Is this related to the google sheet?

School_Bus

fixed it!!! thanks for the help