Expand my Community achievements bar.

SOLVED

CSV import in AEP via API

Avatar

Level 4

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.....

 

 

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

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...

 

 

 

View solution in original post

1 Reply

Avatar

Correct answer by
Employee Advisor

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...