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)

6
  • Are you using queryAll() for bulkAPI? Nov 9, 2018 at 15:44
  • No. It is "query" for Bulk API.
    – dmachop
    Nov 9, 2018 at 15:52
  • is it an active sytem where records are still being inserted deleted? Nov 9, 2018 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, 2018 at 20:56
  • @PranayJaiswal Apparently, there were no specific changes that are being made to the object.
    – dmachop
    Nov 12, 2018 at 15:56

0

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.