ContributionsMost RecentMost LikesSolutionsJSON Formatting and Merging Hello All, I have encountered a scenario where we need to map all the element with key, “tree”, to a single array of the same name. I have provided an example below Input: [{ “tree”: { “name”: “DB1” “type”: “database” “children”: [{ “name”: “SCHA” “type”: “schema” “children”: [{ “name”: “TABLEA” “type”: “table” “leaves”: [{ “name”: “COA”, “type”: “column” }, { “name”: “COB”, “type”: “column” }, { “name”: “COC”, “type”: “column” }] }] }] }, { “tree”: { “name”: “DB2” “type”: “database” “children”: [{ “name”: “SCHB” “type”: “schema” “children”: [{ “name”: “TABLEB” “type”: “table” “leaves”: [{ “name”: “CO1”, “type”: “column” }, { “name”: “CO2”, “type”: “column” }, { “name”: “CO3”, “type”: “column” }] }] }] } } }] Intended output: { “tree”: [{ “name”: “DB1” “type”: “database” “children”: [{ “name”: “SCHA” “type”: “schema” “children”: [{ “name”: “TABLE1” “type”: “table” “leaves”: [{ “name”: “CO1”, “type”: “column” }, { “name”: “CO2”, “type”: “column” }, { “name”: “CO3”, “type”: “column” }] }] }] }, { "name": "DB2" "type": "database" "children": [{ "name": "SCHB" "type": "schema" "children": [{ "name": "TABLE1" "type": "table" "leaves": [{ "name": "CO1", "type": "column" }, { "name": "CO2", "type": "column" }, { "name": "CO3", "type": "column" }] }] }] }] } Essentially, instead of having individual objects with the name tree we are trying to create a single tree array with all the data inside. Any suggestions on this would be really helpful. Thank you. Re: Query on Monitoring API Can you please post the solution as we have a similar use case. Thanks. Re: Temp folder relocation @cstewart any feedback on this? Re: Temp folder relocation Thanks @cstewart Also, the new temp folder would be on the “D:\Snalogic_TEMP” We opened a ticket with our support agent, and they specified something about symlinks. Can’t I just use that path in the global properties? e.g. jcc.jvm_options = -Djava.io.tmpdir=D:\Snalogic_TEMP Temp folder relocation Hi community folks, So we recently added a partition to our groundplex server. Is it possible to relocate the TEMP folder that Snaplogic uses to that partition so that it is off the OS drive? Re: Getting Error streaming data while writing to a temporary file, reason=No space left on device @erkonline you got any response/resolution to this? I’m getting the same when doing a Snowflake Bulk Upsert. Re: String to Date Thanks Igor, that worked. String to Date Good day, I have a “date” field which comes in as “Jan-2018”. I’d like to change to an actual date field, e.g. “2018-01-01” Is this possible? SolvedRe: REST GET to SharePoint Hi, I too am experiencing something similar. Did you get a resolution? Re: Populate Aggregate snap with Pipeline Parameter Thanks, that worked for me.