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 
  • AustinK's avatar
    AustinK
    Qrew Commander
    6 years ago
    How were you able to accomplish this? I'm just curious about the way you did it. I'm sure this question will come up again and you might help someone in the future if you post your solution.
  • 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