Skip to main content
Question

Geotab - SDK intergration - ExceptionEvent - Broken rules

pwiles

Hi all,

I'm using FME to connect to this SDK with a httpcaller transformer. However, if I want to retrieve the ExceptionEvent (where rules are broken), i need to include additional information in my GET.

This is my current get: https://my42.geotab.com/apiv1/Get?ExceptionEventSearch={"database":"xxx","userName":"pwiles@stars.ca","password":"xxx"}

I get a error when trying to use this GET. The error that is returned is the following:

_response_body (encoded: UTF-8): {"error":{"message":"The method \\\\u0022Get\\\\u0022 could not be found. Verify the method name and ensure all method parameters are included.","code":-32601,"data":{"id":"11773710-4ab7-4507-b527-4ad8508f3ea5","type":"MissingMethodException","requestIndex":0},"name":"JSONRPCError","errors":[{"message":"The method \\\\u0022Get\\\\u0022 could not be found. Verify the method name and ensure all method parameters are included.","name":"MissingMethodException"}]},"jsonrpc":"2.0","requestIndex":0}

If I had rules in place for these exceptions and wanted to retrieve the three rule names in the last 5 minutes, how would I write this statement above?

These are the rule names:

TEST ECC: CORP Possible Accident

ECC: CORP Airbag Deployed detected

ECC: CORP Possible Accident ECC

Attached is my workspace that includes the broken Httpcaller.

Geotab's API reference documentation is located in the following location:

https://my.geotab.com/sdk/#/api

Thanks for your time,

Paul

3 replies

G
Forum|alt.badge.img

Hi @pwiles,

I took a quick look at the API doc you shared and would recommend to check out this part:

https://my.geotab.com/sdk/#/concepts

I am not familiar with the API at all, but I would try these 2 options as they might be a potential solution:

1. Properly URI encode your query string. In FME this can be done with the TextEncoder

2. Send your request with the POST method in the HTTPCaller and include the GET method you want to use for the API as a key/value pair in the payload of the request as shown in the documentation.

I hope this helps!

pwiles
  • pwiles
  • Author
  • July 26, 2018
gerhardatsafe wrote:

Hi @pwiles,

I took a quick look at the API doc you shared and would recommend to check out this part:

https://my.geotab.com/sdk/#/concepts

I am not familiar with the API at all, but I would try these 2 options as they might be a potential solution:

1. Properly URI encode your query string. In FME this can be done with the TextEncoder

2. Send your request with the POST method in the HTTPCaller and include the GET method you want to use for the API as a key/value pair in the payload of the request as shown in the documentation.

I hope this helps!

Well, I was able to pull the exceptionevent's by using the following:

 

https://my.geotab.com/apiv1/Get?typeName=ExceptionEvent&credentials;={"database":"xxx","userName":"pwiles@stars.ca","password":"xxxx"}Then I broke FME inspector. Everytime I try to open inspector it crashes (when viewing this data). I get the following error:

 

Problem signature:

 

Problem Event Name: APPCRASH

 

Application Name: fmeworker.exe

 

Application Version: 2018.7.34.18310

 

Application Timestamp: 5b03ca3e

 

Fault Module Name: fme.dll

 

Fault Module Version: 2018.7.34.18310

 

Fault Module Timestamp: 5b03ca30

 

Exception Code: c0000005

 

Exception Offset: 00000000013a23e7

 

OS Version: 6.1.7601.2.1.0.272.7

 

Locale ID: 1033

 

Additional Information 1: 9ea6

 

Additional Information 2: 9ea65f6f178d7eeff7dbf6b25273728e

 

Additional Information 3: 38d4

 

Additional Information 4: 38d471de971d3e5107fb2f5ddfe4a015

 

 

Read our privacy statement online:

 

http://go.microsoft.com/fwlink/?linkid=104288&clcid;=0x0409

 

 

If the online privacy statement is not available, please read our privacy statement offline:

 

C:\\Windows\\system32\\en-US\\erofflps.txt

 

 

 

screen-shot.png

 

 

nampreetatsafe
Safer
Forum|alt.badge.img+13
pwiles wrote:
Well, I was able to pull the exceptionevent's by using the following:

 

https://my.geotab.com/apiv1/Get?typeName=ExceptionEvent&credentials;={"database":"xxx","userName":"pwiles@stars.ca","password":"xxxx"}Then I broke FME inspector. Everytime I try to open inspector it crashes (when viewing this data). I get the following error:

 

Problem signature:

 

Problem Event Name: APPCRASH

 

Application Name: fmeworker.exe

 

Application Version: 2018.7.34.18310

 

Application Timestamp: 5b03ca3e

 

Fault Module Name: fme.dll

 

Fault Module Version: 2018.7.34.18310

 

Fault Module Timestamp: 5b03ca30

 

Exception Code: c0000005

 

Exception Offset: 00000000013a23e7

 

OS Version: 6.1.7601.2.1.0.272.7

 

Locale ID: 1033

 

Additional Information 1: 9ea6

 

Additional Information 2: 9ea65f6f178d7eeff7dbf6b25273728e

 

Additional Information 3: 38d4

 

Additional Information 4: 38d471de971d3e5107fb2f5ddfe4a015

 

 

Read our privacy statement online:

 

http://go.microsoft.com/fwlink/?linkid=104288&clcid;=0x0409

 

 

If the online privacy statement is not available, please read our privacy statement offline:

 

C:\\Windows\\system32\\en-US\\erofflps.txt

 

 

 

screen-shot.png

 

 

Hi @pwiles: Would you mind opening a case with our support team (https://www.safe.com/support/report-a-problem)? Please provide the details you've given above, a reference to this post, your workspace and, if possible, use a Recorder (https://www.safe.com/transformers/recorder) to attempt to capture what is being sent to the Data Inspector in a ffs file.

 

Reply


Helpful Members This Week

Community Stats

31,300
Posts
118,695
Replies
38,878
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.