Connecting to Geotab API from MS Fabric

HomeCommunitySDK/APIGetting startedConnecting to Geotab API from MS Fabric

Connecting to Geotab API from MS Fabric

DCook-2058

Original Poster

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

Join the conversation

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

Top Answers

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

Best Answer

1 Reply