Headers
|
Header name |
Description |
Required |
Values |
|---|---|---|---|
|
Authorization |
Access token |
Required |
Bearer <access_token> |
|
Content-Type |
Request type format |
Required |
application/json |
To retrieve all the Data:
GET
https://<appserver with domain>/<virtual_directory>/Srd/V2/Projects('TRAINPROJ')/Disciplines(5020)/Nls(1)/Interfaces(5000)/PackageTypes(5222)/ContentPackages('TJR')/Versions(58150)/DataTables(1112)/Data
Get URI Parameter
|
Parameter |
Description |
Type |
Required |
|---|---|---|---|
|
Data |
The data table for which retrieval request is sent. |
Integer |
Required |
Response
|
Parameter |
Description |
Type |
Notes |
|---|---|---|---|
|
RowId |
The unique ID of the row |
Integer |
|
|
RowAction |
The action taken on the row such as addition (A), modification (M), etc |
String |
The other attributes such as OptionCode, FirstSizeFrom, etc as shown in the sample
response are dynamically populated based on the sheet specified.
Sample Response
"@odata.context": "https://<appserver with domain>/<virtual_directory>/Srd/V2/$metadata#Projects('TRAINPROJ')/Disciplines(5020)/Nls(1)/Interfaces(5000)/PackageTypes(5222)/ContentPackages('TJR')/Versions(58150)/DataTables(1112)/Data/Com.Ingr.Srd.V2.PartData",
"value": [
{
"@odata.type": "#Com.Ingr.Srd.V2.PartData",
"RowId": 68003110,
"RowAction": "A",
"Npd[1]##Primary": "10",
"Npd[2]##Secondary": "10",
"NpdUnitType[1]": "in",
"NpdUnitType[2]": "in",
"EndPreparation[1]": "301",
"EndStandard[1]": "26",
"EndPreparation[2]": "301",
"EndStandard[2]": "26",
"MaterialGrade": "162",
"GraphicalRepresentationOrNot": "",
"PurchaseLength": "",
"MinimumPipeLength": "",
"MaximumPipeLength": "",
"ManufacturingMethod": "5",
"SurfacePreparation": "",
"LiningMaterial": "",
"PipingNote1": "",
"GeometricIndustryStandard": "100",
"DryWeightForEnd1": "",
"DryWeightForEnd2": "",
"PressureRating[1]": "",
"ScheduleThickness[2]": "S-STD",
"WeightPerUnitLength": "",
"PressureRating[2]": "",
"ScheduleThickness[1]": "S-STD",
"Density": "",
"IndustryCommodityCode": "PPPABQBEACRAAGZ",
"MaterialsMgmtIDENT": "",
"CommodityType": "PIPE"
},
In odata, if the property name contains any reserved character, the following error
is displayed:
{
"error": {
"code": "",
"message": "The property name 'Npd[1]:Primary' is invalid; property names must not contain any of the reserved characters ':', '.', '@'."
}
}
There is a restriction if the attribute contains any reserved character. The reserved character gets replaced in the following manner:
-
':' with ##
-
'@' with &&
-
'.' with **