Thanks Andre, I did manage to get the token using access/token api. however when I provided the token in postman as Bearer authentication I still get the 403 Forbidden response. Here is my request and response info as captured by Fiddler, let me know if you see anything wrong: PUT https://[server name]:9443/nifi-api/processors/385fcdc0-0180-1000-0000-000030a768e3/run-status HTTP/1.1 Content-Type: application/json Accept: application/json, text/javascript, */*; q=0.01 Keep-Alive: timeout=100, max=50000 Authorization: Bearer [access token] User-Agent: PostmanRuntime/7.29.0 Postman-Token: 5900c41a-f704-43f3-a2e4-a425eeb22569 Host: [host name]:9443 Accept-Encoding: gzip, deflate, br Connection: keep-alive Content-Length: 215 { "revision": { "clientId": "8F3BD748-DBCC-4703-8743-1D98A24B95C2", "version": 1.16, "lastModifier": "user.name" }, "state": "RUNNING", "disconnectedNodeAcknowledged": true }   Response:   HTTP/1.1 403 Forbidden X-Frame-Options: SAMEORIGIN Content-Security-Policy: frame-ancestors 'self' X-XSS-Protection: 1; mode=block X-Content-Type-Options: nosniff Strict-Transport-Security: max-age=31540000 Content-Length: 0 Server: Jetty(9.4.45.v20220203)     ... View more

I never worked with Hive DB, but if it only takes avro format and you have csv you can use processor ConvertRecrod to convert a record from one format to another. In this processor you create CSV Reader service and the writer is Avro ... View more

There is a lot of articles\videos around learning Regular Expression. The one I provided using what is called positive lookbehind (?<=), which means: find the Id which contain alphanumeric characters with hyphen (-) that is proceeded (lookbehind) with the text "requestUid" ... View more

there are a lot of processors that can help you with that for example : PUTSQL, PutDatabaseRecord, ExecuteSQL ... View more

have you tried Selected distinct * order by Date, ERROR_MSG ... View more

It should not matter if the format of the text inside is like csv. ... View more

you can do that using ExtractText Processor to extract the line that you need with word "bind" into an attribute using regular expression "(bind.+$)", then you ReplaceText processor to basically located the same line using the same regular expression and the the replacement  value is the attribute from the ExtractText processor (assume its called XYZ) like this ${XYZ:replace(" ","")} ... View more

Not sure if this is the best way but try using QueryRecord and create one dynamic property to funnel the data into where your query will look like this: Select distinct * from FLOWFILE ... View more