Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
Chiru1
Contributor
Contributor

Marketo data load issue with Talend-tMarketoinput

Hi,

When we are trying to load Marketo delta load(Lead changes) using Talend tMarketoinput component with getleadchanges option based on since datetime.We are getting bellow NumberFormatException with ID out of range.

I am able to successfully load full records using getMultipleLeads.

Can you please help me how to resolve this issue to load lead changes based on updatedat using Marketo API call.

"Caused by: java.lang.NumberFormatException: Expected an int but was 3100478910 at line 1 column 60 path $.result[0].id"

0695b00000KAVBPAA5.png0695b00000KAVBKAA5.png

Labels (2)
1 Reply
gjeremy1617088143

Hi, int have a value limit :

I think it's 2147483648

so you have a out of range value here 3100478910, so use long instead of int.

Send me love and kudos