Question Re: SAP Marketing Cloud: How to Mass update the Business User attributes in CRM and CX Q&A

SAP Marketing Cloud: How to Mass update the Business User attributes

former_member576423 — Wed, 01 Jul 2020 07:05:39 GMT

Hello SAP,

I want to update the Timezone and Dateformat for 400 business users in SAP Marketing Cloud. How can we do it. In the upload file, there is no field available to update these details.

Any assistance is appreciated

Re: SAP Marketing Cloud: How to Mass update the Business User attributes

SCHNEIDERT — Wed, 01 Jul 2020 07:46:04 GMT

Hi Mayank,

not 100% sure and never done by myself but I think it could work using the Communication Scenario SAP_COM_0193.

You should be able to use the Endpoint. https://my123456-api.s4hana.ondemand.com/sap/bc/srt/scs_ext/sap/managebusinessuserin

Here you can find the documentation to the SOAP API on API Hub.

Hope that helps.

BR Tobias

Re: SAP Marketing Cloud: How to Mass update the Business User attributes

former_member226 — Wed, 01 Jul 2020 21:31:28 GMT

Hey,

As mentioned by Tobias you can use communication arrangement SAP_COM_0193 OR SAP_COM_0093 in order to update the business user. You need to use the soap service https://XXXX-api.s4hana.ondemand.com/sap/bc/srt/scs_ext/sap/managebusinessuserin .

A sample request can look like this:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:aba="http://sap.com/xi/ABA">
   <soapenv:Header/>
   <soapenv:Body>
      <aba:BusinessUserBundleMaintainRequest_sync>
         <BusinessUser actionCode="02">
            <PersonID>9980000071</PersonID>
            <User actionCode="02" roleListCompleteTransmissionIndicator="false">
               <UserName>MURPHY</UserName>
               <DateFormatCode>A</DateFormatCode>
               <TimeZoneCode>UTC</TimeZoneCode>
            </User>
         </BusinessUser>
      </aba:BusinessUserBundleMaintainRequest_sync>
   </soapenv:Body>
</soapenv:Envelope>

Pls also check https://help.sap.com/viewer/f1531d40f450474dbf95f0404cb62007/2005.500/en-US/640fb5fa26664a7486de073b1882405c.html for possible values for DateFormatCode or actionCode values.

Once success fully updated then SOAP UI should give you a message: "Employee XXXXX successfully changed."(as attached)

soap-result.png

Thanks

Saurabh

Re: SAP Marketing Cloud: How to Mass update the Business User attributes

former_member576423 — Thu, 02 Jul 2020 06:37:23 GMT

Thanks Tobias. It worked!!

Re: SAP Marketing Cloud: How to Mass update the Business User attributes

former_member576423 — Thu, 02 Jul 2020 06:37:44 GMT

Thanks Saurabh!!! All good..