ODATA field for Channel

[shenu]

Hi Experts,

I am unable to find the ODATA field for C4C channel field (configurable for tickets created via E-mail). Could you please guide me where I can find the technical name?

Thank you!

[former_member226]

Hi,

Email Channel for Service Request is not directly exposed in OData. You may need to raise an influence idea for the same.

However, it is still possible to fetch "EMail Channel" for a particular ticket ID but a little bit complexity is involved. Steps are as follow:

1. Get the service request UUID based on Ticket ID:

https://my3XXXXX.crm.ondemand.com/sap/c4c/odata/v1/c4codataapi/ServiceRequestCollection?$filter=ID eq '5109'

2. Based on UUID retrieved above, form the URL predecessor email activity as follow:

https://my3XXXXX.crm.ondemand.com/sap/c4c/odata/v1/c4codataapi/ServiceRequestCollection('00163E063FDC1EE48FB7E13214A7D3F1')/ServiceRequestBusinessTransactionDocumentReference?$filter=(TypeCode eq '39' and RoleCode eq '2')

Copy the ID field from response. It is the email recived ID.(lets say 372)

3. Get the Email Activity Object for the ID retrieved in last step using:

https://my3XXXXX.crm.ondemand.com/sap/c4c/odata/v1/c4codataapi/EMailCollection?$filter=ID eq '372'

4. Get the UUID from the response of step 3 and form the following URL ( this will give you the "to" parties of the email)

https://my3XXXXX.crm.ondemand.com/sap/c4c/odata/v1/c4codataapi/EMailCollection('00163E063FDC1EE48FB7E132149F73F1')/EMailToRecipients

from here copy the EMailID field and save it.

5. Finally, Create a new custom OData using "Administrator"-->"Odata Service Explorer" on top of BO SocialMediaActivityProvider and pass the email ID retrieved from step 4 to get the required channel name.

Thanks

Saurabh

[kushal_jiwane2]

Hi Shenu,

In Service request collection check for the DataOriginTypeCode field

[shenu]

Hi Kushal,

Thank you for your response. Unfortunately, the field you mentioned is for source but I am looking for the channel- that comes under specific Source 'Email'- such as email addresses for different lines of business. Let me know if you need some more clarity

Thanks