Hi @manohar,
It’s a similar case like article To fix the pipeline to convert to array
Everything was fine, except that element(E1EDPT2) was array in one document and object in another hence the expression was failing. I made a minor adjustment.
I am attaching the pipeline here.
helpwithhandlingarray_2023_06_17.slp (7.9 KB)
I hope this help.
Did you try the schema.tablename in the query?
Yeah, but still got the same error.
It got solved, not sure how.
But now when I am trying to use the same insert query in different ways I get this error,
Content of Json generator:
[
{
"ACTIONNAME": "Audit",
"TRANSACTIONID": "536b983a-bb79-4a0f-afa7-6c3b4a8890b9",
"ENTRYTIMESTAMP": "2017-08-10T08:37:22.882",
"EXITTIMESTAMP": "2017-08-10T08:37:22.882",
"SOURCESYSTEMNAME": "_sSName",
"TARGETSYSTEMNAME": "_tSName",
"PIPELINEPROJECT": "PipelineProject",
"PARENTPIPELINENAME": "_parentPipelineName",
"CHILDPIPELINENAME": "_childPipelineName",
"ASSOCIATEDPIPELINE": "_associatedPipeLines",
"USERNAME": "_userId",
"SNAPLEXNAME": "SnaplexName",
"PARENTPIPELINEINSTANCEID": "_parentPipelineInstanceID",
"CHILDPIPELINEINSTANCEID": "_childPipelineInstanceId",
"BATCHID": "_batchID",
"BUSINESSID": "_businessID",
"STATUS": "_status"
}
]
Output of Mapper1 where we are getting error
Output of Mapper2 where it runs fine
How to read Multiple Sheets from an excel dynamically using Snaplogic | SnapLogic - Integration Nation - 16619
