You need to sign in to do that
Don't have an account?
Vishalg89
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
One option I can think of is Web services. Ask other sf to generate a wsdl/method using which you can read their table
That's alright, but can WSDL support to call more than 50,000 record at a time?
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
Vishal,
Did you find a solution? if so please let me know how you solved this issue.
I did it using bulk rest api.