topic Re: Qlikview MarketO Connector in QlikView

Qlikview MarketO Connector

Mon, 26 Jan 2026 21:26:37 GMT

Hi,

I'm in the process of building a connector which can get the lead data from MarketO. While I could build the connector successfully and get the data, I've an issue while trying to query the connector with a condition from the connector from Qlikview editor. My aim is to filter out records based on a time window and I get a QVX syntax error

QVX_SYNTAX_ERROR:

Invalid query: SELECT * FROM ActivityDetails where ActivityDateTime >

'10/12/2013 07:00:00 AM' AND ActivityDateTime < '10/12/2013 07:30:00 AM';

I get the data correctly if I don't use the where condition in the query (SELECT * FROM ActivityDetails;)

Can some body please tell me how can implement this?

Thanks,

John

Re: Qlikview MarketO Connector

Anonymous — Tue, 12 Nov 2013 23:18:35 GMT

Hi, it may be that your time format is not correct. I built a vbscript macro in QV to query the Marketo SOAP API. In that script I needed to format the time like this: 2013-04-10T11:43:03-06:00 otherwise the Marketo API would not accept it.

Let me know if you need anymore help building the QVX. It is definitely something worth doing!!

Regards,

John McTurnan

Re: Qlikview MarketO Connector

Wed, 13 Nov 2013 19:12:37 GMT

Hi John,

Thanks for your suggestions.

My issue is that, if I hardcode the date in the connector in the format I mentioned in my mail, it works fine however if I need to pass it from the QlikView editor it fails.

I'll try change the format as you suggested from the editor and let you know if that resolves the issue.

Regards,

John George

Re: Qlikview MarketO Connector

Fri, 15 Nov 2013 16:39:59 GMT

Hi John.

I tested with the modified query and still getting the same error. Following is the statements that I used in the qlikview editor

-------------------------------------------------------------------------------------------------------------------------

SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;($#,##0.00)';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

CUSTOM CONNECT TO "Provider=MarketOActivityConnector.exe;XUserId=JPFTXbD;XPassword=RVGDBOB;";
SQL SELECT *
FROM ActivityDetails
WHERE where ActivityDateTime > '2013-12-10T11:43:00-00:00'
AND ActivityDateTime < '2013-12-10T11:45:00-00:00 ';

-----------------------------------------------------------------------------------------------------------------------

Folowing is the error message

QVX_SYNTAX_ERROR: Invalid query: SELECT *

FROM ActivityDetails

WHERE where ActivityDateTime > '2013-12-10T11:43:00-00:00'

AND ActivityDateTime < '2013-12-10T11:45:00-00:00 '

SQL SELECT *

FROM ActivityDetails

WHERE where ActivityDateTime > '2013-12-10T11:43:00-00:00'

AND ActivityDateTime < '2013-12-10T11:45:00-00:00 '

--------------------------------------------------------------------------------------------------------------------------------

Let me know in any way you can help me on this?

Thanks,

John

Re: Qlikview MarketO Connector

Anonymous — Fri, 15 Nov 2013 16:52:54 GMT

Try this... Salesforce likes its dates without single quotes around them. Like this example:

SQL SELECT *

FROM Lead

WHERE

ConvertedOpportunityId != NULL

AND

CreatedDate >= 2012-04-01T00:00:00.000+00:00

Regards,

John

Re: Qlikview MarketO Connector

shawn_merkle — Wed, 20 Nov 2013 17:57:22 GMT

Perhaps the double where is causing the syntax error?

WHERE where ActivityDateTime > '2013-12-10T11:43:00-00:00'

Re: Qlikview MarketO Connector

Wed, 20 Nov 2013 18:48:12 GMT

No John. I still have the issue and what I'm not sure is that whether I'll be able to filter out the records by using a query from the QlikView editor..

When I compare the MarketO connector I built with the salesforce one, I think the way I get the data and the way salesforce connector gets the data is different. It is my assumption that behind the screen salesforce connector issues some kind of SQL query to the underlying database to get the results so when you issue the query "SELECT * FROM Lead WHERE CreatedDate >= 2012-04-01T00:00:00.000+00:00" the QlikView editor pass this query to the connector and get the data.

While in the case of MarketO, there is no way to send a direct query to their underlying databases to get the results. So I'm using the web services for that and I'm using getLeadChanges method. This method accepts many parameters and I'm trying to use the latestCreatedAt and oldestCreatedAt date parameters. If I hard code these parameters in the connector it works fine. But my intension is to pass this parameters from the QLikView editor and has no success in it.

Hope I'm explaining it clearly. I will really appreciate you throwing any ideas or suggestions that help me to resolve this.

Regards,

John

Re: Qlikview MarketO Connector

Wed, 20 Nov 2013 18:49:29 GMT

Thanks Shawn for your suggestions. I tried it without the quotes and still gives me the same error.

Re: Qlikview MarketO Connector

shawn_merkle — Wed, 20 Nov 2013 19:10:07 GMT

John V not the double quotes but the fact that Where is in the line of code twice.

WHERE where ActivityDateTime > '2013-12-10T11:43:00-00:00'

Re: Qlikview MarketO Connector

Sun, 24 Nov 2013 17:40:44 GMT

Thanks Shawn for noticing it. However I still get the same result when I ran the corrected query

QVX_SYNTAX_ERROR: Invalid query: SELECT *
FROM ActivityDetails
WHERE ActivityDateTime > '2013-12-10T11:43:00-00:00'

SQL SELECT *
FROM ActivityDetails
WHERE ActivityDateTime > '2013-12-10T11:43:00-00:00'
-------------------------------------------------------------------------
QVX_SYNTAX_ERROR: Invalid query: SELECT *
FROM ActivityDetails
WHERE ActivityDateTime > 2013-12-10T11:43:00-00:00

SQL SELECT *
FROM ActivityDetails
WHERE ActivityDateTime > 2013-12-10T11:43:00-00:00

John

Re: Qlikview MarketO Connector

Anonymous — Thu, 19 Dec 2013 16:11:38 GMT

Hi John,

How is the progress coming on your issue and creating the connector overall? I am considering building a Marketo connector as well.

Regards,

John McT

Re: Qlikview MarketO Connector

Fri, 20 Dec 2013 18:03:01 GMT

Hi John,

I don't know how to resolve the issue that I'm facing with the connector and I don't think it is possible to make the connector work the same way as a salesforce connector.

Apart from this, the connector I developed works fine. It gets the leads records from the MarketO Instance for a specified period. Only thing I'm missing is the ability to pass a query from the QlikView editor and get the results like the salesforce one. If you find a solution for this, please let me know.

Thanks,

John

Re: Qlikview MarketO Connector

Anonymous — Fri, 20 Dec 2013 20:35:04 GMT

John,

It is great new you have a working connector able to use the getMultipleLeads call.

I've read through all the API docs for Marketo and have even spoken with some of their product managers. Although I have not asked Marketo themselves, I'm 90% sure their SOAP API does not support any sort of SQL or SOQL query. I was hoping/assuming you had discovered something I was unaware of.

I'd love to discuss how you did the connector further as I have never done a QVX before. Send me an email at jmm9837498@mcturnan.net

Regards,

John

Re: Qlikview MarketO Connector

Sat, 21 Dec 2013 00:09:54 GMT

Hi John,

I've sent you an email and it got bounced back. If you want to reach me, send me an email at jgeorge@clouddbconsultants.com

Thanks,

John

Re: Qlikview MarketO Connector

Anonymous — Wed, 14 May 2014 13:16:48 GMT

Hi John,

I am trying to connect to Marketo and get data, can you please help me out and can you please email me the Qlikview Marketo connector exe. my email address is surender7@yahoo.com

Thank you so much,

Surender

Re: Qlikview MarketO Connector

Anonymous — Wed, 03 Sep 2014 20:38:58 GMT

Hi John,

I am trying to connect to Marketo and get data, can you please help me out and can you please email me the Qlikview Marketo connector exe. my email address is surender7@yahoo.com

Thank you so much,

Surender

Re: Qlikview MarketO Connector

scottduthie — Wed, 27 Oct 2021 17:57:50 GMT

I know this is a very old post - but did anyone ever find a resolution? I am having the same issue with my query to Marketo not accepting the date format that is specified in the Marketo documentation.

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';