Forum Discussion

RyanFarrington's avatar
RyanFarrington
Qrew Member
5 years ago

Is there a limit to number of fields you can specify in a GET-method API_AddRecord?

I'm making a button that creates a new record using the GET method. I'm using API_AddRecord. I want to specify the values for 13 fields, but it seems the operation stops after 7 fields. It creates the...
APIs and custom code
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
I suggest that you URLEncode and field which has the possibility to contain special characters or spaces.

var text URLONE = // create the client
    URLRoot() & "db/" & [_DBID_CLIENTS] & "?a=API_AddRecord&apptoken=XXXXXXXXXXXXXXXXXXXXXXXXX"
    & "&_fid_89=" & [Related Payment Term]
    & "&_fid_99=" & [Tax Code]
    & "&_fid_6=" & urlencode([Company Name])
    & "&_fid_62=" & urlencode([Lead Source])
    & "&_fid_126=" & UserToEmail(User())
    & "&_fid_33=Prospect"
    & "&_fid_38=" & URLEncode([Industry])
    & "&_fid_37=" & urlencode([Website])
    & "&_fid_43=" & UserToEmail(User()) //Account Lead
    & "&_fid_83=" & UserToEmail(User()) //Project Manager
    & "&_fid_18=" & urlencode([Billing Address])
    & "&_fid_25=" & urlencode([Billing Address])
    & "&_fid_173=" & [Record ID#]
    ;


var text URLTWO = ....;

$URLONE
& "&rdr=" & URLEncode($URLTWO)



I don't use your syntax with the linkaway so i don't know if that will work or not.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
RyanFarrington's avatar
RyanFarrington
Qrew Member
5 years ago
Hi Mark, as you suggested, I added URLEncode to questionable fields. But it still doesn't write anything beyond the 7th field.

The linkaway is to get the form to save before continuing, and that works fine.

------------------------------
Ryan Farrington
Graphic designer, project manager, copywriter, engraver, internal Quick Base developer
rfarrington@experiencepinpoint.com
------------------------------