Forum Discussion

manjunathsinghs's avatar
manjunathsinghs
New Contributor II
2 years ago
Solved

How can i get the input data sent to JSON parser snap.

Hi, I have JSON parser snap in my pipeline and it is getting data from external resources. Sometimes the data parse is failing due to invalid input. But am not able to capture that input data and er...
  • Aleksandar_A's avatar
    Aleksandar_A
    2 years ago

    Hello manjunathsinghs,

    I'd suggest using the Binary Copy Snap as your starting point. Then create two copy branches: one for storing the payload through the File Writer Snap, and the other for your downstream logic.

    Try this and let me know if this helps you.

    Regards,

    Aleksandar.

Christophe's avatar
Christophe
New Contributor II
5 years ago
Copy LinkReport

Hello,
Here is what I try :

1/ With the “Create table if not present” option
Here is what I get :
Unable to create table: “yyy”.“xxx”
Resolution:
Please make sure the connection, table name, and schema are correct
Reason:
SQL [CREATE TABLE …
“CREATED_DTTM” TIMESTAMP DEFAULT SYSTIMESTAMP NOT NULL,
)
]; The name “SYSTIMESTAMP” is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.
So, the “Create table if not present” option does not work properly.
2/ Without the “Create table if not present” option
It works.

But as my select is not simple as “select * from Table”, I can not use “Oracle - Select” but “Oracle - Execute”.
I had “Oracle - Execute” => “Mapper” => “Generic JDBC - Insert” and I get the error “The conversion from UNKNOWN to UNKNOWN is unsupported.”
I change to “Oracle - Execute” => “Mapper” => “SQL Server - Insert” and it is … OK. :+1: