AppSheet API error

I am using a webhook action to hit the appsheet api to add rows to an app.

I have defined the body as follows:
{
โ€œActionโ€: โ€œAddโ€,

โ€œRowsโ€: [
{
โ€œUnique_User_Table_IDโ€: <<[Shift Manager Name]>>
},
]
}

But I am getting this error, saying the body is missing:

Error:
โ€œWebhook HTTP post request failed with exception {โ€œMessageโ€:โ€œREST API invoke request failed: The HTTP Body which should contain the API Action, Properties, and Row data is missing.โ€} The remote server returned an error: (400) Bad Request.โ€
Properties:
{
โ€œAppTemplateNameโ€: โ€œGMToolkit-929004โ€,
โ€œAppIdโ€: โ€œ8885bb91-850f-4252-b256-7b32d88ddc59โ€,
โ€œAppTemplateVersionโ€: โ€œ1.000081โ€,
โ€œRuleNameโ€: โ€œSOR Passing Score Adds To Trainingโ€,
โ€œEventTypeโ€: โ€œChangeโ€,
โ€œInvokedByโ€: โ€œAddโ€,
โ€œServerโ€: โ€œprodv2-lb-1โ€,
โ€œTableNameโ€: โ€œEvaluationsโ€,
โ€œRuleTableNameโ€: โ€œEvaluationsโ€,
โ€œOperationUpdateModeโ€: โ€œADDS_ONLYโ€,
โ€œEventMatchโ€: โ€œWorkflow event successfully matchedโ€,
โ€œConditionโ€: โ€œ=[Score] > 0โ€,
โ€œMatchesConditionโ€: โ€œTrueโ€,
โ€œActionResultsโ€: โ€œCreated 1 ActionResultsโ€,
โ€œAction Nameโ€: โ€œAdd Entry To Training Trackingโ€,
โ€œUrlโ€: โ€œhttps://api.appsheet.com/api/v2/apps/bfbcfeb8-188b-4231-9226-50982c30bb61/tables/TrainingTracking/Ac...โ€,
โ€œVerbโ€: โ€œPostโ€,
โ€œMimeTypeโ€: โ€œapplication/jsonโ€,
โ€œHeadersโ€: โ€œredactedโ€,
โ€œPayloadโ€: โ€œ{โ€œActionโ€: โ€œAddโ€,โ€œRowsโ€: [{โ€œUnique_User_Table_IDโ€: Will J Henry_beaulaurier_4453}]}โ€,
โ€œOperationโ€: โ€œChange workflow ruleโ€,
โ€œPerformanceโ€: โ€œ{โ€œVersionโ€:1,โ€œTimeโ€:โ€œ00:00:00โ€,โ€œPerformanceTimingRootโ€:{โ€œMidโ€:1,โ€œParamsโ€:{โ€œParamListโ€:[{โ€œPidโ€:13,โ€œValueโ€:โ€œEvaluationsโ€}]},โ€œTimerโ€:{โ€œTimeโ€:โ€œ00:00:00โ€},โ€œChildrenโ€:},โ€œIsEmptyโ€:false}โ€,
โ€œResultโ€: โ€œFailureโ€
}

Any Ideas?

0 2 1,745
2 REPLIES 2

@Will_Henry
Properties parameter is missing in your JSON payload.

sales
New Member

I am having similar trouble and getting the following error:
โ€œErrorsโ€: โ€œError: Workflow rule โ€˜On Change in Asset Protectionโ€™ โ€˜Bodyโ€™ template properties could not be obtained due to Illegal characters in path. โ†’ Filepath contains invalid path character: Filepath argument โ€˜{ โ€œActionโ€: โ€œAddโ€, โ€œPropertiesโ€: { โ€œLocaleโ€: โ€œen-USโ€, โ€œLocationโ€: โ€œ47.623098, -122.330184โ€, โ€œTimezoneโ€: โ€œPacific Standard Timeโ€, โ€œRowsโ€: { โ€œCustomerโ€: โ€œ<<[CustNbr]>>โ€, โ€œStatusโ€: โ€œ<<[Status]>>โ€, โ€œTimestampโ€: โ€œ<<[Now()]>>โ€ } } }โ€™ passed to method โ€˜IdMappingFileProvider.translatePathโ€™ contains an invalid path character 'โ€โ€™, โ€˜0022โ€™. Error: Workflow rule โ€˜On Change in Asset Protectionโ€™ โ€˜Bodyโ€™ template could not be read due to FileMimeType โ€˜โ€™ is unexpectedโ€ฆ",

Top Labels in this Space