Can someone provide script to notify external url on insert,update record

[Vipul]

I just checked with caspio support for above requirement that i want to trigger external url on data insert , update in caspio database so they said you can achieve this function by writing custom script in your data page form so does anyone can help me on this... 

 

My Requirement is whenever there is a insert /update in caspio i need to post those updates in other ERP system over http web url or with custom api which ever is possible... my idea is that there should be some script we can insert into datapage that can post to my php web application and that application insert into my erp ....

 

Regards,

Vipul

[MayMusic]

You can create web services API profile and with the .net language you know make a GET call to read the inserted row: 

https://howto.caspio.com/web-services-api/creating-a-web-services-api-profile/

https://howto.caspio.com/web-services-api/rest-api/

[Vipul]

HI Maymusic,

Yes we can do that with API but that is something like every 1 min i have to read database ..so that is costly operation ...cant we make Push method like webhook from Caspio DB... ? so whenever there is update caspio can trigger that webhook ? I know we can achieve same with Zapier but that is again premium cost...

[douvega]

Keep in mind that premuim options would add premium costs. Although, I agree with the idea of Caspio offering Webhooks, it is not currently available, so work arounds require either 3rd party services or backend development. I would say Zapier would be the best option for you in this case since they can watch over new or updated records so you can process them automatically.