4

I'm querying on Contact object where the results are varying on Bulk API vs querying on developer console. Total records on Contact is 997820.

Query on developer console:

select count(id) from contact WHERE SystemModstamp <= 2018-11-09T04:41:54Z

yields 997820 records.

Query on Bulk API:

select id, name from contact WHERE SystemModstamp <= 2018-11-09T04:41:54Z

yields 997812 records.

Query2 on Bulk API:

SELECT Id, IsDeleted, MasterRecordId, AccountId, LastName, FirstName, Salutation, Name FROM Contact WHERE SystemModstamp <= 2018-11-09T04:41:54Z

yields 997820 records.

Why is there a disparity in the records that are retrieved through Bulk API?

P.S.: I have also tried getting records through SOAP API with the same set of parameters: query operation (not queryAll). SOAP API retrieves 997812 records. The records that are missed are not deleted (isDeleted = false)

  • Are you using queryAll() for bulkAPI? – codeyinthecloud Nov 9 '18 at 15:44
  • No. It is "query" for Bulk API. – dmachop Nov 9 '18 at 15:52
  • is it an active sytem where records are still being inserted deleted? – Pranay Jaiswal Nov 9 '18 at 18:05
  • You're definitely authenticated as the same user for the Bulk API as you're using in Developer Console, right? – David Reed Nov 9 '18 at 20:56
  • @PranayJaiswal Apparently, there were no specific changes that are being made to the object. – dmachop Nov 12 '18 at 15:56

Your Answer

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

Browse other questions tagged or ask your own question.