Sending Caspio Data to Third Party Services

[jlockwood]

Good afternoon, fellow code monkeys.

 

We've reached a point in our development cycle where we need to send data out to a bunch of other software. UPS for address validation and shipping, WASP for purchase order creation, and QuickBooks for financial reporting. Yet I cannot get any of it to work for the life of me. 

 

For example, let's look at this API request to WASP for creating a purchase order: (dummy data)

 Works great in Postman, received a 200 the first time I tried it. 

Yet, I have scoured the depths of the Caspio API docs, plumbed the forums, and sent crates full of tickets to support, none of which were able to help. Problem is that I don't know where the heck to put any of this request data so that it can use data from my tables. There's not an obvious user interface anywhere. Tried embedding it in HTML blocks too, no luck. Tried sending it via webhook, and got this error: 

 

Anyone had any success transferring data from Caspio to the other software in your workflow? It must be possible, since API data transfer is displayed prominently as a feature on the sales landing page, but I just can't figure it out, and neither can anyone I've spoken with from Support.  Appreciate any tips or guidance that might point me in the right direction.

 

Cheers -- JL

[Barry]

Hello jlockwood,

I have configured some webhooks and also used Make to create integrations.

I think the issue with your configuration is that you are not using a secure https connection and webhooks only work with https.

Do you have a public documentation for wasp? Is it possible to configure it so it accepts the POST in https?

[jlockwood]

Hi there.

 

Tried changing request to https://. Totally broke it. 

So it seems that the API only works with HTTP, while Caspio only accepts HTTPS. Any ideas on how to square the circle?

[Barry]

If it is not possible to use https and you need to send the same information to multiple applications, I would consider using Make in that case.

You can create a scenario in Make that triggers when the Caspio Webhook sends the POST, then deliver that information to the other applications using a custom http POST.

I created something similar by following this video. Instead of Trello, I used slack, but it is possible to create your own HTTP request module : 

 

[jlockwood]

Checking back in. Been talking to tech support for the client software, and the solution is more complicated than I thought. If anyone's having the same problem, here's what they said:

• The reason that the request isn't going through is because the client software is on-premise.
• To get the request through, a port has to be opened on our server to the Internet.
• A security certificate has to be generated and applied to the port.
• Caspio is then directed to that port with the webhook POST request.

Not really sure what that looks like in practice, but I bet someone in our IT department can help. I'll bump this thread with results soon

[FinTheHuman]

Hello! Caspio releases another new enhancement to the WebHooks feature, refer below: 

Caspio Webhooks allows your applications to communicate with third-party systems in real time when changes to data occur. 
In this release, we introduced the following updates:

• In non-HIPAA/Compliance accounts, webhooks logs now show the information sent and received.
• All accounts, including HIPAA/Compliance, now can:
  • Send webhooks based on table events initiated by triggered actions and tasks.
  • Configure webhooks for tables with triggered actions enabled for the same event as the webhook. 
• A single REST API call can be used to activate or deactivate all events for a selected webhook.

Source: https://howto.caspio.com/release-notes/caspio-47-0/#:~:text=Enhancements to Caspio Webhooks