Solved
Trim last lines in csv file
Team,
I have a log file in csv format. But the log file contains status information in first 5 lines and last 3 lines.
I can skip the first 5 lines using Skip lines* property in csv parser. But I...
Forum Discussion
Did you still need help with this?
I haven’t yet found a solution, so yes.
Also here are the formatted JSONS:
Received JSON:
{
"Property1":"value1",
"Property2":"value2",
"Property3":"value3",
"Subarray":[
{
"SubProperty1":"subValue1",
"SubProperty2":"SubValue2",
"SubProperty3":"SubValue3"
},
{
"SubProperty1":"subValue4",
"SubProperty2":"SubValue5",
"SubProperty3":"SubValue6"
}
]
}
Should be Produced JSON:
{
"Prop1":"value1",
"Prop2":"value2",
"MyArray":[
{
"SubProp1":"subValue1",
"SubProp2":"SubValue2",
},
{
"SubProp1":"subValue4",
"SubProp2":"SubValue5",
}
]
}
I have found that I can manipulate the subArrays by using a JSON splitter and working on each one individually, I have not however found out how to use the join snap to properly put them back into the required space once this is done.
Hi @doug.fossler,
It looks like the credentials that you are using in the Email Account(in SnapLogic) is not longer valid.
Regards,
SpiroNope credentials are fine, it will send the email without an attachment. I can also navigate to the location where the attachment is with the credentials.
Interesting twist, if I include “route error data to error view” then the pipeline will complete. It sends a complete email including the attachment, but still throws an error saying that:
"Failed to copy attachment ‘/path/test.csv’ to a temp file
Resolution:
Please address reported issue.Reason:
Mount failed due to logon failure or bad credentials:"Hi have you found any solution about this ? We have a similar problem.
No, actually it got worse and now it will “attach” the file, but it will be a zero byte file that cannot be opened. We had to change to another users email to start sending attachments again.
