Support Questions

Find answers, ask questions, and share your expertise

Dynamic value fetching from database in Apache NiFi

avatar
Explorer

Hello,

I'm using InvokeHTTP for fetching recods from my CouchDB. I have recieved a JSON. 

Fayza_0-1702288013637.png

JSON Format:
{

"total_rows" : 3,
"offset" : 0,
"rows" : [ {

"id" : "XXXXXXXXXX",
"key" : "XXXXXXXXXX",
"value" : {
"rev" : "XXXXXXXXXX"
},
"doc" : {
"_id" : "XXXXXXXXXX",
"_rev" : "XXXXXXXXXX",
"Id" : "3",
"name" : "ali",
"gender" : "Male",
"position" : "soft",
"salary" : "3333",
"contact" : "2222",
"address" : "w222"
}
} ]
}

 

After that i will use EvaluateJSONPath

Fayza_1-1702288205306.png

Now, I want to make fetch all the values from the database dynamically and then POST to my GraphQL.

The Problem that I'm faceing values dynamically is not being fetched.

Although I can POST the data by using Only One Record like as following:

Fayza_2-1702288365591.pngFayza_3-1702288447005.pngFayza_4-1702288467938.png

 

By using Single records I can POST the data but how can I manage the Multiple JSON records dynmaically ready for  GraphQL mutation query?

Advance Thanks.

0 REPLIES 0