API Documentation - How to find out max field length?

[xceled]

Hello,

I'm consuming the REST API for various integrations in in some cases have to store data locally. I'd like to have my DB schema match the max lengths of Marketo data but am having issues finding how to determine the max field length of various data fields returned via the API. Can anyone suggest and approach or resource to assist here?

[Floyd_Alvares2]

@xceled 

Is this information what you might be looking for? https://nation.marketo.com/t5/knowledgebase/marketo-field-limits-by-field-type/ta-p/251613

[SanfordWhiteman]

The actual field limits aren’t what the Describe Lead API indicates, though it’s a start (no string is shorter that what Describe returns, at least). Unfortunately, the doc Floyd linked to isn’t completely accurate either.

I’ve written a few blog posts about “Marketo field limits in the real world” (you can search for that) but never had a chance to write about each and every system field + datatype. Your best bet is to use NCLOB/NVARCHAR(MAX) for strings, BigInt for scores/integers (even though they’ve recently shrunk back to Int, to my dismay) and Float64 for float/currency (even though they’re actually Float32, at some point they’re gonna have to expand so you should be prepared).

[xceled]

Thank you @SanfordWhiteman for the information, I wish they would use swagger to document the response model field limits. 

I'm not just storing lead data, also other types, so my need is generic across any API that returns a response payload. E.g. Email subject length, folder name length, email description length.

[SanfordWhiteman]

---

Thank you @SanfordWhiteman for the information, I wish they would use swagger to document the response model field limits.

---

Wouldn’t really help if they’re not accurate! Anything that’s abstracted/manually typed instead of lifted directly from the schema can have errors. (And, historically, has.)

---

I'm not just storing lead data, also other types, so my need is generic across any API that returns a response payload. E.g. Email subject length, folder name length, email description length.

---

Asset names are NVARCHAR(255).