Custom OData or SOAP API service to update custom code list value

[arvinth]

Dear Experts,

I would like to create Custom OData or SOAP API service to update Z custom fields code list (drop down list) values in yMKT Cloud from external systems.

Is it possible to update all Z custom fields code list values from external system via interface using OData or SOAP API?.

Many Thanks.

Kind Regards,

Arvinth

[isathore]

Hi,

Some of customers are using a Custom Business Objects to achieve custom code list. With the custom business object, you can upload data using the generated OData. You can then create a custom fields associated to the custom business object and you will get the coded values.

Check online documentation

https://help.sap.com/viewer/13d84c47bb6749a188fd53915c256516/2005.500/en-US/48eca577ced34a688afff8da...

https://help.sap.com/viewer/DRAFT/0f69f8fb28ac4bf48d2b57b9637e81fa/2008.500/en-US/b45696ca0d9143cba0...

and this blog post

https://blogs.sap.com/2018/07/20/batch-load-data-into-a-custom-business-object-in-sap-s4hana-cloud/

[KunalBansal]

Hello Arvinth,

For SAP Marketing Cloud, it's not possible to create a custom API.!

During creation of Custom Field, you have used a Business Context, e.g. Marketing: Contact, then use API_MKT_CONTACT_SRV after enabling ODATA usage and Field Usage.

best regards,

Kunal

[arvinth]

Hi Isabelle,

Many Thanks for the details.

Kind Regards,

Arvinth

[isathore]

Hi,

Sorry for the link. Here is the right link

https://help.sap.com/viewer/0f69f8fb28ac4bf48d2b57b9637e81fa/2005.500/en-US/b45696ca0d9143cba040797e...

I don't know a blog about the code list. You can search directly in the blog community. I just tried it and found the following

https://blogs.sap.com/2017/10/26/sap-s4hana-cloud-key-user-extensibility-custom-business-object-crea...

See also the online documentation on the reusable elements

https://help.sap.com/viewer/0f69f8fb28ac4bf48d2b57b9637e81fa/2005.500/en-US/0d8294c9417541ed8cd261f6...

https://help.sap.com/viewer/0f69f8fb28ac4bf48d2b57b9637e81fa/2005.500/en-US/1336241d97d34d779546a53f...

Best Regards

Isabelle

[former_member561510]

Hi Isabelle,

Many Thanks for the details. I am unable to access the link - it gives no authorization error for my S-user.

https://help.sap.com/viewer/DRAFT/0f69f8fb28ac4bf48d2b57b9637e81fa/2008.500/en-US/b45696ca0d9143cba0...

How can we upload data to the code list "YY1_TEST2" ?

The CBO field "Test_field" type is code list and ODATA service will be generated only for CBO field not for properties of the field e.g. YY1_TEST2.

Do you have any example blog? Please could you give me some more details.

Kind Regards,

Arvinth

[former_member226]

Hi,

As if now SAP Marketing Cloud do not provide you with SOAP or ODATA API to update Code List Data/Value from the external system. You have only 2 options:

• Either maintain manually for each of field defined in Customer Field and Logic app
• Or Do a manual CSV import.

You can considering opening an influence idea(https://influence.sap.com/sap/ino/#/campaign/38) for importing the code list data from API.

[arvinth]

Dear Tobias,

Thanks for the reply. This is not my requirement.

Actually we have many Z custom field code lists for many Business Context e.g. Campaign, Business Partner, Contact Profile, etc... Now we are uploading the code list values (from ERP) via down load and upload option marked in yellow in my screen shot.

This is manual tasks and we have to do it for every Z custom field code lists for every time whenever the code list value changes in ERP. We don't want to do it manually and want to automate this via possible interface.

Thanks.

Kind Regards,

Arvinth

[SCHNEIDERT]

Hi arvinth,

if you open your Custom Field in the Custom Fields and Logic app, switch from the "General Information" tab to the "OData APIs" tab. Here you can enable the field for different services (depending on the Business Context that Kunal mentioned above).

In this example it is a field of Context "Marketing: Contact"

After that you can call the Service and will see that your field is available there. So you can use it in CPI. Hope that makes it clearer.

BR Tobias

[arvinth]

Dear Kunal,

Thanks for the replay. Currently we have upload & download option for Z custom fields code list values. We want to automate this value upload via CPI interface.

Is there any other possibilities to achieve this in cloud?

Kind Regards,

Arvinth