hi there,
I was trying to invoke api from appsheet i am getting error like this
Properties:
{
โAppIdโ: โ6d6f6ea7-1710-446e-89f2-23213be53847โ,
โAppTemplateVersionโ: โ1.000559โ,
โRuleNameโ: โNew Workflow Rule 2โ,
โEventTypeโ: โChangeโ,
โInvokedByโ: โUpdateโ,
โServerโ: โprodu99110000Q6โ,
โIgnoreSecurityFiltersโ: false,
โTableNameโ: โReceving formโ,
โRuleTableNameโ: โReceving formโ,
โOperationUpdateModeโ: โUPDATES_ONLYโ,
โEventMatchโ: โWorkflow event successfully matchedโ,
โConditionโ: โโ,
โMatchesConditionโ: โTrueโ,
โActionNotPerformedโ: โ1 errors present.โ,
โActionResultsโ: โCreated 1 ActionResultsโ,
โAction Typeโ: โWebhookโ,
โAction Nameโ: โAction 1โ,
โErrorsโ: โError: The webhook url 'http://api.appsheet.com/api/v2/apps/6d6f6ea7-1710-446e-89f2-23213be53847/tables/Receving form/Action?applicationAccessKey=y6Rhx-RsTZ0-atYAf-Ssrzq-9MTZk-byIdP-hvqHw-avINz is not well formedโ,
โUrlโ: โhttp://api.appsheet.com/api/v2/apps/6d6f6ea7-1710-446e-89f2-23213be53847/tables/Receving form/Action?applicationAccessKey=y6Rhx-RsTZ0-atYAf-Ssrzq-9MTZk-byIdP-hvqHw-avINzโ,
โVerbโ: โPostโ,
โMimeTypeโ: โapplication/jsonโ,
โHeadersโ: โapplicationAccessKey:y6Rhx-RsTZ0-atYAf-Ssrzq-9MTZk-byIdP-hvqHw-avINz, _webhookActionDepth:0โ,
โPayloadโ: โ{โActionโ: โEditโ,โPropertiesโ: {โLocaleโ: โen-USโ,โLocationโ: โ47.623098, -122.330184โ,โTimezoneโ: โPacific Standard Timeโ,โRunAsUserEmailโ: โYourEmail@google.comโ},โRowsโ: [{โSnoโ: โ6247aaf6โ,โDateโ: โ11/7/2019โ,โTimeโ: โ3:43:47 PMโ,โNameโ: โyO8vDJhmโ,โEmail IDโ: โSreekar.pranav4@gmail.comโ,โImageโ: โhttps://www.appsheet.com/get/?i=YXBwTmFtZT1CdWxic1Nob3BwaW5nLTgyODg0NiZUYWJsZU5hbWU9UmVjZXZpbmclMjBm... Colorโ: โGreenโ,โLengthโ: โ100โ}]}โ,
โAppTemplateNameโ: โBulbsShopping-828846โ,
โOperationโ: โWorkflow actionโ,
โResultโ: โFailureโ
}
Help me with this thanks in advance
When creating the endpoint URL, you need to URLENCODE values that contain special characters or spaces.
If you are trying to invoke the AppSheet API directly from a webhook you should pick the appropriate โPresetโ as described here https://help.appsheet.com/en/articles/3463654-invoking-the-appsheet-api-from-a-webhook
That will make using the API much easier to use because the system does most of the work for you.
Hi @Phil Actually i was trying to get data from a third party website to a form into appsheet can you suggest me how to do it .Its not like posting the data but to retrieve the data from the website.
There is no way to populate an editable form field (dropdown or other field) from external data that you want to retrieve from some web service. I am not entirely sure what you are trying to do so if you could post a little more details about the intent, we can make better suggestions.
AppSheet webhooks allow you to invoke an external web service, send that service a Post body you define, and have the service perform some action. You cannot currently use an AppSheet webhook to retrieve data from an external web service.
You could do that by:
Others in the community may be able to suggest other simpler alternatives.
@Phil i have tried this technique which you suggested i am able to post and i am getting success message from in the audit history i am not able to retrieve data into app sheet from a 3rd party website into a form can you suggest that how to do it.
Thanks in advance.
To the best of my knowledge, Jayaram is correct that you cannot post the data directly into an AppSheet form.
You could store the data into a row of an AppSheet table by invoking the AppSheet REST API.
Not sure if that meets your needs.
Hi @Phil i have tried doing this for my app
{
โActionโ: โAddโ,
โPropertiesโ: {
โLocaleโ: โen-USโ,
โLocationโ: โ47.623098, -122.330184โ,
โTimezoneโ: โPacific Standard Timeโ,
โUserSettingsโ: {
โOption 1โ: โvalue1โ,
โOption 2โ: โvalue2โ
}
},
โRowsโ: [
{
โNameโ: โJanโ,
โImageโ: โhttp://images6.fanpop.com/image/photos/36300000/Emilia-Clarke-image-emilia-clarke-36399128-460-276.j...โ
}
]
But it is not working i am getting the following error
{ โstatusCodeโ: 404, โmessageโ: โResource not foundโ } .
Please let me know if there is any configuration has to be done.
Thanks in advance.
The URL does not look correct. To invoke the REST API, you need an URL like the one described in this article https://help.appsheet.com/en/articles/1979979-invoking-the-api
Hi @Phil i was trying to post from appsheet using a webhook to post into zapier from a form into the 3d viewer http://someshwarasoftware.com/games/test/custom1moonbeam/index.html?Image=1&Product ID=1 into that
One more thing is the link in behavior is that static or can i change with parameters if i can change parameters please suggest me how to do it.
When you refer to โlinkโ I think you are referring to the URL value. Is that correct?
If so, you can customize the URL as described in topic โURLโ in this article https://help.appsheet.com/en/articles/962008-invoking-webhooks-from-a-workflow-rule-or-scheduled-rep...
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |