Congratulations on solving your issue @SandyClouds and thank you for posting the solution in case it can assist others. ... View more

When you write a website with some links to other pages and maybe a form or two, you've already done real REST. The client (i.e. a web browser) presents the current resource to a user, automatically discovers related resources and allows the user to create/edit their own resources. Why people don't apply the same principles to the APIs they write is baffling. ... View more

Congratulations on solving your issue @SandyClouds and thanks for taking the time to share it with the community.  ... View more

@SandyClouds, I do not have a template because I no longer have access to that project but I have provided you will all the info you need to develop your own system 🙂   And it mostly depends on your use case. You can use any API you require for your use case. But in terms of processors your require the following: InvokeHTTP to perform the API Call, EvaluateJSONPath + SplitJSON to extract the relevant lines out of your bulletin boards and RouteOnAttribute to identify the errors you need. Other than that, your imagination is your best friend. ... View more

What is your run schedule time for the processor ?  if its too low (say 1 sec or 30 sec), gtry increasing it to reasonable timeline like a minute based on your refresh requirements. @Gagan1707  ... View more

@SAMSAL Kudos to you.. it worked.. /\ ... View more

@mburgess @SamCloud  convert jsontosql is giving SQL but with '?' marks. example: "DELETE FROM tab1 WHERE id = ? AND feature_name = ? AND state = ? AND tenant_id = ?" When i print via putfile, the json has valid values..  [{"id":1,"feature_name":"fet1","state":16,"tenant_id":"abc123"}] Want to understand where I am doing it wrong.. Please help ... View more

Yes this is best approach, Inserting all in staging table and then using merge to insert/update on target table, Just need to truncate staging table for next round of inserts.  ... View more

@mburgess  Can you please help here..  ... View more

Update:   So i copied the details of nifi.security.keystore nifi.security.truststore nifi.security.truststorePasswd nifi.security.truststoreType    from nifi.properties file of my nifi installation and pasted them in the properties file of toolkit nifi-toolkit-1.16.3/conf/cli.properties     Now when i try to run the cli commands i get a new error.. seems I am close but not yet done... below is the error: "ERROR: Error executing command 'list-param-contexts' : Error retrieving parameter contexts: Client certificate for (CN=localhost) is expired."   How can I renew this expired certificate ?  I wonder why CLI is not so straight forward!!!   Please help me in this regards..   ... View more