+ Start a Discussion
Vishalg89Vishalg89 

query data from one salesforce to other salesforce

please have a look at my situation:

 

Account_Company_Name__c(My salesforce) and Company_Name__c(Other Salesforce) are the common fields that we need to look.
we need to check for both accounts if these fields matches then we need to update Status__c(My Salesforce) set to true and getting back the data from Company_Notes__c(other salesforce) to Notes__c(My Salesforce).
we have more that 50,000 accounts on both side.

 

please give me best approach to achieve this.

 

 

Thanks

Vishal Gupta

sflearnersflearner

One option I can think of is Web services. Ask other sf to generate a wsdl/method using which you can read their table

Vishalg89Vishalg89

That's alright, but can WSDL support to call more than 50,000 record at a time?

sflearnersflearner

I dont know if RESTful API can be used here to retrieve so many records as XML, but maybe you can query use Bulk API and parse xml response using xmlstreamreader!! just an idea

sflearnersflearner

Vishal,

 

Did you find a solution? if so please let me know how you solved this issue.

Vishalg89Vishalg89

I did it using bulk rest api.