Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

CSV import in AEP via API

AtulChavan
Level 2
Level 2

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
dwright
Correct answer by
Employee
Employee

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
dwright
Correct answer by
Employee
Employee

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