JsonParserOperation failed: The transformer returned null as output

[Sravani36]

Hi i have created custom JDBC Action to connect oracle db I'm using jsonParser to parse the Output from JDBC Step but i was getting below error. May I know how to fix this below error.

Thanks

[Rahul Priyadars]

Can you post the JSON Payload data?

Please check this also

• Hyphens, periods, spaces, double colons, and the @ symbol in JSON keys are not supported.
• Your example payload can't exceed 2 MB.

Regards

Rp

[Sravani36]

Hi Rahul, this is the output, if it won't work we may need to write a script to parse this? the only thing i need is the user name should be in first from below data.

"Records" : [ {
    "account_status" : "EXPIRED & LOCKED",
    "all_shard" : "NO",
    "authentication_type" : "",
    "common" : "YES",
    "created" : "",
    "default_collation" : "",
    "default_tablespace" : "",
    "editions_enabled" : "N",
    "expiry_date" : " ",
    "external_name" : null,
    "implicit" : "NO",
    "inherited" : "YES",
    "initial_rsrc_consumer_group" : "DEFAULT_CONSUMER_GROUP",
    "last_login" : null,
    "local_temp_tablespace" : "TEMP",
    "lock_date" : "  ",
    "oracle_maintained" : "Y",
    "password" : null,
    "password_versions" : null,
    "profile" : "DEFAULT",
    "proxy_only_connect" : "N",
    "temporary_tablespace" : "TEMP",
    "user_id" : 63.0,
    "username" : "ANONYMOUS"
  }, {
    "account_status" : "EXPIRED & LOCKED",

[Rahul Priyadars]

From JDBC Step can you use SQl Query to fetch the user name?

Regards

RP

[Sravani36]

Hi Rahul we are using sql query in JDBC step, from that we are getting the output as above, trying to parse it by dragging and dropping the user id to the top. but getting this error. 

Regards

Sravani C