Connecting to Geotab API from MS Fabric

홈커뮤니티SDK/APIGetting startedConnecting to Geotab API from MS Fabric

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.

Any help would be much appreciated.

Thanks,

Dave

대화에 참여하기

You need to be logged in to reply to this post and participate in the Geotab Community discussions.

최고 답변

nschainblatt-1755

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

Make an Authenticate call with request body:

{
    "method": "Authenticate",
    "params": {
        "database": "",
        "userName": "",
        "password": ""
    }
}

Obtain the session ID from the response if successful.
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개