Hi. I'm having a really weird bug with the `tap-saleforce` extractor (Meltano Labs variant). For a ...
m
Hi. I'm having a really weird bug with the
tap-saleforce
extractor (Meltano Labs variant). For a particular object, I'm getting several rows less when using the tap (both REST/BULK) than when compared to running a query on the object using Postman. These missing rows are
IsDeleted = TRUE
. Now I've tested this with the REST, BULK and BULK V2 APIs in Postman even though I know the tap uses the old BULK API/REST. I also tested the BULK API using version 53.0 in Postman (the same version as the tap) and I got the entirety of the rows (including the deleted). I looked at the tap-salesforce source code and the
queryAll
operation is being used which should return everything including deleted records. Finally the strange thing is that this issue is only affecting this one single object, the rest have all the records including deleted. @dan_mosora This is driving me crazy. It's not an issue with a loader because I can see from the logs the number of records extracted. I'm hoping somebody has some insights because I've spent several days trying to figure out why this is happening!