Skip to main content
Question

FormData API

  • February 12, 2019
  • 0 replies
  • 73 views
I am trying to create an API to return information from an outside URL. I have the string that returns the pertinent information.  I am a complete novice at this so I'm looking for help starting from the ground up. 

I create a formula URL and the fields that would hold the returned information, I just need help to have them speak to each other.

Thanks
    This topic has been closed for replies.

    Have you looked into using a Quick Base code page / db page rather than trying this with a formula?

    The process if I'm understanding it that you'll have to follow is:

    1) Make the request to the external system (likely using a GET or POST) - sounds like this is what you're already doing when you say you have a string that returns the pertinent information
    2) Parse the response to get the values you're looking for (i.e. Parse an XML or JSON response in some examples)
    3) Take that data and make an EditRecord call back into Quick Base into the fields you set up

    You could theoretically do that in a Quick Base formula, but the syntax is really tricky and even harder to debug / log out. With a quick base code page, you can still have the user click a button, but when clicked it would call out to this code page where you have more flexibility. 



    Chayce Duncan | Technical Lead
    (720) 739-1406 | chayceduncan@quandarycg.com
    Quandary Knowledge Base
    Forum|alt.badge.img+4
    Hello, just wondering if you were able to create the API?

    I have a similar project in mind, but need to build an API to extract data from a quickbase record to a POST form.  

    Jeff

    ------------------------------
    JRogerson JRogerson
    ------------------------------
    Terms & ConditionsAccessibility statement