Forum Discussion

MallikarjunNuli's avatar
MallikarjunNuli
New Contributor
8 years ago

How to read Multiple Sheets from an excel dynamically using Snaplogic

Hi , I have requirement to read a single sheet at a time and load the data in to a table from the same excel file which contains more than 40+ of sheets. Is it possible to do this through Snaplogic...
jdbc
mbowen's avatar
mbowen
Employee
4 years ago
Copy LinkReport

Hi @Sanssnap

I don’t think this is possible at the moment. However, we do have a CopyBook snap which is able to read from a Mainframe and output JSON. We reached out to the snap maintainers and it would be possible to go the other direction. This work would need to be spec’d and implemented. If you do want to pursue this, speaking with your SnapLogic CSM to discuss an enhancement request is probably a good next step.

  • krupalibshah's avatar
    krupalibshah
    Contributor
    9 years ago
    Copy Link

    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