Forum Discussion

SystemAdmin4's avatar
SystemAdmin4
Qrew Member
5 years ago

Stacked API Call URL Formula

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
------------------------------
  • 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
    ------------------------------
    • SystemAdmin4's avatar
      SystemAdmin4
      Qrew Member
      Thanks Mark,

      Implemented and working with Import API to 5 levels.

      (-:

      D

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