Integration with Priority ERP

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • In Progress
Does anyone have any experience with doing integration an ERP like priority? I found this https://prioritysoftware.github.io/restapi/ which looks like REST API for interacting with Priority. We would need Quickbase to push information to Priority and perhaps also pull information. 

I want to know what level of effort something like this requires or if there is already something built that can handle this.

Thanks
Photo of Michael Horwitz

Michael Horwitz

  • 112 Points 100 badge 2x thumb

Posted 4 months ago

  • 0
  • 1
Photo of John Rogers

John Rogers

  • 400 Points 250 badge 2x thumb
I would say a decent amount of effort. The thing about Quickbase is it does not allow you to see the payload from an API response. So you need to have a server, or a middleman software to manipulate responses between Quickbase and priority ERP.

The things that are simple that Quickbase can do. You can use a webhook to hit an endpoint using XML or JSON to send data. (you will not get response, EX: if your first step in the API is to receive an auth token)

You can allow a 3rd party to post into your APP with a userToken/appToken and field_ID numbers and your Quickbase domain URL. 
Photo of Michael Horwitz

Michael Horwitz

  • 112 Points 100 badge 2x thumb
Thanks. Do you know of any apps that accomplish something like this already built? Maybe they can get us halfway there.
Photo of John Rogers

John Rogers

  • 400 Points 250 badge 2x thumb
I use Zapier for all of my API integrations I have setup with QuickBase right now. Very simple and easy to use.
Photo of Michael Horwitz

Michael Horwitz

  • 112 Points 100 badge 2x thumb
Why is zapier superior to just using the native quickbase webhooks?
Photo of John Rogers

John Rogers

  • 400 Points 250 badge 2x thumb
Because there are very few limitations that Dan knows better than I, that allow responses through URL response. Without that, you cannot access a payload that shows a response to filter without a middleman (Zapier or your own server).

Quickbase Webhook will take an action and send data based on the action.

Most APIs require an auth step, usually known as a Bearer token response, to resend the API with an authorized action.

The native Quickbase webhook cannot receive the response to .parse() to place into a bearer token. So Zapier handles this.

I can get into more detail if you need, email me JRogers@zoisolar.com
(Edited)