How to update druid_query column in dataset_metadata table via Data Exhaust Meta APIs

[Vivek-M-08]

We have a requirement to add additional columns for “Status Report - Project” CSV. These two columns are already present in druid sl-projects data-source. In order to get these columns from the druid we have to modify druid_query config in dataset_metadata table when dataset_sub_id = 'ml-project-status-exhaust'

As OnDemandDruidExhaustJob in core-dataproducts repo is a generic data-product this will query dataset_metadata table to get and construct druid query and build the desired CSV based on the druid columns. Hence we need access for the following API's to modify this config https://github.com/Sunbird-Obsrv/sunbird-analytics-service/blob/fc5578fdc3174669a2a2347ff2b95d11f0c61718/analytics-api/conf/routes#L36C1-L39C1

@sowmya-dixit @manjudr Please help us with the complete postman collection and authorization token for the above mentioned API's

Cc: @vijiurs @aks30 @rakeshSgr

[manjudr]

@Vivek-M-08 - The hyperlink here seems to be inaccessible. Therefore, I am providing the PDF documentation for the Sunbird Data Exhaust APIs here: Sunbird Data Exhaust APIs.pdf. Kindly review the documentation and utilize the necessary API. Additionally, please get the authorization token for the specific environment from the DevOps person.

[Vivek-M-08]

I am trying to run v1 version of the obsrv API, and tried in both Dev and Staging environment.

'dev.sunbirded.org/api/dataset/v1/add' 
'staging.sunbirded.org/api/dataset/v1/add'

[sowmya-dixit]

@Vivek-M-08
Can you share complete logs of analytics service via mail which help us look into the issue in detail.

[sowmya-dixit]

@Vivek-M-08 Looks like GET call is being invoked for dataset/add as the error says
Internal server error, for (GET) [/dataset/add]
Please change it to POST and let us know if you still face any issues.

[Vivek-M-08]

Thank you @sowmya-dixit
The problem was fixed. The reason for the issue was that I was using the GET HTTP method by default when I was hitting the API in Postman, and I had not enabled the Follow original HTTP method option in settings.