0

Could you please help me to solve my problem? I have to upload the data from a Marketing Cloud data extension to a CRM object. How I can achieve this if my Marketing Cloud and CRM are integrated with the connector?

Your help would be really appreciated.

0

If you want to do it in bulk, e.g iterating through 10.000 records in a Data Extension, and upsert data to Sales Cloud, you should be using it's Bulk API

With regards to the use of SSJS with REST, there are numerous examples here on SFSE, a.o.:

Making a REST API call from a Script Activity in Automation Studio

REST API Methods in AMPScript or SSJS

You can use AmpScript function: UpdateSingleSalesforceObject and either execute it from an email, Cloud Page, or wrap it in SSJS, if you want to use it in Automation Studio - the latter as suggested here by Adam Spriggs: SSJS script to update Salesforce object . This function works on any objects - both standard and custom, so I assume it will also be able to update your Veeva data.

Using UpdateSingleSalesforceObject will not count towards your API limits on Sales Cloud.

  • Thanks @Lukas to give some hint. I may not have to upload the bulk data.. we want to upload suggestions into Veeva CRM Suggestion object. Any idea, is this possible through bulk API to load the data into veeva suggestion object or any other simple solution. – A Vashisth Jan 24 at 1:12
  • Thanks for some more context. I have updated my answer to reflect that – Lukas Lunow Jan 24 at 7:49
  • Thank you @Lukas for such explanation. Will try for the above approach to get the task done. – A Vashisth Jan 25 at 2:52
0

You can try CreateSalesforceObject using AMPscript for this.

Yet, it is not recommended to store the data in Sales Cloud.

  • Thank you @Selim. Is there any other way like can use Rest/Soap APIs or any other recommended solution? – A Vashisth Jan 23 at 7:47
  • @Selim: Why is it not recommended to store data in SC? – Lukas Lunow Jan 23 at 10:08
  • Sorry, I should have explained it much more. I meant, because it is expensive to store data in SalesCloud, people prefer storing data in Marketing Cloud. – Selim Sevim Jan 23 at 11:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.