Originally posted by: archana_SI_WTX

Hi Team,

I am trying to fetch data from SI ProcessData into WTX map using this function 

GET("Sterling", "-c getProcessData -k /ProcessData/DocumentName") . but not able get value in the WTX map. 

ERROR LOG : 

 DEBUG  [WTXMapExternalDataHarness] invoked getProcessData harness function with name=/ProcessData/DocumentName/text()
 DEBUG  [WTXMapExternalDataHarness] returning getProcessData harness function with value=

Please help me to resolve this issue.

Thank you every one!!!

Originally posted by: Ejay

Hello ,

You are tyring to use the GET of the Sterling adapter to read the value of a key called "/ProcessData/DocumentName"  from the process data.

GET("Sterling", "-t+ -c getProcessData -k withyourkeyvaluehere")

Could you change this to the key you are looking for ?

Also i would suggest to turn the adapter trace On with the -t+ command.

Hope that help .

EJ

Originally posted by: archana_SI_WTX

Hi EJ,

Thanks for the reply. I am still facing the same issue , actually we have WTX with SPE and I tried to use both commands  

GET("Sterling", "-t+ -c getProcessData -k /ProcessData/DocumentName")

GET("SPE", "-t+ -c getProcessData -k /ProcessData/DocumentName) , but still not able to fetch data from ProcessData. it will be great if you could suggest me for  this.

Thank you!!!

Originally posted by: paul.brett

What does the trace tell you?

Thank-you.

Paul.

Follow me on Twitter

Originally posted by: Ejay

Hi ,

/ProcessData/DocumentName  is not a correct Value for Key , the data from the process data could no be called with Xpath syntax in that way as we are looking for "/ProcessData/DocumentName" ,but  not it's value

Can you test with a valid  hard coded value for the key  ?

Or please try the following :

=PUT("Sterling", "-t+ -c setProcessData -k getmap -now", "data")

Then

=GET("Sterling", "-t+ -c getProcessData -k getmap")

Let me know how it work .

Thank you

EJ

Originally posted by: archana_SI_WTX

Hi EJ,

I tried the scenario which you stated ,

=PUT("Sterling", "-t+ -c setProcessData -k getmap -now", "data")
ProcessData is updated as below 
 <EDIEncoderMode>IMMEDIATE</EDIEncoderMode>
  <getmap>data</getmap>
  <MapName>Z1O_INVOIC02_ox810v4010_28</MapName>

=GET("Sterling", "-t+ -c getProcessData -k getmap") - this is fetching value as "data"  
=GET("Sterling", "-t+ -c getProcessData -k MapName") - this is again not fetching data . I am not sure what is wrong.

Please advise me to get MapName from the ProcessData.

Thank you Very much!!! 

your help is very much appreciated.

Originally posted by: RichMcFate

A couple of questions:

Since you're using the Sterling adapter, I assume you're running SPE in B2Bi or Sterling File Gateway.  Is that correct?
 

How is the MapName element getting set?  Are you sure your map is running after whatever it is in the BP that is setting the element?

WRT your earlier question about  -k /ProcessData/DocumentName:  Have you tried it without the root element? (i.e.  -k DocumentName).  If you're trying to get subelements from ProcessData, you should be able to do that as well. (e.g. -k DocumentName/DocumentType)

Good Luck,

Rich

Originally posted by: archana_SI_WTX

Hi Rich,

Thanks for your response.

Yes , we are using SPE and Sterling Integrator.

MapName element is mapped from the SPE-Deenveloping service, I am not updating from the map . this MapName  element is available in the processData but not able to fetch in WTX map.

I have tried it without root-element but no luck.

Please help to resolve this issue. 

Thanks for your help!!!

Regards,

Archana

Originally posted by: RichMcFate

Archana -- try using the "SPE" adapter rather than the "Sterling" adapter.  I believe the syntax for getProcessData is the same.

Rich

Originally posted by: Dasarath_SI

Hi Rich,

We are trying to pull one value from Process data which is not at the root level.

We tried below all Commands as below, but not getting any output:

GET("SPE", "-tv+ -c getProcessData -k /ProcessData/UserData/MapVariant")

GET("SPE", "-c getProcessData -k /ProcessData/UserData/MapVariant")

GET("SPE", "-c getProcessData -k /ProcessData/UserData/MapVariant/text()")

Could you please help us here?

Thanks

Wrick

Originally posted by: archana_SI_WTX

I don't have the server access to check the trace , let me know is there any other way to check . Thank you!!!!

Originally posted by: Ejay

Hello ,

Let me know if the following example help .

EJ

Attachment(s)

CodeList Example.zip   2 KB 1 version

Originally posted by: Ramache

Hi,

In your example - can you detail us how to pass a field value against which i want to do a codelist look up.

For Example :

accountCode value exists in the codelist table and when partner sends the accountCode , we have to look up in the code list table and override the accountCode with InternalCode

Assume that - in the codelist table - accountCode refers to ReceiverCode and InternalCode refers to Sender Code

And after the look up is complete the accountCode in the translated map should be replaced with the value of Internal Code.