To view all the data stored in a specific table, use the getdata API along with the specific Tablename (Example: datasource=mart_im_ticket_master). Executing the getdata api with the table name displays all the data stored in the table as a response. For example, you want to view all the ticket details stored in the database, then use the getdata?=datasource=mart_im_ticket_master in the API. The table name mentioned is for reference purpose. You can use other DN table names based on your requirement in getdata?=datasource=mart_cm_change_request_master.
To view all the values and data stored 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/getdata?datasource=mart_im_ticket_master
Click on Authorization tab and select Bearer and paste the Token.
Click Send.
Response
{
"results": [
{
"ticketID": "IM123",
"ticketNumber": "100234",
"tenantID": "T001",
"assignedTo": "jsmith@novatech.com",
...
}
],
"pagination": {
"page": 1,
"pageSize": 100
}
}