To fetch the column names and datatypes for a specific DN Table in your database, use the getdnSchema API along with the specific Tablename (Example: datasource=mart_im_ticket_master). Executing the getdnSchema api will give you the column names, value, and datatypes of the table.
This output helps reporting tools understand the table structure.
To fetch the Column names and datatypes for a specific DN Table, perform the following steps:
Steps
Copy the Token generated without the comma or quotes.
Go to Postman or any other API tool.
Specify the URL as https://<novatech.com>/api_report/API/getdnSchema?datasource=mart_im_ticket_master
Click on Authorization tab and select Bearer and paste the Token.
Click Send.
Response
[
{
"text": "ticket_id",
"value": "ticket_id",
"datatype": "bigint"
},
{
"text": "ticket_no",
"value": "ticket_no",
"datatype": "bigint"
},
{
"text": "tenant_id",
"value": "tenant_id",
"datatype": "varchar"
},
]