3

I couldn't find any restriction on the maximum number of fields/columns while creating a DataExtension using the SOAP API. There seems to be some restriction on the name but none on the max number of columns/fields. Is there any such restriction?

Here's the documentation I have reviewed so far.

  • There are is no documented limitation, but how many fields were you intending to create exactly? 1 or 1 million? It's not best practice to create hundreds of fields, but if you think you need to, there are other options for storing structured data in fields (e.g. in a JSON object). Perhaps you can share your use case? – Eliot Harper Feb 17 '17 at 3:16
  • I am writing a wrapper for the inserting records into an existing dataExtension using soap api. wanted to know this for validation purposes. thanks – thor_hayek Feb 17 '17 at 4:01
6

From inspecting the wsdl (the API schema), the maxOccurs for Data Extension fields is unbounded which implies that there is no limitation.

1

I don't think there is any limit on the number of fields as it is a datatable, I have been working with data extension that has 250 fields via API.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.