Forum Discussion
Anonymous
6 years agoNot applicable
Web Api Update data source error - "'updateDatasourcesRequest' is a required parameter",
Hi
I am trying to update datasource using webapi getting below error.
{
"updateDetails": [
{
"datasourceSelector": {
"datasourceType": "Sql",
"connectionDetails": {
"server": "old",
"database": "old"
}
},
"connectionDetails": {
"server": "new",
"database": "new"
}
}
}
]
}
is it somethng wrong with my JSON?
2 Replies
- v-lid-msftCommunity Support
Hi Anonymous ,
Could you please check if the query of dataset has reached the following limitation mentioned in this document?
- Datasources that contain parameters on the connection string are not supported.
- Datasources which are part of Merged or Joined tables are not supported.
Also there is an additional "}" in the end of your json file.
{ "updateDetails": [ { "datasourceSelector": { "datasourceType": "Sql", "connectionDetails": { "server": "My-Sql-Server", "database": "My-Sql-Database" } }, "connectionDetails": { "server": "New-Sql-Server", "database": "New-Sql-Database" } } ] }
Best regards, - v-lid-msftCommunity Support
Hi Anonymous ,
Does this issue have been resolved?Could you please provide more details about it If it still not be resolved? Please don't contain any Confidential Information or Real data in your reply.
Best regards,