CSV import in AEP via API

Avatar

Avatar
Validate 1
Level 1
AtulChavan
Level 1

Like

1 like

Total Posts

15 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Give Back
View profile

Avatar
Validate 1
Level 1
AtulChavan
Level 1

Like

1 like

Total Posts

15 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Give Back
View profile
AtulChavan
Level 1

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 (1)

Accepted Solutions (1)

Avatar

Avatar
Give Back 5
Employee
dwright
Employee

Likes

21 likes

Total Posts

80 posts

Correct reply

20 solutions
Top badges earned
Give Back 5
Seeker
Validate 1
Shape 1
Ignite 5
View profile

Avatar
Give Back 5
Employee
dwright
Employee

Likes

21 likes

Total Posts

80 posts

Correct reply

20 solutions
Top badges earned
Give Back 5
Seeker
Validate 1
Shape 1
Ignite 5
View profile
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...

 

 

 

Answers (0)