Forum Discussion

vijaysingh's avatar
vijaysingh
Qrew Cadet
6 years ago

QB App to API and Vice Versa

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.
  • 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?


  • AustinK's avatar
    AustinK
    Qrew Commander
    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?
    • vijaysingh's avatar
      vijaysingh
      Qrew Cadet
      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..
    • AustinK's avatar
      AustinK
      Qrew Commander
      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?
    • vijaysingh's avatar
      vijaysingh
      Qrew Cadet
      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.
  • 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.
    • ErichWehrmann's avatar
      ErichWehrmann
      Quickbase Staff
      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.
    • AustinK's avatar
      AustinK
      Qrew Commander
      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/
  • 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.
    • DonLarson's avatar
      DonLarson
      Qrew Elite
      We built a tool called Paasporter that extracts Quick Base data and builds a SQL DB.   Then you can hit that as your data source for Jira using any standard development tools.

      Reach out if you want a demo on the Extract to SQL.

      ------------------------------
      Don Larson
      Paasporter
      Westlake OH
      ------------------------------