Marketo BigInt/64-bit Integer | Community
Skip to main content
D
deepabgn23
New Participant
January 30, 2021
Solved

Marketo BigInt/64-bit Integer

  • January 30, 2021
  • 1 reply
  • 1233 views

Does Marketo support bigint data type? The data will be coming from Hadoop

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by SanfordWhiteman

Simply put: No. Integers are signed 32-bit. Scores, though misdocumented as if they're signed 64-bit, cannot be updated beyond 32-bit via API.

 

But I wonder what you're expecting to do with these 64-bit types. If you only need to store them in Marketo and output them in emails, you can use a String, although that won't allow you to use them in numeric filters. Using a String will, perhaps surprisingly, allow you to treat them as BigIntegers in emails (i.e. you can add/subtract/whatever with them) because Velocity can cast a String to a BigInt.

1 reply

SanfordWhiteman
SanfordWhitemanAccepted solution
New Participant
January 30, 2021

Simply put: No. Integers are signed 32-bit. Scores, though misdocumented as if they're signed 64-bit, cannot be updated beyond 32-bit via API.

 

But I wonder what you're expecting to do with these 64-bit types. If you only need to store them in Marketo and output them in emails, you can use a String, although that won't allow you to use them in numeric filters. Using a String will, perhaps surprisingly, allow you to treat them as BigIntegers in emails (i.e. you can add/subtract/whatever with them) because Velocity can cast a String to a BigInt.

Terms & ConditionsAccessibility statement

Loading footer...