Finance | Project Operations, Human Resources, ...

How to consume oracle API in ax 2012 R3

(0) Share

Report

Posted on by Somesh Kumar Dubey

Hi All,

I want to consume oracle API in ax 2012 R3. Oracle team has provided me a URL so that I could consume that URL and access the JASON file available on it.

After accessing that JASON file I have to fill in the data from that JASON file to a staging table available in AX.

Please help with the process.I tried to google but not getting anything related to it.

Thanks

I have the same question (0)

All responses (23)

Answers (0)

Martin Dráb 235,876 Most Valuable Professional on at

Like (0)

Report

RE: How to consume oracle API in ax 2012 R3

As I said, I'm not familiar with the custom class you're using, but you can give it a try if you want.

Create an extra data contract for the root object with those two properties. The type of 'data' will be list; you also must add AifCollectionTypeAttribute where you'll say which kind of data is in the list (TRICustGroupList class in your case). For example, look at how ERSolutionInfo class implements parmVersions().

Was this reply helpful? Yes No
Somesh 55 on at

Like (0)

Report

RE: How to consume oracle API in ax 2012 R3

Hi Martin,

Thanks for your time and patience!!!

Could you please guide me how can I parse the rawResponse directly to multiple objects??

Thanks in advance..

Was this reply helpful? Yes No
Martin Dráb 235,876 Most Valuable Professional on at

Like (0)

Report

RE: How to consume oracle API in ax 2012 R3

No, unless it's hidden in TRICustGroupList class (which you didn't show us), you didn't write any code to do that. I've just explained that your code doesn't do anything.

If I was you, I wouldn't try to extract those two substrings from rawResponse at all. I would parse rawResponse directly to multiple objects - a root object with properties success and data, where data is a collection of objects holding data about customer groups.

Was this reply helpful? Yes No
Somesh 55 on at

Like (0)

Report

RE: How to consume oracle API in ax 2012 R3

Thank you for the response Martin..

Yes I need some logic to extract those two values from rawResponse so that I could store those values in table fields.

I wrote the above code to achieve the same thing but it's not returniing the expected result.

Could you please help how can I extarct those two values from rawresponse and store them in table.

Was this reply helpful? Yes No
Martin Dráb 235,876 Most Valuable Professional on at

Like (0)

Report
RE: How to consume oracle API in ax 2012 R3

Here I'm guessing what the method does - you still haven't shared this information with us.

Let's say it receives a List objects, stores it in a variable and returns it back.

Then this statement

custGroupList.parmDataDetail(list)

just returns what you already have in list.

Then you iterate list, and because you put a single value there, rawResponse, it's what you get back. Therefore this code:

rawResponse = response.parmData(); custGroupList = new TRICustGroupList(); list = new List(Types::String); list.addEnd(rawResponse); listIterator = new ListIterator(custGroupList.parmDataDetail(list)); while (listIterator.more()) { custGroupContract = SMCFormJsonSerializer::deserializeObject(classIdGet(custGroupContract), listIterator.value()); listIterator.next(); }

Does the same thing as this:

rawResponse = response.parmData(); custGroupContract = SMCFormJsonSerializer::deserializeObject(rawResponse);

Obviously that's not what you wanted.

You need some logic to actually extract those two values from rawResponse.

Was this reply helpful? Yes No
Somesh Kumar Dubey 20 on at

Like (0)

Report

RE: How to consume oracle API in ax 2012 R3

Hi Martin,

Thanks for the response..Could you please explain what do you mean when you said

"If it's just a parameter method without any parsing, you'll get back the same value that you put there (= rawResponse) and the whole operations doesn't have any effect."

Thanks

Was this reply helpful? Yes No
Martin Dráb 235,876 Most Valuable Professional on at

Like (0)

Report

RE: How to consume oracle API in ax 2012 R3

Yes, I know. Could you please read my previous reply once more and either follow it or tell me which part you don't understand?

Was this reply helpful? Yes No
Somesh 55 on at

Like (0)

Report

RE: How to consume oracle API in ax 2012 R3

Hi Martin, Thank you for the response.

In rhe code snippet below .

In rawResponse I am getting complete JSON string and I am trying to get the record one by one for each customerGroup through while loop but nits going in the loop only once however thre are multiple records in the JSON. Hence I want to retrieve both the records one by one.

rawResponse = response.parmData();

custGroupList = new TRICustGroupList();

list = new List(Types::String);

list.addEnd(rawResponse);

listIterator = new ListIterator(custGroupList.parmDataDetail(list));

while (listIterator.more())

{

custGroupContract = SMCFormJsonSerializer::deserializeObject(classIdGet(custGroupContract), listIterator.value());

info(strFmt('%1', custGroupContract.parmCustGroupId()));

info(custGroupContract.parmCustGroupName());

listIterator.next();

}

Thanks,

Somesh

Was this reply helpful? Yes No
Martin Dráb 235,876 Most Valuable Professional on at

Like (0)

Report

RE: How to consume oracle API in ax 2012 R3

Your code expects that custGroupList.parmDataDetail() returns a List object with two JSON strings, one for each customer group. Unfortunately you didn't say whether it works or not, nor did you show the code.

Look at the code and if the method isn't obviously wrong, use the debugger to check whether the method returns what you expect.

If it's just a parameter method without any parsing, you'll get back the same value that you put there (= rawResponse) and the whole operations doesn't have any effect.

By the please, use Insert > Insert Code (in the rich formatting view) to paste source code. It'll make it easier to read.

Was this reply helpful? Yes No
Somesh 55 on at

Like (0)

Report

RE: How to consume oracle API in ax 2012 R3

Sorry martin mistakenly i missed the no of line in the perivious code. I am attaching the code below.

RetailWebRequest request;

RetailWebResponse response;

str rawResponse;

RetailCommonWebAPI webApi;

Object deserializedContract;

List list;

ListIterator listIterator;

CreateCustGroupContract custGroupContract;

CustGroupList custGroupList;

webApi = RetailCommonWebAPI::construct();

request = RetailWebRequest::newUrl("URL");

response = webApi.getResponse(request);

rawResponse = response.parmData();

custGroupList = new TRICustGroupList();

list = new List(Types::String);

list.addEnd(rawResponse);

listIterator = new ListIterator(custGroupList.parmDataDetail(list));

while (listIterator.more())

{

custGroupContract = SMCFormJsonSerializer::deserializeObject(classIdGet(custGroupContract), listIterator.value());

info(strFmt('%1', custGroupContract.parmCustGroupId()));

info(custGroupContract.parmCustGroupName());

listIterator.next();

}

Json String returned in rawResponse like below

{

"success": true,

"data": [

{

"CUST_GROUP_ID": 1,

"CUST_GROUP_NAME": "Customer Group 1",

"INSERT_FLAG": "Y",

"RECORD_SENT_FLAG": "N",

"ERROR_MESSAGE": null,

"LAST_UPDATE_DATE": "2020-03-01T13:29:29.000Z",

"LAST_UPDATED_BY": 0,

"CREATION_DATE": "2020-03-01T13:29:29.000Z",

"CREATED_BY": 0

},

{

"CUST_GROUP_ID": 2,

"CUST_GROUP_NAME": "Customer Group 2",

"INSERT_FLAG": "Y",

"RECORD_SENT_FLAG": "N",

"ERROR_MESSAGE": null,

"LAST_UPDATE_DATE": "2020-03-01T13:29:29.000Z",

"LAST_UPDATED_BY": 0,

"CREATION_DATE": "2020-03-01T13:29:29.000Z",

"CREATED_BY": 0

}

]

}

Thanks,

Somesh

Was this reply helpful? Yes No