GET developer/tables/{tableName}
Gets table detail.
Request Information
URI
https://ofd-api.blueprintcpq.net/developer/tables/{tableName}
URI Parameters
| Name | Description | Type | Additional information |
|---|---|---|---|
| tableName |
Name of the table. |
string |
Required |
Body Parameters
None.
Response Information
Resource Description
The table detail.
DeveloperTable| Name | Description | Type | Additional information |
|---|---|---|---|
| Id | globally unique identifier |
None. |
|
| Name | string |
None. |
|
| Identifier | string |
None. |
|
| HumanReadableField | DeveloperField |
None. |
|
| IdField | DeveloperField |
None. |
|
| LockField | DeveloperField |
None. |
|
| CurrencyField | DeveloperField |
None. |
|
| Fields | Collection of DeveloperField |
None. |
|
| Relationships | Collection of DeveloperTableRelationship |
None. |
Response Formats
application/json, text/json
Sample:
{
"Id": "055d60a7-d7b7-4faa-9f0a-aff62fca5b51",
"Name": "sample string 2",
"Identifier": "sample string 3",
"HumanReadableField": {
"Id": "e543f99c-9af3-4969-8dbe-f1e791993f0e",
"Name": "sample string 2",
"Label": "sample string 3",
"MaxLength": 1,
"DataType": "sample string 4",
"Unique": true,
"Help": "sample string 6",
"Relationship": {
"Id": "3bea9548-4d01-46a7-86a1-ba8c22893c66",
"CanBeNull": true
}
},
"IdField": {
"Id": "e543f99c-9af3-4969-8dbe-f1e791993f0e",
"Name": "sample string 2",
"Label": "sample string 3",
"MaxLength": 1,
"DataType": "sample string 4",
"Unique": true,
"Help": "sample string 6",
"Relationship": {
"Id": "3bea9548-4d01-46a7-86a1-ba8c22893c66",
"CanBeNull": true
}
},
"LockField": {
"Id": "e543f99c-9af3-4969-8dbe-f1e791993f0e",
"Name": "sample string 2",
"Label": "sample string 3",
"MaxLength": 1,
"DataType": "sample string 4",
"Unique": true,
"Help": "sample string 6",
"Relationship": {
"Id": "3bea9548-4d01-46a7-86a1-ba8c22893c66",
"CanBeNull": true
}
},
"CurrencyField": {
"Id": "e543f99c-9af3-4969-8dbe-f1e791993f0e",
"Name": "sample string 2",
"Label": "sample string 3",
"MaxLength": 1,
"DataType": "sample string 4",
"Unique": true,
"Help": "sample string 6",
"Relationship": {
"Id": "3bea9548-4d01-46a7-86a1-ba8c22893c66",
"CanBeNull": true
}
},
"Fields": [
{
"Id": "e543f99c-9af3-4969-8dbe-f1e791993f0e",
"Name": "sample string 2",
"Label": "sample string 3",
"MaxLength": 1,
"DataType": "sample string 4",
"Unique": true,
"Help": "sample string 6",
"Relationship": {
"Id": "3bea9548-4d01-46a7-86a1-ba8c22893c66",
"CanBeNull": true
}
},
{
"Id": "e543f99c-9af3-4969-8dbe-f1e791993f0e",
"Name": "sample string 2",
"Label": "sample string 3",
"MaxLength": 1,
"DataType": "sample string 4",
"Unique": true,
"Help": "sample string 6",
"Relationship": {
"Id": "3bea9548-4d01-46a7-86a1-ba8c22893c66",
"CanBeNull": true
}
}
],
"Relationships": [
{
"RelationshipType": "sample string 1",
"RelatedTableName": "sample string 2",
"RelatedTableId": "9e6a80d1-77e3-4343-9bad-5866cd34e42b",
"RelatedTableIdentifier": "sample string 4",
"FromFieldName": "sample string 5",
"ToFieldName": "sample string 6",
"ToFieldDataType": "sample string 7",
"CanBeNull": true
},
{
"RelationshipType": "sample string 1",
"RelatedTableName": "sample string 2",
"RelatedTableId": "9e6a80d1-77e3-4343-9bad-5866cd34e42b",
"RelatedTableIdentifier": "sample string 4",
"FromFieldName": "sample string 5",
"ToFieldName": "sample string 6",
"ToFieldDataType": "sample string 7",
"CanBeNull": true
}
]
}
text/html
Sample:
{"Id":"055d60a7-d7b7-4faa-9f0a-aff62fca5b51","Name":"sample string 2","Identifier":"sample string 3","HumanReadableField":{"Id":"e543f99c-9af3-4969-8dbe-f1e791993f0e","Name":"sample string 2","Label":"sample string 3","MaxLength":1,"DataType":"sample string 4","Unique":true,"Help":"sample string 6","Relationship":{"Id":"3bea9548-4d01-46a7-86a1-ba8c22893c66","CanBeNull":true}},"IdField":{"Id":"e543f99c-9af3-4969-8dbe-f1e791993f0e","Name":"sample string 2","Label":"sample string 3","MaxLength":1,"DataType":"sample string 4","Unique":true,"Help":"sample string 6","Relationship":{"Id":"3bea9548-4d01-46a7-86a1-ba8c22893c66","CanBeNull":true}},"LockField":{"Id":"e543f99c-9af3-4969-8dbe-f1e791993f0e","Name":"sample string 2","Label":"sample string 3","MaxLength":1,"DataType":"sample string 4","Unique":true,"Help":"sample string 6","Relationship":{"Id":"3bea9548-4d01-46a7-86a1-ba8c22893c66","CanBeNull":true}},"CurrencyField":{"Id":"e543f99c-9af3-4969-8dbe-f1e791993f0e","Name":"sample string 2","Label":"sample string 3","MaxLength":1,"DataType":"sample string 4","Unique":true,"Help":"sample string 6","Relationship":{"Id":"3bea9548-4d01-46a7-86a1-ba8c22893c66","CanBeNull":true}},"Fields":[{"Id":"e543f99c-9af3-4969-8dbe-f1e791993f0e","Name":"sample string 2","Label":"sample string 3","MaxLength":1,"DataType":"sample string 4","Unique":true,"Help":"sample string 6","Relationship":{"Id":"3bea9548-4d01-46a7-86a1-ba8c22893c66","CanBeNull":true}},{"Id":"e543f99c-9af3-4969-8dbe-f1e791993f0e","Name":"sample string 2","Label":"sample string 3","MaxLength":1,"DataType":"sample string 4","Unique":true,"Help":"sample string 6","Relationship":{"Id":"3bea9548-4d01-46a7-86a1-ba8c22893c66","CanBeNull":true}}],"Relationships":[{"RelationshipType":"sample string 1","RelatedTableName":"sample string 2","RelatedTableId":"9e6a80d1-77e3-4343-9bad-5866cd34e42b","RelatedTableIdentifier":"sample string 4","FromFieldName":"sample string 5","ToFieldName":"sample string 6","ToFieldDataType":"sample string 7","CanBeNull":true},{"RelationshipType":"sample string 1","RelatedTableName":"sample string 2","RelatedTableId":"9e6a80d1-77e3-4343-9bad-5866cd34e42b","RelatedTableIdentifier":"sample string 4","FromFieldName":"sample string 5","ToFieldName":"sample string 6","ToFieldDataType":"sample string 7","CanBeNull":true}]}
application/xml
Sample:
Sample not available.
text/xml
Sample:
Sample not available.