Discussions

Expand all | Collapse all

QB App to API and Vice Versa

  • 1.  QB App to API and Vice Versa

    Posted 07-18-2019 19:24
    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.


  • 2.  RE: QB App to API and Vice Versa

    Posted 07-19-2019 13:30
    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?




  • 3.  RE: QB App to API and Vice Versa

    Posted 07-19-2019 16:20
    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?


  • 4.  RE: QB App to API and Vice Versa

    Posted 07-19-2019 17:57
    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..


  • 5.  RE: QB App to API and Vice Versa

    Posted 07-19-2019 22:43
    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?


  • 6.  RE: QB App to API and Vice Versa

    Posted 07-22-2019 13:01
    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.


  • 7.  RE: QB App to API and Vice Versa

    Posted 07-22-2019 15:46
    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.


  • 8.  RE: QB App to API and Vice Versa

    Posted 08-05-2019 15:10
    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.


  • 9.  RE: QB App to API and Vice Versa

    Posted 08-05-2019 19:47
    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.


  • 10.  RE: QB App to API and Vice Versa

    Posted 08-06-2019 16:11
    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/


  • 11.  RE: QB App to API and Vice Versa

    Posted 08-06-2019 18:59
    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.


  • 12.  RE: QB App to API and Vice Versa

    Posted 29 days ago
    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
    ------------------------------