How to find incoming data format(json,xml) dynamically in pipeline input view?

Question

How to find incoming data format dynamically?
Say for example,

If the incoming data is JSON then I need to perform certain validation and flow for JSON
If the incoming data is xml then I to perform certain operations.

Can any one suggest How to find incoming data format during the run-time. by using single input view for the pipeline?

surendar · Answer

Yes we have done the same and found the solution for the above approach.

In binary router we are validating the JSON or XML input streams and then doing our further works.
Thanks for your attention.

slaytanic70 · Answer

Can the incoming request also send a parameter of “file_type”?  Then you could use a router based on this value to handle it as JSON or XML or any other file_type that is sent.

rodhamann · Answer

We did the same, when we tested with a FIle Reader snap and specified a file from SLDB, we found that the field we need to check is ‘x-amz-meta-mimetype’. When we remove the File Reader snap, create a task and use postman… the input does not have this field. We tried using content-type and this fails too… Could you please provide what the conditions in the router were?

tstack · Answer

rodhamann:

When we remove the File Reader snap, create a task and use postman… the input does not have this field. We tried using content-type and this fails too… Could you please provide what the conditions in the router were?

Do you mean a Triggered Task?  The Content-Type header for a POST (and a few others) come in as pipeline parameters.  To get the Content-Type, you’d use:
_CONTENT_TYPE

mina · Answer

Hi for me it didn’t work due to on postman, Headers Content-Type was set to the default
application/x-www-form-urlencoded. After I changed it to
text/csv or application/json depending on the file I chose,
and on the Binary Router snap, I did
$[“content-type”]==“text/csv”
$[“content-type”]==“application/json”
the Post then worked as expected.

Forum Discussion

How to find incoming data format(json,xml) dynamically in pipeline input view?

Recent Discussions

Pagination and nextCursor in header

How to get filename from file reader

Generate expression file from database query

Can we generate XML file in pretty print format using native snapLogic snaps?

401 error with HTTP Client and NTLM