How to fetch value from array?
Hello Team,
I have the below array and I need to fetch the filename where active=1. Please can you help me on this.
“array” : [
{
“active”: 0,
“fileName”: “test.pdf”
},
{
“active”: 1,...
Forum Discussion
Have you tried the JSON Splitter snap? Based on your input file, you are probably wanting to split $transcript.lines[*].
Yes, along with Transcript, i would need to split all levels inside the file.
For each level of split, i’m forced to use multiple JSON Splitter. Attaching the full version of file along with pipeline that i created. Could you please help me out with the steps to read this JSON file and write output to Excel format.
Test-Full_2018_09_08.slp (25.9 KB)
Arno_Sample1.txt (1.9 MB)
add Excel formatter Snap
Thanks, but that creates a binary output how do you send it back to the HTTP requester?
I might be missing something in translation, but add a formatter and then a parser.
Trying to take the output of a pipeline initiated as an Ultra Task then converts the stream into an Excel document then send it back to the Requester. So think if you have a pipeline that queries the a DB then sends the results back as either a JSON or Excel document as a Restful service. The Excel formatter can only connect to a binary input. Not looking to write to file but output as a stream of binary data with a mime type of “application/vnd.ms-excel.xlt” or something else
Posted this a while ago and got a few suggestions but nothing that really worked. Trying to create a RestFul Endpoint that can return data as Json, CSV or Excel based on a format input param. I am going to attach a sample project I created but it doesn’t do wha we need. It takes an input stream in this case a statice excel file parses it to a json document and then tries to return
it as am Excel type to requestor. Any insight out there?Examples_ExcelFormaterAPI.zip (9.2 KB)
