How to injest data to Dataset for onetime using JSON Drag and Drop

[RajaShankar]

Hi All,

I am new to Adobe Experience Platform. I created a schema using XDM Profile and also created a data set for this schema. Now i want to injest data into this dataset by dragging and dropping file in json format.  I am not sure what is the JSON file structure that i need to create to get data ingested. I am aware I can use workflows my mapping csv to dataset. But i want to use json in dataset screen and drag and drop for a onetime use.

I searched many of the forum tickets same question asked in many place but i dont see any proper response to it.

Please suggest.

[Rite18]

@RajaShankar I am not sure why you want to use JSON when CSV is working, point is that imported file should mapped to schema,, are you able to map a valid JSON to schema ?

consider to review below 

Solved: import CSV datafile to Existing AEP Dataset - Adobe Experience League Community - 451338

[RajaShankar]

This is to automate later with API from AEP from client application to injest data at real time to AEP dataset. I found the solution.Basically the one sample schema download that comes with the AEP Schema just includes the mandatory basic fields it doesnt includes all the field groups and other fields into the sample xml. Other way is to use schema registry api to fetch the complete schema in json format and the same can be used in json format to injest data to dataset. I am trying this approach will update my post with details once solution is working. I dont want csv batch way.

[dwright · Accepted solution]

If you are looking for sample data that aligns with your schema for testing purposes, there are some good sample data generators out there you can use like mockaroo. It's pretty straightforward to output json data once you get the hang of it. Then you can drag and drop it in.

[arpan-garg]

Hi @RajaShankar 

I understand your point—sometimes inserting a JSON directly can be handy for one-time use, especially for testing or POC purposes. Here's what you need to do:

1. Go to your schema, select it, and click Download Sample File on the right.
2. Populate the sample file with your data.
3. Once your JSON is ready, ensure it is wrapped in square brackets [] like this:

[your json]

Because it expects an array of json , not just one json.This step is essential; otherwise, you’ll encounter a format exception.If you have further questions, feel free to reach out.

Thanks,

Arpan