CSV import in AEP via API

Avatar

Avatar

AtulChavan

Avatar

AtulChavan

AtulChavan

28-01-2021

When I try to import csv into AEP with batch ingestion API receive below error : 

 

A required field <sandboxname> of type: object is missing from the input data. Add the required field and try again.

The field: <sandboxname>.<csv field name>does not exist in the target schema. Remove the field and try again.

 

Ingestion goes well if I do it with UI.

thoughts please.....

 

 

Accepted Solutions (0)

Answers (1)

Answers (1)

Avatar

Avatar

dwright

Employee

Avatar

dwright

Employee

dwright
Employee

04-02-2021

Are you missing the x-sandbox-name header in the API request?

 

x-sandbox-name is a required header in the batch ingestion API. It refers to the Experience Platform sandbox environment in which you are working. By default, there is a prod sandbox, but then you can create multiple development sandboxes for testing.

 

When you log into the UI you are always defaulted into a sandbox, and if you have access to multiple sandboxes, you can switch between them using the dropdown in the top left corner. This is probably why you don't get this error in the UI... because you always have to be in a sandbox.

dwright_0-1612471729563.png

When using the API, you need to use the sandbox name field, which you can see from the UI (if you have sandbox permissions):

dwright_1-1612471849991.png

You could also retrieve a list of your available sandboxes from one of the requests in this Postman collection:

https://github.com/adobe/experience-platform-postman-samples/blob/master/apis/experience-platform/Sa...