Prev
Next
Forums Integration / Customization IPA/ProcessFlow

Lawson Query Node outputData

 2 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Kenn
Basic Member
Posts: 11
Basic Member
9/19/2014 2:44 PM
    I am using a Lawson query nore to pull a record from ACBUDDTL (or any other file).  When I look at the log, I see a record was found, but the outputData variable is empty.  Here is my log:

    Activity started: LwsnQuery7790 (Run Id: 2)

    S3 Query LwsnQuery7790: Executing S3 query: PROD=DEVEL2B&FILE=ACBUDDTL&KEY=IT-IT%26SPROJECTS=IT-PR011021=1=ITOL1=2013&FIELD=ACTIVITY-GRP;ACTIVITY;BUDGET-NBR;ACCT-CATEGORY;FISCAL-YEAR;PERIOD-AMT;PERIOD-UNIT&OUT=CSV&DELIM=,

    LwsnQuery7790_errorCode = 0

    LwsnQuery7790_informationCode = 0

    LwsnQuery7790_returnMessage = Query completed.

    LwsnQuery7790_outputData =

    LwsnQuery7790_currentPage = 1

    LwsnQuery7790_complete = true

    LwsnQuery7790_recordCount = 1

    LwsnQuery7790_hasNext = false

    Activity completed: LwsnQuery7790

    LwsnQuery7790_RECORD_COUNT = 1

    S3 Query LwsnQuery7790: Executing loop 1 of 1


    How can I access the data that I pulled?  I have tried putting it into a string and an array.

    Woozy
    Veteran Member
    Posts: 709
    Veteran Member
    9/19/2014 2:57 PM
      Have you tried doing the query through a browser to see what you really get?
      You should be able to paste "http(s)://hostname:port/servlet/Router/Data/erp?PROD=DEVEL2B&FILE=ACBUDDTL&KEY=IT-IT%26SPROJECTS=IT-PR011021=1=ITOL1=2013&FIELD=ACTIVITY-GRP;ACTIVITY;BUDGET-NBR;ACCT-CATEGORY;FISCAL-YEAR;PERIOD-AMT;PERIOD-UNIT&OUT=CSV&DELIM=," into a browser and see the resulting data.
      Kelly Meade
      J. R. Simplot Company
      Boise, ID
      Kenn
      Basic Member
      Posts: 11
      Basic Member
      9/19/2014 3:16 PM
        Exactly what I expected. But looking at all of my queries, none are showing any outputData.

        ACTIVITY-GRP,ACTIVITY,BUDGET-NBR,ACCT-CATEGORY,FISCAL-YEAR,PERIOD-AMT_1,PERIOD-AMT_2,PERIOD-AMT_3,PERIOD-AMT_4,PERIOD-AMT_5,PERIOD-AMT_6,PERIOD-AMT_7,PERIOD-AMT_8,PERIOD-AMT_9,PERIOD-AMT_10,PERIOD-AMT_11,PERIOD-AMT_12,PERIOD-AMT_13,PERIOD-UNIT_1,PERIOD-UNIT_2,PERIOD-UNIT_3,PERIOD-UNIT_4,PERIOD-UNIT_5,PERIOD-UNIT_6,PERIOD-UNIT_7,PERIOD-UNIT_8,PERIOD-UNIT_9,PERIOD-UNIT_10,PERIOD-UNIT_11,PERIOD-UNIT_12,PERIOD-UNIT_13 "IT-IT&SPROJECTS","IT-PR011021",1,"ITOL1",2013,1000.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,275.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,5.00,0.00