본문으로 바로가기

Connecting to Geotab API from MS Fabric

DCook-2058
원글 작성자

Has anyone connected to the Geotab API from MS Fabric? I'm data analyst, not a developer, and am having trouble with the configuration. I can successfully test the connection, but cannot preview the data, so I assuming I missing something in the header or body. I understand that the connection needs to retrieve a session ID to pass back to the API, but I'm not sure what I need to do to facilitate that.

image 

Any help would be much appreciated.

Thanks,

Dave

대화에 참여하기

이 게시물에 답글을 달고 Geotab 커뮤니티 토론에 참여하려면 로그인해야 합니다.

최고 답변

Hey @DCook-2058​,

 

You are correct in that you require authentication to utilize most API methods.

Your URL, format, and HTTP Method are correct, you are just missing the correct body for your requests (authentication -> subsequent data requests).

 

I am not familiar with MS Fabric, but you should be able to place the following valid JSON into the request body

  1. Make an Authenticate call with request body:
{ "method": "Authenticate", "params": { "database": "", "userName": "", "password": "" } }

 

 

  1. Obtain the session ID from the response if successful.
  2. Make the subsequent API calls you need to make with the session ID in the credentials parameter in the request body like so:
{ "method": "Get", "params": { "typeName": "Device", "credentials": { "database": "", "userName": "", "sessionId": "" } } }

 

 

For reference view the Make your first API call section:

https://developers.geotab.com/myGeotab/guides/concepts

답글 1개

Hey @DCook-2058​,

 

You are correct in that you require authentication to utilize most API methods.

Your URL, format, and HTTP Method are correct, you are just missing the correct body for your requests (authentication -> subsequent data requests).

 

I am not familiar with MS Fabric, but you should be able to place the following valid JSON into the request body

  1. Make an Authenticate call with request body:
{ "method": "Authenticate", "params": { "database": "", "userName": "", "password": "" } }

 

 

  1. Obtain the session ID from the response if successful.
  2. Make the subsequent API calls you need to make with the session ID in the credentials parameter in the request body like so:
{ "method": "Get", "params": { "typeName": "Device", "credentials": { "database": "", "userName": "", "sessionId": "" } } }

 

 

For reference view the Make your first API call section:

https://developers.geotab.com/myGeotab/guides/concepts

여전히 궁금한 점이 있으신가요?