Updating customfield in update_item API call

[Steven Hicks]

We have Location as a relationship on the Item and I need to update all items with the locations/entities that are allowed to use it. The relationship is many-to-many.

I'm able to add one location to an item via API, but all attempts to add a second or more fail. Below is part of the call.

Any suggestions? 

<update_item itemid="1006">
  <customfields>
    <customfield>
      <customfieldname>RLOCATION</customfieldname>
      <customfieldvalue>384#~#621</customfieldvalue>
    </customfield>
  </customfields>
</update_item>

 

[Lee Savidge]

What type of field is RLOCATION? To use the #~# string concatenation, it would need to be a multi-select list.

[Steven Hicks]

It's a many-to-many relationship between an ITEM and LOCATION. I can add multiple locations to an ITEM, but I think I have to add them one at a time.

[Jeff Hartman]

Steven, I would typically update one item at a time and include combinations of individual items and the respective RLOCATION value (generally the record no)  in one request.