Qlik SaaS - Marketo Connector - How to Filter Query on Dates

[scottduthie]

Hi Community,

Has anyone successfully queried Marketo using the Marketo connector in Qlik SaaS and managed to filter the query results based on a date

Based on Marketo documentation the date format should be passed as ISO 8601 format (https://developers.marketo.com/rest-api/lead-database/fields/field-types/), so an example would be '2010-05-07T15:41:32-05:00'.

I know I have a lead in Marketo last updated at '2021-10-25T20:21:12-00:00', so this is the query below that we are running - it returns an error '(Connector error: Failed to move reader [Simba][JSQLEngine](13030) Invalid character value for cast specification.)' suggesting that the format is incorrect.

Data:
LOAD *;
SELECT
Id,
Full_Name,
updatedAt
FROM "Marketo".Leads
WHERE updatedAt = '2021-10-25T20:21:12-00:00';

Any ideas what's going on here?

[scottduthie]

Hi @chrisbrain  - given your web connector genius I thought you might have some insight on our issue, any ideas?