topic Re: Gateway ODATA datasource creation via API in Developer

Gateway ODATA datasource creation via API

JoergSch — Mon, 19 Apr 2021 12:44:54 GMT

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

Re: Gateway ODATA datasource creation via API

Anonymous — Wed, 21 Apr 2021 01:39:43 GMT

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

Re: Gateway ODATA datasource creation via API

JoergSch — Wed, 21 Apr 2021 04:53:16 GMT

Thanks Xiaoxin,

I found the reason in the meantime. The parameter

"useEndUserOAuth2Credentials": false,

was missing. The error message was a little bit misleading.

Joerg