BOT Error Invalid property identifier character

[Jack_Bates]

I wrote this HTTP body like the one for updating the Inspection Date

This one is for adding the unit to the Maintenance app when a user adds a truck or trailer through the annualloadbook app

Question: What is the Property identifier character?

{
"Action": "Add",
"Properties": {
"Locale": "en-US"
},
"Rows": [
{
“ID”: “<<[id_truck]>>”,
“Unit Number”: “<<[Unit #]>>”,
“Equipment Type”: “<<[Equipment Type]>>”,
“Make”: “<<[Make]>>”,
“Model”: “<<[Model]>>”,
“Vin”: “<<[Vin]>>”,
“Year”: “<<[Year]>>”,
“License Plate”: “<<[License Plate]>>”,
“Image”: “<<[Image]>>”,
“Notes”: “<<[Notes]>>”,
“Status”: “<<[Status]>>”,
“Created By”: “<<[CreationEmail]>>”,
“Created Date”: “<<[CreationDateTime]>>”
}
]
}

   

[MultiTech]

FYI: you inadvertently shared one of your access keys, it would probably be best to remove that image of the error log. 

==============================================

I'm not sure why your thing is failing, clearly it's having some kind of problem. Sometimes the errors can be misleading, pointing you to one thing when in reality it's something else. Maybe go and look at the automation manager, you might find something over there that could help point you in the right direction. 

[Jack_Bates]

Thank 

I know that it first was successful then immediately failed you can see that the timestamps are identicle.

[WillowMobileSys]

For the JSON "Properties", you can get more details here, just scroll down to the Properties section.  None of them are required though defaults will be applied to some if not provided.

In your log file, tap on the red binoculars to get more information concerning the error.  It may have a message that tells you why the call is failing.

I will say that a common reason for an ADD API call to fail is that there is a required column that is not being set by the JSON code.   Check the AppSheet table in the app you are trying to add the row into and verify that you have all the columns accounted for and that you have not missed any set as "required".

I hope this helps!

[Jack_Bates]

Will do thank you

[Jack_Bates]

The only column required in the Equipment Table is the [ID]

[Jack_Bates]

It’s failing because of error (Property identifier character)