Trying to get my first API call to Work but running into 404 Not Found Error

Jeff Johnson

Hi,

Trying to get my first API call up and running and I have my Post Get Job, Get Job Status and Get Job Result within Postman following the tutorial located here.

https://developer.infor.com/tutorials/data-management/external-access-to-data-lake-apis/

When I hit Post, I get the dreaded 404 Not Found error.

The body of my Post (Get Job) is as follows.  Is this the correct syntax?  Just trying to get all items from the item business class.

SELECT
    "ITEM"."ITEM"
FROM
    "ITEM"

https://mingle-ionapi.eu1.inforcloudsuite.com/XXXXX/DATAFABRIC/compass/v2/jobs/

XXXXX = my Tenant.

If I go into Compass SQL query platform (version 2) in Infor ION API and test (execute) for Post I get status of running and a query id which I use for the Get Job status test and that returns this error:

Any help or guidance would be appreciated.

Thanks.

Jeff<span class="hljs-attr">"status": "FAILED",
  <span class="hljs-attr">"location": "result",
  <span class="hljs-attr">"queryId": "jHrtdKm9kz0ThpwjXNcf",
  <span class="hljs-attr">"columns": [
    {
      <span class="hljs-attr">"name": "messageCode",
      <span class="hljs-attr">"datatype": "Integer"
    },
    {
      <span class="hljs-attr">"name": "messageCategory",
      <span class="hljs-attr">"datatype": "String"
    },
    {
      <span class="hljs-attr">"name": "messageType",
      <span class="hljs-attr">"datatype": "String"
    },
    {
      <span class="hljs-attr">"name": "message",
      <span class="hljs-attr">"datatype": "String"
    },
    {
      <span class="hljs-attr">"name": "localizedMessage",
      <span class="hljs-attr">"datatype": "String"
    },
    {
      <span class="hljs-attr">"name": "suggestedLocalizedText",
      <span class="hljs-attr">"datatype": "String"

Kevin Heiman

Hi Jeff. 

I suspect you are not mapping the ion API file to your setup.  I see you are referencing Europe in your URL, is that correct?

it is recommend that you use the API fiel for all connections to enable movement form environment to environment and not have hard coded setups. There are example you can download, and here is a snip from Python.  the base URL is in "pu".

---------------------------------

# set up required params for Authentication

client_id = ionapi["ci"]

tenantid = ionapi["ti"]

client_secret = ionapi["cs"]

username = ionapi["saak"]

password = ionapi["sask"]

ionapiTokenURL = ionapi["pu"] + ionapi["ot"]

if debugmode:

    print("Token URL: " + ionapiTokenURL)

#

# get the oauth2 security token

oauth = OAuth2Session(client=LegacyApplicationClient(client_id=client_id))

token = oauth.fetch_token(token_url=ionapiTokenURL,

                          username=username,

                          password=password,

                          client_id=client_id,

                          client_secret=client_secret

                          )

tokenExpire = token['expires_at']