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?
@Will_Henry
Properties parameter is missing in your JSON payload.
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โฆ",
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |