Add values in a custom field by the workato API
I have a GoogleSheet sheet that has as IdMat column, I wish I could copy this list and paste it into my custom field on
Wrike, which is a custom field of simple selection type.
For this, I created a recipe in Workato where I will proceed as follows:
GET ID CUSTOMFIELD in Wrike
GET ROWS from sheet in Google Sheets
Creat IdMat List (paste column ID from my Google sheets)
For each item in IdMat List: PUT method on the custom field to paste the IdMat list to it.
Only here, it does not paste the list but replace the already existing value.
What should I do to solve this problem? What parameter to enter the PUT method? And in the request body parameters?
Hey Solène Magin, welcome to the forums 🙂 Looks like none of our Community API experts have been able to help so far, so I've raised a ticket with our Support team for you, they'll reach out separately to advise 👍
Let me know if there's anything else I can help you with.
Lisa Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover
Lisa Wrike Team member Become a Wrike expert with Wrike Discover
Solène Magin What you are after is a PATCH (not PUT) which Wrike API does not support. To avoid overwriting already existing values you will need to read the values, save them somewhere, append the new values and post back the whole thing. Note that there is a 4000 char limit on the URL so depending on how many items you have and how king each one, it may not be possible.
Miron Mizrahi Community Team at Wrike Wrike Product Manager Conosci le straordinarie funzionalità di Wrike e le best practices
Miron Mizrahi Wrike Team member Conosci le straordinarie funzionalità di Wrike e le best practices