Using tMicrosoftCrmOutput to update many-to-many lookup
Hello,
I have a job in Talend Studio that is updating and inserting the appointments entity in Dynamics 365. We are using the tMicrosoftCrmOutput task and it works fine.
We now have a requirement to update the required attendees. Looking at the CRM API entity documentation, the required attendees (contact entity) are linked via an activityparty entity. However, the api does not allow the creation of activityparty entities and they have to be done via the appointment entity.
There are many examples online of how to do this via api calls in code, but I cannot get it working via Talend tMicrosoftCrmOutput. I have tried to do it via the Lookup Type Mapping but I'm not sure what format the field "appointment_activity_parties" should take. When I send a JSON array with the partyid_contact and participationtypemask, I receive an URISyntaxException:
Illegal character in scheme name at index 15: activityparties([{"partyid_contact": "6b1a32cc-ed0c-eb11-a813-000d3a6a9999", "participationtypemask": 5}])
So it seems that a JSON array is not the correct format. Is it possible to do this via Talend? If so, what format should the array be for a many-to-many lookup?
I am trying to set up a many to many relationship between the contact entity and a custom entity called Associations.
I want a contact to be associated with a multiple associations. I want an association to contain multiple contacts.
I created a custom entity called Association.
On the Associations entity I created a lookup field for Target Record Type Contact and placed that field on the Association form.
I then went into the Contact Tell Pizza Hut form and created a new looped field for Target Record Type Association and placed that field on the Contact form.
By using this approach I am not seeing all of the Associations records associated with a given contact record.
