Skip to main content

Good morning everyone,

 

I post this topic cause after many hours of research I can’t find a solution about using an API.

Here is my problem : 

 

I have to build an flow for make an insertion of data in IFS DB.

I did it on the application and use the debug window for see what kind of API is called.

 

After analyse, I see this : 

 

 

I understood the parameters are checked in the FndTempsLobs API which is genering a LobID and this LobID is the payload of the PickSelected API.

 

My question is :

 

  • How can I give the inforamtion PICK_LIST_NO, SOURCE_REF1, QTY_TO_PICK, etc… to the FndTempsLobs API ? 

The documentation show us the only payload is CreatedByModule :

 

 

My 2nd question is :

 

  • The LobID generated contains the previous information ? 

 

Thx a lot for your help and sorry if my explication are confused.

 

 

Hi @BenHug 

 

I don’t know what this API does. I checked the API documentation. You can get documentation like below. 

 

  • Go to projection. And add the “/$openapi?V3” end of the URL.

https://url:port/main/ifsapplications/projection/v1/ReportPickingOfPickListLines.svc/$openapi?V3

  • Copy content and paste to Swagger editor.

https://editor-next.swagger.io/

 

 

Then, I created a post request. I looked at your debug screenshot and I created a body like below.

https://url:port/main/ifsapplications/projection/v1/ReportPickingOfPickListLines.svc/FndTempLobs

 

 

Something has been created in the database. And I can see those with a get request.

 

 

 

In my opinion, this API is used for entering huge data for a record. That should be the second part of something. You can see the second question answer. LobId in the POST request response.

Hi,

 

Thank you for your answer.

 

I think I understood how the parameters are used.

After request this API, a line in the DB table FND_TEMP_LOB_STORE_TAB is created.

 

The parameter are recover in the CLOB_DATA column :

 

 

Then I will use the API PickSelected which will use this Lob ID and will use the Selection in the CLOB_DATA column.

 

My final problem is : “Where can I past this parameter in the API ? Parameters ? Body ? Header ? 

 

Log IFS : 

 

I can’t find :(

 

Thx for all :)

@BenHug In my opinion, there should be another projection. Just trace the network carefully. I hope you will solve it.

Hi @BenHug ,

first you have to create a new ‘FndTempLobs’ to get a LobId.
See API Explorer > ReportPickingOfPickListLines
In this case, the body would be {‘CreatedByModule’: ‘ReportPickingOfPickListLines’}.

Afterwards you have to fill the CLOB content:

I had some trouble finding the right parameters here. The temporary content can be viewed in the database table FND_TEMP_LOB_STORE_TAB:

I have executed ‘Report Picking’ for one row and looked at the changes in the database table for each click:

At the end, ‘PickSelected’ will be executed.

I hope this will help you.

Reply


Terms & ConditionsCookie settings