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": "af995441-f70e-4047-a5d9-a2f2144ccf37",
"Name": "sample string 2",
"Identifier": "sample string 3",
"HumanReadableField": {
"Id": "7d754dca-bfff-4468-b4c2-df76d4b68e34",
"Name": "sample string 2",
"Label": "sample string 3",
"MaxLength": 1,
"DataType": "sample string 4",
"Unique": true,
"Help": "sample string 6",
"Relationship": {
"Id": "ec40769a-210b-4908-b054-a1b5d9f01e09",
"CanBeNull": true
}
},
"IdField": {
"Id": "7d754dca-bfff-4468-b4c2-df76d4b68e34",
"Name": "sample string 2",
"Label": "sample string 3",
"MaxLength": 1,
"DataType": "sample string 4",
"Unique": true,
"Help": "sample string 6",
"Relationship": {
"Id": "ec40769a-210b-4908-b054-a1b5d9f01e09",
"CanBeNull": true
}
},
"LockField": {
"Id": "7d754dca-bfff-4468-b4c2-df76d4b68e34",
"Name": "sample string 2",
"Label": "sample string 3",
"MaxLength": 1,
"DataType": "sample string 4",
"Unique": true,
"Help": "sample string 6",
"Relationship": {
"Id": "ec40769a-210b-4908-b054-a1b5d9f01e09",
"CanBeNull": true
}
},
"CurrencyField": {
"Id": "7d754dca-bfff-4468-b4c2-df76d4b68e34",
"Name": "sample string 2",
"Label": "sample string 3",
"MaxLength": 1,
"DataType": "sample string 4",
"Unique": true,
"Help": "sample string 6",
"Relationship": {
"Id": "ec40769a-210b-4908-b054-a1b5d9f01e09",
"CanBeNull": true
}
},
"Fields": [
{
"Id": "7d754dca-bfff-4468-b4c2-df76d4b68e34",
"Name": "sample string 2",
"Label": "sample string 3",
"MaxLength": 1,
"DataType": "sample string 4",
"Unique": true,
"Help": "sample string 6",
"Relationship": {
"Id": "ec40769a-210b-4908-b054-a1b5d9f01e09",
"CanBeNull": true
}
},
{
"Id": "7d754dca-bfff-4468-b4c2-df76d4b68e34",
"Name": "sample string 2",
"Label": "sample string 3",
"MaxLength": 1,
"DataType": "sample string 4",
"Unique": true,
"Help": "sample string 6",
"Relationship": {
"Id": "ec40769a-210b-4908-b054-a1b5d9f01e09",
"CanBeNull": true
}
}
],
"Relationships": [
{
"RelationshipType": "sample string 1",
"RelatedTableName": "sample string 2",
"RelatedTableId": "1ea2e03b-0fda-4cf8-b5b1-ae907870c3ed",
"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": "1ea2e03b-0fda-4cf8-b5b1-ae907870c3ed",
"RelatedTableIdentifier": "sample string 4",
"FromFieldName": "sample string 5",
"ToFieldName": "sample string 6",
"ToFieldDataType": "sample string 7",
"CanBeNull": true
}
]
}
text/html
Sample:
{"Id":"af995441-f70e-4047-a5d9-a2f2144ccf37","Name":"sample string 2","Identifier":"sample string 3","HumanReadableField":{"Id":"7d754dca-bfff-4468-b4c2-df76d4b68e34","Name":"sample string 2","Label":"sample string 3","MaxLength":1,"DataType":"sample string 4","Unique":true,"Help":"sample string 6","Relationship":{"Id":"ec40769a-210b-4908-b054-a1b5d9f01e09","CanBeNull":true}},"IdField":{"Id":"7d754dca-bfff-4468-b4c2-df76d4b68e34","Name":"sample string 2","Label":"sample string 3","MaxLength":1,"DataType":"sample string 4","Unique":true,"Help":"sample string 6","Relationship":{"Id":"ec40769a-210b-4908-b054-a1b5d9f01e09","CanBeNull":true}},"LockField":{"Id":"7d754dca-bfff-4468-b4c2-df76d4b68e34","Name":"sample string 2","Label":"sample string 3","MaxLength":1,"DataType":"sample string 4","Unique":true,"Help":"sample string 6","Relationship":{"Id":"ec40769a-210b-4908-b054-a1b5d9f01e09","CanBeNull":true}},"CurrencyField":{"Id":"7d754dca-bfff-4468-b4c2-df76d4b68e34","Name":"sample string 2","Label":"sample string 3","MaxLength":1,"DataType":"sample string 4","Unique":true,"Help":"sample string 6","Relationship":{"Id":"ec40769a-210b-4908-b054-a1b5d9f01e09","CanBeNull":true}},"Fields":[{"Id":"7d754dca-bfff-4468-b4c2-df76d4b68e34","Name":"sample string 2","Label":"sample string 3","MaxLength":1,"DataType":"sample string 4","Unique":true,"Help":"sample string 6","Relationship":{"Id":"ec40769a-210b-4908-b054-a1b5d9f01e09","CanBeNull":true}},{"Id":"7d754dca-bfff-4468-b4c2-df76d4b68e34","Name":"sample string 2","Label":"sample string 3","MaxLength":1,"DataType":"sample string 4","Unique":true,"Help":"sample string 6","Relationship":{"Id":"ec40769a-210b-4908-b054-a1b5d9f01e09","CanBeNull":true}}],"Relationships":[{"RelationshipType":"sample string 1","RelatedTableName":"sample string 2","RelatedTableId":"1ea2e03b-0fda-4cf8-b5b1-ae907870c3ed","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":"1ea2e03b-0fda-4cf8-b5b1-ae907870c3ed","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.