Solved
Inject data form Json file
Hello Experts,
Can one help me on how to inject data form json format file to AEP.
Kindly provide process steps or supporting documents.
Thanks
Hi @saurabh_g ,
Here are a few links that might help use AEP APIs.
Before you test the data ingestion, you should use the postman collection as mentioned in point 2 (there will be a explicit node for Data Ingestion with all required API endpoints. I have also added a screenshot for your reference) and also create the developer console API project as per point 3 and extract the credentials (API key, client secret, and JWT token which are required to call API).
Once you have configured the collection and JWT token, you can follow the following steps,
- Step 1. You should first create a Dataset using the AEP web interface and this will require a Schema name.
- Step 2. Now you create a Batch using API.
Url: https://platform.adobe.io/data/foundation/import/batches
This requires Dataset id from above step 1.
Body: {
"datasetId" : "datasetid",
"inputFormat": {
"format": "json"
}} - Step 3. Once batch is created, you can upload small files below 256 MB using API. .
This requires dataset id and batch id from steps 1 & 2.
Filepath will be an adobe path.
Url: https://platform.adobe.io/data/foundation/import/batches/:batchId/datasets/:datasetId/files/:filePath
Attach: JSON file of data in binary format. - Step 4. After all, files are uploaded. Call the Finish uploading File using API.
This requires Batch id from step 2 and action param values as complete.
https://platform.adobe.io/data/foundation/import/batches/:batchId?action=COMPLETE - Step 5: After ingestion, you can go to Dataset definition using the AEP web interface and can search for the Batch ID created in Step 2 and can see the number of records ingested and also status of batch ingestion.
Hope this helps.
With Regards,
Amit