+6
Hello Friends
Does any one know how to query managed metadata column?
I would like to update reviewers and approvers (people picker fields) based on discipline codes ( which is MMD field )
Any pointers?
Thanks
Best answer by TomaszPoszytek
View original
+17
You can get the values of the Managed Metadata column from the list/ library by REST API. You need to call it using the URL:
{SITE URL WHERE LIST IS PRESENT}_api/web/lists/getbytitle('{LIST NAME}')/items({ITEM ID})/{INTERNAL FIELD NAME}/LabelBuild a dictionary with a request header: Accept and value: application/json; odata=verbose
Then use the call http web service action to the above URL, GET, and with a request header. Then put your response content in a collection and get item from it using the path: d/Label.
If you have more than one value in the field, you will get a string delimited with semicolons (;). You can then use action to split it and receive another collection of single tokens from your MM column 
Piece of cake!
Regards,
Tomasz
+6
Dear Tomasz,
Thanks a lot for your inputs.
Is this possible in office 365?
+17
+17
+6
I am not a Developper yet and I find this REST solution a bit overwhelming.
+17
Unfortunately there is no OOTB action to do that for you... Don't be afraid to get familiar with REST web services. It may look very difficult at the beginning but has really high ROI (return on investment ) - once you learn it you will unleash a real power
P.S.
I'm not a developer either!
Regards,
Tomasz
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.