Hi, I’m working with the singer `tap-pardot` and I...
# troubleshooting
m
Hi, I’m working with the singer
tap-pardot
and I noticed that it’s mishandling dates in the api call causing it’s `UpdateAtReplicationStream` to fail. Basically, the bookmark state is being stored as
date time
so the api calls are sorting incorrectly. It needs to be
dateTtimeZ
(e.g.
2020-01-01T00:00:00Z
). I guess I’m wondering if this is an issue with the tap OR if I’m missing a setting in Meltano somewhere.
Ok, so I actually figured this out…what the problem is, not really how to fix it. The pardot API take a parameter
updated_after
and it needs to be in the format above (
2021-01-01T00:00:00Z
) BUT it returns values in the format
2021-01-01 00:00:00
which is where the tap gets the most recent bookmark. I’m guessing there’s a way to overwrite some of the formatting but I haven’t found it yet.