Hi @mjain
Here’s a pipeline in which the elements in the nested array are transformed into JSON documents that can be consumed by a CSV Formatter Snap.
Array_to_CSV_2020_07_03.slp (7.2 KB)
Hope it helps.
BR,
Dimitri
Hi @Szymon,
- is it not possible to have a binary output in ultra? YES or NO
Yes, the ultra pipeline should have at least one open output view and one input view. If you use an error pipeline with the ultra pipeline, the error pipeline must have an open output view.
- what is the alternative to output custom error codes from error pipeline, so the calling party sees, not HTTP 200, but HTTP 500? I DO NOT WANT to use Error View at the particular snaps in Ultra pipeline!
To output a custom status code, you can pass the $status header to the output snap ( for example JSON Formatter in the Binary header properties ) with your desired value. You can also do the same in a Mapper snap with binary output view if you want custom status code.
Please take a look at the CSV Parser documentation. There is a secondary input view that you can use to replace the column header names so that it will parse correctly.
Thank you! I get the headers but it skips all the blank columns.
my headers are
name, id, blank, blank, school, blank, blank.
and I have the blanks in the data and schema, but once it comes out of parser, it gives me
name, id, school
and the blank is not there anymore.
@cbot412 - So the root of the confusion here is that JSON does not allow two elements in the same object level to have the same name. Since you want to do exactly that, then you will need to generate a custom header record and prepend that to your content. Take a look at this post for ideas on how you could do it.
Please provide a sample of your input file and desired output. We need to understand your requirements to assist any further.
Thanks so much!
I am attaching the file that I am uploading for headers, and the output we get, and the expected file. I have also attached two screenshots of the pipeline I have.
The data in there is dummy so it might not be consistent
ExpectedFile.xlsx (17.0 KB)
Header.xlsx (16.9 KB)
OutputIamGetting.xlsx (16.9 KB)
