topic Re: Restful API help - complete novice! in Connectivity & Data Prep

Restful API help - complete novice!

Blunck-TotalFitouts — Tue, 28 Dec 2021 20:37:01 GMT

Hi everyone 🙂

I am need of some assistance setting up a restful API to our companies job management software, SimPro.

Here is there doco page - https://developer.simprogroup.com/apidoc/?page=57be307ee1bd93b729fdc4c13f15e201

I have attempted, for days now, literally, trying to make a restful API connection to SimPro using the wizard in QlikSense. But I have failed, too many times to count!

Can someone help me out?

Thanks in advance!

Carl

Re: Restful API help - complete novice!

Mehrnaz — Fri, 31 Jan 2020 18:46:20 GMT

Hi Carl,

I am not familiar with SimPro. I am pretty new too, but I have created a couple API connections in my app successfully. Some simple ones with key and some that required Bearer tokens.

Looking at your API documentations, I see that you need the followings to be added:

Authorization you have to check the documentations to see what goes here

Content-Type application/json

In one of my POST connections, I have added them under "Query headers" section.

The documentation page seems to have a lot of useful content. It is worth to go through examples in there.

Just a couple things that comes to my mind:

Are you prefixing the following before the endpoint url (<client> should be replaced with the name of whatever server they assigned to your company):

https://<client>.simprosuite.com/api/

Pay attention to the type of call (POST vs GET) If it's a post, you might need to add a body.

When you say "it doesn't work", what exactly doesn't work? I would suggest you try to hit the endpoint using "Postman". If successful, then the endpoint with your key works fine and you just have to fiddle with your script/wizard.

If the API runs fine and the load doesn't work, then the connector works and the script needs a bit of work.

Hope this helps.

Good Luck!

Mehrnaz

Re: Restful API help - complete novice!

Blunck-TotalFitouts — Mon, 03 Feb 2020 12:21:09 GMT

Hi Mehrnaz,

Thanks for the tips so far! So I can get the connection to work fine through postman (Get) but when trying to make the connection through QlikSense, by using the create new connection wizard, I get the error message:

"HTTP protocol error 401 (Unauthorized): Request resource requires authentication."

I've gone with a basic authentication schema and placed my username and password in the boxes. Then in the Additional request parameters section, I've got:

Name = access_token

Value = token given to me by SimPro

Do you know what I am doing wrong?

Thanks

Carl

Re: Restful API help - complete novice!

Blunck-TotalFitouts — Mon, 03 Feb 2020 12:54:00 GMT

Hi again,

So I solved this problem, was putting the wrong URL in (lol). Connection seems to work, but then when I go to load data from the table, this is the script I get... NO IDEA what this means (lol again). Any info is greatly appreciated!

The below returns nothing except for a faultString of "Unable able to parse GET request" which I assume means my connection is still not correct...

LIB CONNECT TO 'REST_httpstotalfitouts.simprosuite.comapi';

RestConnectorMasterTable:

SQL SELECT

"result",

"id",

"__KEY_root",

(SELECT

"faultCode",

"faultString",

"__FK_error"

FROM "error" FK "__FK_error")

FROM JSON (wrap on) "root" PK "__KEY_root";

[error]:

LOAD [faultCode],

[faultString],

[__FK_error] AS [__KEY_root]

RESIDENT RestConnectorMasterTable

WHERE NOT IsNull([__FK_error]);

[root]:

LOAD [result],

[id],

[__KEY_root]

RESIDENT RestConnectorMasterTable

WHERE NOT IsNull([__KEY_root]);

DROP TABLE RestConnectorMasterTable;

Re: Restful API help - complete novice!

Mehrnaz — Mon, 03 Feb 2020 15:04:16 GMT

I haven't tried a "GET" yet, but these are what comes to my mind:

Did you add the following as your header also in addition to Authorization:

Name: Content-Type

Value: application/json

And if this doesn't solve it and if you are using "GET", are you passing in parameters into the URL? I remember that in a different environment, I had to convert spaces in my URL into the Hex value 20%, but I am not sure if the same would apply here.

Re: Restful API help - complete novice!

prabhu0505 — Mon, 03 Feb 2020 15:59:39 GMT

check this article...

https://support.qlik.com/articles/000076799

Re: Restful API help - complete novice!

Blunck-TotalFitouts — Thu, 06 Feb 2020 23:50:45 GMT

Thanks mate - added that in but still same issue unfortunately.

Re: Restful API help - complete novice!

Blunck-TotalFitouts — Thu, 06 Feb 2020 23:52:16 GMT

Thanks mate - that sort of helps, but response type is JSON not XML and SimPro doesn't appear to accept CSV...