In Adeptia Connect, you can extract the names of the fields in a Layout using an API Endpoint. The extracted list of fields' names is in JSON format.
To achieve this, hit the API Endpoint URL in the format given below using a REST client.
<Connect_Server_URL>/Mapper/rest/schemas/json/<schemaType>/<schemaId>
Where,
- SchemaType: The type of Layout, for example, text, whose field names you want to extract.
- SchemaId: Id of the Layout, for example, 1094877832922.
- Access_Token: This header is required for the user authentication purpose.
The response of the API contains the field names of the requested Layout in the JSON format as shown in the sample response JSON below.
Sample_Schema_Fields_JSON_Format
{
"text": "root",
"entityName": "BooksDetails_CSV_Layout",
"children": [
{
"fieldName": "Root",
"XSDVersion": "1",
"fieldSeparator": ",",
"recordSeparator": "\\n",
"allowLessFields": "false",
"removeInvalidChar": "false",
"enclosedChar": "",
"MinOccurs": "1",
"MaxOccurs": "1",
"leaf": false,
"children": [
{
"fieldName": "Record",
"MinOccurs": "1",
"MaxOccurs": "unbounded",
"leaf": false,
"children": [
{
"fieldName": "Author",
"format": "AAAAAAA",
"parent": " ",
"Documentation": "",
"BaseType": "string",
"MinOccurs": "0",
"MaxOccurs": "1",
"leaf": true
},
{
"fieldName": "Title",
"format": "AAAAAAA",
"parent": " ",
"Documentation": "",
"BaseType": "string",
"MinOccurs": "0",
"MaxOccurs": "1",
"leaf": true
},
{
"fieldName": "Price",
"format": "AAAAAAA",
"parent": " ",
"Documentation": "",
"BaseType": "string",
"MinOccurs": "0",
"MaxOccurs": "1",
"leaf": true
},
{
"fieldName": "Genre",
"format": "AAAAAAA",
"parent": " ",
"Documentation": "",
"BaseType": "string",
"MinOccurs": "0",
"MaxOccurs": "1",
"leaf": true
},
{
"fieldName": "recordNumber",
"Documentation": "",
"isAttribute": "true",
"leaf": true,
"BaseType": "string"
}
]
}
]
}
]
}