Member since
10-07-2022
5
Posts
0
Kudos Received
0
Solutions
01-24-2023
07:48 AM
I'm looking for breaking following nested JSON file and transform it into a SQL prepared format. Input JSON file: {
"Product1": {
"Purchase": 31
},
"Product2": {
"Purchase": 6213,
"Cancel": 1988,
"Change": 3702,
"Renewal": 5934
}
} Desired output: [
{
"product": "Product1",
"Purchase": 31
},
{
"product": "Product2",
"Purchase": 6213,
"Cancel": 1988,
"Change": 3702,
"Renewal": 5934
}
]
... View more
Labels:
- Labels:
-
Apache NiFi
01-17-2023
02:25 AM
I'm looking for breaking nested JSON file and try to flat it to fit into a SQL database. Current Json: {
"content": {
"failedPerProductLineAndReason": {
"Product1": {
"Downsizing licenses is not allowed": 1
}
}
}
} Expected outcome: {
"ErrorType" : "failedPerProductLineAndReason" ,
"product" : "Product1" ,
"error" : "Downsizing licenses is not allowed" ,
"quantity" : 1
}
... View more
Labels:
- Labels:
-
Apache NiFi
12-20-2022
02:12 AM
Hi Matt, My flow is basically reading big file and loading it into a SQL DB. I'm simply looking to wait until insert statement is fully completed and after that move to some other task. My current flow ( doesn't work as expected right now): Convert SQL processor: Execute SQL processor: Wait processor: My question is how to properly configure wait processor to fill success queue only once full insert statement is done? Full flow:
... View more
12-19-2022
09:45 AM
I wanted to wait until 'ExecuteSQL' processor finishes inserting big file into SQL database (table: bu_service_template), then move to other section. 'ExecuteSQL' processor inserts row by row content of a file. I wanted to wait until file is fully inserted and then move to a next file. My current flow: wait flow
... View more
Labels:
- Labels:
-
Apache NiFi
10-10-2022
09:20 AM
How can I break and flatten nested JSON with arrays using Jolt transformations
from:
{
"product": [
"data - 1",
"data - 2"
],
"Purchase": [
2,
2
],
"Renewal": 1
}
to
[
{
"product": "data -1",
"Purchase": 1,
"Renewal": 1
},
{
"product": "data -2",
"Purchase": 2,
}
]
My current jolt transformation doesn't give me fully accurate transformation
[
{
"operation": "shift",
"spec": {
"*": {
"*": {
"@": "[#2].&2"
}
}
}
}
]
... View more
Labels:
- Labels:
-
Apache NiFi