Skip to main content
Question

PickSelected API

  • September 26, 2023
  • 4 replies
  • 156 views

Forum|alt.badge.img
  • Do Gooder (Customer)
  • 1 reply

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.

 

 

4 replies

hhy38
Superhero (Customer)
Forum|alt.badge.img+16
  • Superhero (Customer)
  • 323 replies
  • September 28, 2023

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.


Forum|alt.badge.img
  • Author
  • Do Gooder (Customer)
  • 1 reply
  • September 28, 2023

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 :)


hhy38
Superhero (Customer)
Forum|alt.badge.img+16
  • Superhero (Customer)
  • 323 replies
  • September 29, 2023

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


Forum|alt.badge.img+3
  • Do Gooder (Customer)
  • 8 replies
  • September 30, 2024

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


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