Inserting multiple records into DV tables with Odata
Issue
- trying to insert multiple records into multiple tables with Odata POST
Environment
- Red Hat JBoss Data Virtualization (DV) 6.1
- Odata insert call to DV:
URL: http://localhost:8080/odata/SubVDB/sub?$format=json
Headers:
1. Authorization :
2.Content-Type : application/json
Payload:
{ "input": [ {"JRNL_SUBMISSION_ID": "JCAA_2019_3",
"JRNL_ARTICLE_ID": "15",
"JRNL_ID": "4",
"ARTICLE_ID": null,
"UCM_ID": "0",
"PII_ID": null,
"CREATED_BY": "testrsit",
"CREATION_DATE": "0000-10-10T00:00:00",
"UPDATED_BY": "testrsit",
"UPDATED_DATE": "0000-10-10T00:00:00",
"STICKYNOTE": null,
"AUTHOR_REV_ID": "1",
"PLAG_FOLDER_ID": null
}, {
"JRNL_SUBMISSION_ID": "JCAA_2019_3",
"JRNL_ARTICLE_ID": "15",
"JRNL_ID": "4",
"ARTICLE_ID": null,
"UCM_ID": "0",
"PII_ID": null,
"CREATED_BY": "testrsit",
"CREATION_DATE": "0000-10-10T00:00:00",
"UPDATED_BY": "testrsit",
"UPDATED_DATE": "0000-10-10T00:00:00",
"STICKYNOTE": null,
"AUTHOR_REV_ID": "1",
"PLAG_FOLDER_ID": null
}]
}
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.