I have found the solution, for the changing parts of the url https://mycompany\.my\.app/api/public/v1/organisations/([0-9a-z]+)/detailedLaborcosts.* ... View more

Hi, Not sure how you get the URL but if its hard coded in the InvokeHttp Remote URL property , then you can use expression language to set up your parameters as follows:   ${literal('https://api.aa/reports/api/order_report/?format=json&dateFrom=#DATEFROM&dateTo=#DATETO'): replace('#DATEFROM',${now():format('yyyy-MM-dd')}): replace('#DATETO',${now():toNumber():minus(432000000):format("yyyy-MM-dd")})}   Notice: - you can set the date format as desired, in my case I assumed that its in yyyy-MM-dd format. - To subtract 5 days from the current date you have to convert the date to number , then subtract 5 days in milliseconds (1day = 86,400,000 mls ). Hope that helps, if it does please accept solution. Thanks ... View more

Hi ,   you can use QueryRecord Processor. For more information please see: https://nifi.apache.org/docs/nifi-docs/components/org.apache.nifi/nifi-standard-nar/1.12.1/org.apache.nifi.processors.standard.QueryRecord/additionalDetails.html If you find this helpful please accept solution. Thanks ... View more