Skip to main content
Question

Workflow - Call action having CLOB parameter

  • December 8, 2024
  • 2 replies
  • 165 views

Forum|alt.badge.img+7

Hi,

Using workflow I was trying to automate the “Receive” functionality present on “My Self-Service Request History” screen. This same functionality is also present on “Register Arrival” screen.

 

I checked in the code of the assistant that pops up when this button is clicked. The assistant populates data in the virtual(s) using an action “InsertSelection” which accepts 2 parameters, first one is of CLOB type.

 

So, I tried to replicate this step into my workflow using the below 3 blocks -

First block “Create Temp Lob” is creating a new record in FndTempLobs -

 

Second block “Update Clob Data” is Updating the Lob record created in previous step by passing the ClobData -

${Selection} contains the keyref string. This step is not working I believe.

 

Last block “Call InsertSelection” calls the action by passing in the LobId that was generated in the first block.

 

After the 2nd block, I get the error from the 3rd block -

 

The three blocks are created in the same way the network calls are invoked upon clicking the “Receive” command button -

For Block 1
For Block 2
For Block 3

 

I felt that the 2nd block “Update Clob Data” is not working even though correct ETag is loaded in the execution variable.

So what I did, I ran the assistant by clicking the “Receive” button and checked in the network console to find the Lob Id that is getting generated. Then I hardcoded this LobId in my 3rd block to “InsertSelection” call -

But still I got another error from this block -

After seeing this new error, I believe my 2nd block is not working. But even if I hardcode the Lob Id that actually contains the keyref in “ClobData” column, that is also not working.

 

Has anyone got into this situation of calling a CLOB parameter action and found a way to get through?

 

Any help or idea is greatly appreciated!

 

Thanks in advance.

Rohit

wahelk
Hero (Former Employee)
Forum|alt.badge.img+11
  • Hero (Former Employee)
  • December 8, 2024

this is techdocs.. not sure its a limitation
 

  • Blob, Clob, GIS, and File datatypes are supported only in cases where projections that manipulate them behind the scenes are called.


Forum|alt.badge.img+7
  • Sidekick (Customer)
  • January 22, 2025

Hello,

I have the same problem. When calling the function InsertPartInStockRecordsForProject

the ClobData should be set to in this case (I believe) with the ObjId of the selected Line on Page Inventory Parts In Stock:

 ObjId : "AAAUfPAAMAACRLLAAR" is shown in the inspector

but this does not happen:

​​​​​

Clob Data is empty and therefore the answer of this Function → LineGuid is null

An Update (second block) of FndTempLobs does not work.

In the debug the Patch Call of FndTempLobs is

https://cfg-ewms.gftd-united.eu/main/ifsapplications/projection/v1/InventoryPartInStockHandling.svc/FndTempLobs(LobId='2C46F29F0B203F78E0630A042E0AE5CD')/ClobData

But how does this work in BPAs?

 

Thanks for any help!

Herbert

 


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