Forum Discussion
Gateway ODATA datasource creation via API
Hello,
I am currently trying to create an OData datasource via the Gateway - Create Data source API (Gateways - Create Datasource (Power BI Power BI REST APIs) | Microsoft Docs).
When I put in the JSON and execute, I am getting below error.
{
"error": {
"code": "BadRequest",
"message": "Bad Request",
"details": [
{
"message": "Unexpected character encountered while parsing value: {. Path 'connectionDetails', line 11, position 27.",
"target": "datasourceToGatewayRequest.connectionDetails"
},
{
"message": "'datasourceToGatewayRequest' is a required parameter",
"target": "datasourceToGatewayRequest"
}
]
}
}
The Input JSON looks as following:
{
"datasourceName": "My_ODATA",
"credentialDetails": {
"encryptedConnection": "Encrypted",
"credentialType": "Basic",
"credentials": "mSTkW...dEwQ==",
"privacyLevel": "Private",
"encryptionAlgorithm": "RSA-OAEP"
},
"dataSourceType": "OData",
"connectionDetails": {\"url\":\"https://myURL.com\"}
}
Whats wrong with that?
How can I create an OData data source via the API?
Thanks
Joerg
Thanks Xiaoxin,
I found the reason in the meantime. The parameter
"useEndUserOAuth2Credentials": false,
was missing. The error message was a little bit misleading.
Joerg
2 Replies
- AnonymousNot applicable
Hi JoergSch,
If you not so sure these connection strings configured correctly.
You can try to directly config them on your gateway data source settings, then you can use the 'get Datasource' API to get the corresponding 'data source connections' as a referencce.400 Bad Request - HTTP | MDN (mozilla.org)
Gateways - Create Datasource (Power BI Power BI REST APIs) | Microsoft Docs
Regards,
Xiaoxin Sheng
- JoergSchFrequent Visitor
Thanks Xiaoxin,
I found the reason in the meantime. The parameter
"useEndUserOAuth2Credentials": false,
was missing. The error message was a little bit misleading.
Joerg