Forum Discussion

AnshulGoyal's avatar
AnshulGoyal
Qrew Trainee
6 years ago

send multiple values (multi select field) for a field through Quickbase API (preferably using URL)

Hello Community Members, I am trying to use Quickbase API (using Tableau) to be able to edit a record in Quickbase tables. I am able to send the request for single select fields but one of the fiel...
APIs and custom code
AnshulGoyal's avatar
AnshulGoyal
Qrew Trainee
6 years ago
Hi Austin,

Please ignore my previous message. I was not constructing the correct URL for API call. I am able to send multiple values to a single field now. Thanks again!!!

Regard
Anshul 
AnshulGoyal's avatar
AnshulGoyal
Qrew Trainee
6 years ago
Nothing fancy actually. I am just using Tableau's URL action to build a URL like this:
https://<rooturl>/db/?<dbname>a=API_EditRecord&rid=1434&rl=ee2&am...time>&_fnm_Publishing_Status_Done_By=<Username>&_fnm_Publishing_Status_Notes="<Publishing Status Notes>"&_fid_114=<Publishing Status_Multi>&_fnm_Publishing_Status_Feedback=<Publishing Status Feedback>&apptoken=<apptoken>

For multi-select field (_fid_114), earlier I was trying to send multiple values for this field but I was using the actual field name (Publishing Status). On changing the field name to field ID, I was able to update QB table with multiple values. Not sure but QB may be only expecting field-id to update multiple values for any field. Please let me know if you need any more details. Happy to share!!!

Regards
Anshul