Discussions

Expand all | Collapse all

Stacked API Call URL Formula

  • 1.  Stacked API Call URL Formula

    Posted 09-18-2020 04:24
    HI,

    Just a quickie.

    Will this work as a methodology to call multiple QB APIs from a single formula field button?

    var text URLONE = ""; //insert api call one
    var text URLTWO = ""; //insert api call two
    var text URLTHREE = ""; //insert api call three
    var text URLFOUR = ""; //insert api call four
    $URLONE & "&rdr=" & URLEncode($URLTWO & "&rdr=" & URLEncode($URLTHREE & "&rdr=" & URLEncode($URLFOUR)))

    And if my logic is correct, does anyone know if there is any limit as to how far this methodology can be taken, or is the only limit the size of the URL field code?

    David


    ------------------------------
    dmlaycock2000 dmlaycock2000
    ------------------------------


  • 2.  RE: Stacked API Call URL Formula

    Posted 09-18-2020 07:31
    This us the correct syntax

    $URLONE 
    & "&rdr=" & URLEncode($URLTwo)
    & URLEncode("&rdr=" & URLEncode($URLThree))
    & URLEncode(URLEncode("&rdr=" & URLEncode($URLFour)))
    & URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLFive))))
    & URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLSix)))))
    & URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLSeven))))))
    & URLENcode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLEight)))))))
    & URLENcode(URLENcode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLNine))))))))
    & URLENcode(URLENcode(URLENcode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLTen)))))))))
    & URLENcode(URLENcode(URLENcode(URLENcode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLEleven))))))))))



    As for  the limit, I can't say for sure. I know I have gone to 12 deep to add 12 monthly children.

    at one time IE Browser had a limit of 2,000 characters and with all the successive URLEncoding, the strings gets very long.

    I suggest if you are going beyond 12 to try to use an Automation instead. 


    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Stacked API Call URL Formula

    Posted 09-18-2020 07:53
    Thanks Mark,

    Implemented and working with Import API to 5 levels.

    (-:

    D

    ------------------------------
    dmlaycock2000 dmlaycock2000
    ------------------------------