Forum Discussion
AnshulGoyal
7 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
- AustinK7 years agoQrew CommanderHow 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.
- AnshulGoyal7 years agoQrew TraineeNothing 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