Forum Discussion
AnshulGoyal
6 years agoQrew Trainee
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
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
6 years agoQrew Trainee
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
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