Skip to main content
Question

Stacked API Call URL Formula

  • September 18, 2020
  • 0 replies
  • 74 views

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 topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------