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.

Improve this question

2 Answers 2

Reset to default
1

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.

Improve this answer
3
  • 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
    Commented Jan 24, 2019 at 1:12
  • Thanks for some more context. I have updated my answer to reflect that
    – Lukas Lunow
    Commented Jan 24, 2019 at 7:49
  • Thank you @Lukas for such explanation. Will try for the above approach to get the task done.
    – A Vashisth
    Commented Jan 25, 2019 at 2:52
0

You can try CreateSalesforceObject using AMPscript for this.

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

Improve this answer
3
  • Thank you @Selim. Is there any other way like can use Rest/Soap APIs or any other recommended solution?
    – A Vashisth
    Commented Jan 23, 2019 at 7:47
  • @Selim: Why is it not recommended to store data in SC?
    – Lukas Lunow
    Commented Jan 23, 2019 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
    Commented Jan 23, 2019 at 11:33

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .