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]

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.