QB App to API and Vice Versa

  • 0
  • 1
  • Question
  • Updated 2 weeks ago
  • In Progress
There is a request from user to access a third party API through one of the QB application and probably would require to populate some of the fields from QB table to their application. Also need to do the same in reverse order as well where need to get some of the third party application data back to the QB app.. This process needs to be repeated couple of times..Would like to know step by step process/approach to handle this kind of request.
Photo of vijay singh

vijay singh

  • 342 Points 250 badge 2x thumb

Posted 4 weeks ago

  • 0
  • 1
Photo of vijay singh

vijay singh

  • 342 Points 250 badge 2x thumb
Hi All.. If you can take a look at this request and guide with the details.

Also, would like to know if API's can be setup for these services only as mentioned in the QB (see attached). 

Let's say when you click on a New Table and try to connect to a third party API and the service is not listed for the connection to QB.. What needs to be done in that scenario. Will QB team add that service upon notification/ticket?


Photo of AustinK

AustinK

  • 2,214 Points 2k badge 2x thumb
You can request that they add connectors/services but I would not expect it to happen right away. It might never happen.

These are just easier ways of setting up a connection to a service. You can absolutely still do it yourself via the API. There are a lot of different options, it just depends what you are trying to connect to.

What service are you trying to use?
Photo of vijay singh

vijay singh

  • 342 Points 250 badge 2x thumb
Thanks Austin.. Will it be possible for you to connect for 10-15 min to walk me through on how to use an API .. May be a simple example to show where exactly i need to go to start with in the QB app.. 

Would you like to share your number.  I will call..
Photo of AustinK

AustinK

  • 2,214 Points 2k badge 2x thumb
https://help.quickbase.com/api-guide/intro.html

What service are you trying to connect to? Chances are you are not the first one to try it and there may even be some good resources on this forum.

Another question would be, what are you planning on using for this? JavaScript in the browser like a button in QuickBase or a Code Page? Or are you wanting to make a program that just sits there and does API calls every now and then and updates records? Are you comfortable coding in any languages currently?
Photo of vijay singh

vijay singh

  • 342 Points 250 badge 2x thumb
Hi Austin..

It's not yet finalized, under discussion but i can see we are probably going to connect to a contract management application through QB.. We would need to read and write the data in QB and to that application both. 

I am not from Java background however i could understand and try to code as needed..

As i am new to QB and not aware of how to use API, thought of having a quick call and understand if someone has to use it, how to start, where to go in QB and what needs to be called/used to connect to a third party app.. What are different ways of doing it .. Once I have that knowledge, would be able to explore available options but need to get the initial heads up at the first place.
Photo of AustinK

AustinK

  • 2,214 Points 2k badge 2x thumb
Your best bet might be to look into the QuickBase University. If you only really care about the API right now then check out https://university.quickbase.com/series/data-integration. You can also try searching this forum for the specific app name you are wanting to connect to.

There are many different ways to use the APi and a bunch of different SDKs on Github if you are more comfortable with another language. Most are not updated though.

I understand a call would probably be easier for you. You could try to contact Quickbase Coach or someone else like that and see if they can help with that or possibly an email.
Photo of vijay singh

vijay singh

  • 342 Points 250 badge 2x thumb
Has anyone connected Quick Base to JIRA, as JIRA is not listed in the services list for Quick Base connect/sync. If you can advise and share the details.
Photo of Erich Wehrmann

Erich Wehrmann

  • 76 Points 75 badge 2x thumb
Hi Vijay,
You will need a separate tool to integrate QB with JIRA. There are many options for this such as: an integration platform like Workato or Informatica, a workflow tool like Zapier or MS Flow, or writing your own custom code and publishing it to a sever.
Hope that helps.
(Edited)
Photo of AustinK

AustinK

  • 1,994 Points 1k badge 2x thumb
You can communicate between QuickBase and Jira using only webhooks. It just depends on what you want to do. If you want to send ticket statuses and who is working on what that is possible but without an integration like Erich is talking about you are somewhat limited.

You can read this thing below to see what can be sent via simple webhooks from or to Jira.

https://developer.atlassian.com/cloud/jira/platform/webhooks/
Photo of Ryan Stanford

Ryan Stanford

  • 1,992 Points 1k badge 2x thumb
The Data Services like you mentioned above are also generally only for QB to read in, not to update that source.

We generally use SQL Server as our own go between in cases such as this.