Chad Thomas
Member
Hi. I am working to create an orchestration that can be used to extract records from F00165, including the blob data in GDTXFT. We have an external CPQ tool that we have integrated with Salesforce and perform a nightly export of configuration master data from JDE and pass to the CPQ tool. We are currently using MagicXPI for this nightly task, but are in the process of replacing MagicXPI with Workato and relying heavily on orchestrations for Workato to interact with JDE. We are running 9.2 on an AS400.
I'm using a database connector and Groovy script to execute an SQL statement to SELECT records from F00165. Below is the SQL statement.
SELECT
GDOBNM,
GDTXKY,
GDMOSEQN,
GDGTMOTYPE,
GDLNGP,
GDUSER,
GDUPMJ,
GDTDAY,
GDGTITNM,
GDQUNAM,
GDGTFILENM,
GDGTFUTS1,
GDGTFUTS2,
GDGTFUTS3,
GDGTFUTS4,
GDGTFUTM1,
GDGTFUTM2,
GDTXFT
FROM ${sDta}.F00165
JOIN ${sDta}.F554101 ON LEFT(GDTXKY,(LOCATE('|',GDTXKY)-1)) = IMITM
WHERE
(
GDOBNM='GT3291'
OR
GDOBNM = 'GT3292'
)
AND
LOCATE('|',GDTXKY) > 0
When I run the orchestration the output for GDTXFT does not contain the actual data. Note, I'm looking to return the raw binary data, not the converted readable text. Anyone know how to accomplish this, or if it's possible?
I'm using a database connector and Groovy script to execute an SQL statement to SELECT records from F00165. Below is the SQL statement.
SELECT
GDOBNM,
GDTXKY,
GDMOSEQN,
GDGTMOTYPE,
GDLNGP,
GDUSER,
GDUPMJ,
GDTDAY,
GDGTITNM,
GDQUNAM,
GDGTFILENM,
GDGTFUTS1,
GDGTFUTS2,
GDGTFUTS3,
GDGTFUTS4,
GDGTFUTM1,
GDGTFUTM2,
GDTXFT
FROM ${sDta}.F00165
JOIN ${sDta}.F554101 ON LEFT(GDTXKY,(LOCATE('|',GDTXKY)-1)) = IMITM
WHERE
(
GDOBNM='GT3291'
OR
GDOBNM = 'GT3292'
)
AND
LOCATE('|',GDTXKY) > 0
When I run the orchestration the output for GDTXFT does not contain the actual data. Note, I'm looking to return the raw binary data, not the converted readable text. Anyone know how to accomplish this, or if it's possible?