Price Comparisons Using Retail REST APIs with Apache NiFi, Kafka and Flink SQL
Published: 2021-03-08 20:44:59

---
title: Price Comparisons Using Retail REST APIs with Apache NiFi, Kafka and Flink SQL
published: true
date: 2021-03-08 16:45:00 UTC
tags: 
canonical_url: 
---

## ** Price Comparisons Using Retail REST APIs with Apache NiFi, Kafka and Flink SQL**

  

**Part 1:   NiFi Rest**

**Part 2:   Kafka - Flink SQL**

**Part 3:  Cloudera Visual Apps**

**Part 4:   Smart Shelf Updates - MiNiFi Agents**

  

[![](https://1.bp.blogspot.com/-lfXMW-AsGYc/YBxwnIzbifI/AAAAAAAAct8/fG1MyzqTvOYtxiQrt9yoNcdKXMDiWtqegCLcBGAsYHQ/w640-h518/deviceHealthData.png)](https://1.bp.blogspot.com/-lfXMW-AsGYc/YBxwnIzbifI/AAAAAAAAct8/fG1MyzqTvOYtxiQrt9yoNcdKXMDiWtqegCLcBGAsYHQ/s662/deviceHealthData.png)
  

[![](https://1.bp.blogspot.com/-Xh_v0cnkxh8/YBxwnS8q1HI/AAAAAAAAcuE/DfEISxnlhqEzZw8P5vTJOT1265SctX3KQCLcBGAsYHQ/w640-h338/enterprisedata.png)](https://1.bp.blogspot.com/-Xh_v0cnkxh8/YBxwnS8q1HI/AAAAAAAAcuE/DfEISxnlhqEzZw8P5vTJOT1265SctX3KQCLcBGAsYHQ/s2048/enterprisedata.png)
  

[![](https://1.bp.blogspot.com/-HCiCxISnePQ/YBxwnfMSguI/AAAAAAAAcuA/zLQTAXFwp-M1J5OtNJ1JFu5IOT_fL8NSgCLcBGAsYHQ/w640-h444/instore.png)](https://1.bp.blogspot.com/-HCiCxISnePQ/YBxwnfMSguI/AAAAAAAAcuA/zLQTAXFwp-M1J5OtNJ1JFu5IOT_fL8NSgCLcBGAsYHQ/s1091/instore.png)
  

[![](https://1.bp.blogspot.com/-DuR5rMo9ctY/YBxwu5TfsfI/AAAAAAAAcuY/viUnCqQc4uQb2q9hmlIMdjFPf0IBrQBewCLcBGAsYHQ/w640-h508/pricing.png)](https://1.bp.blogspot.com/-DuR5rMo9ctY/YBxwu5TfsfI/AAAAAAAAcuY/viUnCqQc4uQb2q9hmlIMdjFPf0IBrQBewCLcBGAsYHQ/s959/pricing.png)
  

[![](https://1.bp.blogspot.com/-FRYS_itLpU8/YBxwng2KS9I/AAAAAAAAcuM/GZmj5Vz08-E_S1DJJV698UrZUXu0XVCQACLcBGAsYHQ/w640-h516/report2.png)](https://1.bp.blogspot.com/-FRYS_itLpU8/YBxwng2KS9I/AAAAAAAAcuM/GZmj5Vz08-E_S1DJJV698UrZUXu0XVCQACLcBGAsYHQ/s1413/report2.png)
  

[![](https://1.bp.blogspot.com/-4d_RW8AeSfI/YBxwnRpy2KI/AAAAAAAAcuI/8P9A3PnGJBEK_7JGInX7n36RhY8F19tfgCLcBGAsYHQ/w640-h544/report.png)](https://1.bp.blogspot.com/-4d_RW8AeSfI/YBxwnRpy2KI/AAAAAAAAcuI/8P9A3PnGJBEK_7JGInX7n36RhY8F19tfgCLcBGAsYHQ/s1411/report.png)
  

[![](https://1.bp.blogspot.com/-qCru0OFoDJo/YBxwnrUJNUI/AAAAAAAAcuQ/KazjbnkS1B0MtLNI1Rx6Cuu7Raw7dczzwCLcBGAsYHQ/w640-h542/reports.png)](https://1.bp.blogspot.com/-qCru0OFoDJo/YBxwnrUJNUI/AAAAAAAAcuQ/KazjbnkS1B0MtLNI1Rx6Cuu7Raw7dczzwCLcBGAsYHQ/s1409/reports.png)
  

[![](https://1.bp.blogspot.com/-YYQx1fe8EzA/YBxwnyUXctI/AAAAAAAAcuU/6ItbVdjYXF4oyv4XgckE8zGxYcNJGFiNQCLcBGAsYHQ/w640-h276/retailapps.png)](https://1.bp.blogspot.com/-YYQx1fe8EzA/YBxwnyUXctI/AAAAAAAAcuU/6ItbVdjYXF4oyv4XgckE8zGxYcNJGFiNQCLcBGAsYHQ/s2551/retailapps.png)

  

[![](https://1.bp.blogspot.com/-MQ_hPigT7oA/YBxxEyx05rI/AAAAAAAAcu4/b8_ANQB1x1sHObZC20CY7VXghV2Vxm-aACLcBGAsYHQ/w640-h508/CDCPostgresqlNiFi1.png)](https://1.bp.blogspot.com/-MQ_hPigT7oA/YBxxEyx05rI/AAAAAAAAcu4/b8_ANQB1x1sHObZC20CY7VXghV2Vxm-aACLcBGAsYHQ/s1103/CDCPostgresqlNiFi1.png)
  

[![](https://1.bp.blogspot.com/-6dV5-UG8tN0/YBxxFjQ-JxI/AAAAAAAAcvE/spxUW8BnLZ4RCX_2sRNtlguzV7J44jvXwCLcBGAsYHQ/w640-h372/cdcQueryDatabaseTablePgsql.png)](https://1.bp.blogspot.com/-6dV5-UG8tN0/YBxxFjQ-JxI/AAAAAAAAcvE/spxUW8BnLZ4RCX_2sRNtlguzV7J44jvXwCLcBGAsYHQ/s1137/cdcQueryDatabaseTablePgsql.png)
  

[![](https://1.bp.blogspot.com/-Bd8CkmFcVqY/YBxxFgmHHdI/AAAAAAAAcvI/egWxKOWoG9kHAj8bvQqIdf0P0b6m0QnbwCLcBGAsYHQ/w640-h334/efmRetailPricing.png)](https://1.bp.blogspot.com/-Bd8CkmFcVqY/YBxxFgmHHdI/AAAAAAAAcvI/egWxKOWoG9kHAj8bvQqIdf0P0b6m0QnbwCLcBGAsYHQ/s2048/efmRetailPricing.png)
  

[![](https://1.bp.blogspot.com/-EWL1LuHvw0E/YBxxF5rkHSI/AAAAAAAAcvQ/LvLWfg4j6yw4-3r_x4qfPRWZvgOq1M-4wCLcBGAsYHQ/w640-h374/efmRetailPricingOverview.png)](https://1.bp.blogspot.com/-EWL1LuHvw0E/YBxxF5rkHSI/AAAAAAAAcvQ/LvLWfg4j6yw4-3r_x4qfPRWZvgOq1M-4wCLcBGAsYHQ/s1788/efmRetailPricingOverview.png)
  

[![](https://1.bp.blogspot.com/-2QqQMtS-U7o/YBxxF1D-gfI/AAAAAAAAcvM/XCDNVUCmYCIMjBN6fOU9PGOM4j8c0_x4gCLcBGAsYHQ/w428-h640/extractPriceefm.png)](https://1.bp.blogspot.com/-2QqQMtS-U7o/YBxxF1D-gfI/AAAAAAAAcvM/XCDNVUCmYCIMjBN6fOU9PGOM4j8c0_x4gCLcBGAsYHQ/s1169/extractPriceefm.png)
  

[![](https://1.bp.blogspot.com/-MXRh68ZlZpc/YBxxGBIdESI/AAAAAAAAcvU/GDI0M4IpMJQpw0s5V_ztOprwPwqTU0mOQCLcBGAsYHQ/w640-h360/freshFoodMonitoringKafka.png)](https://1.bp.blogspot.com/-MXRh68ZlZpc/YBxxGBIdESI/AAAAAAAAcvU/GDI0M4IpMJQpw0s5V_ztOprwPwqTU0mOQCLcBGAsYHQ/s1388/freshFoodMonitoringKafka.png)
  

[![](https://1.bp.blogspot.com/-Plt9ByZA2DE/YBxxGSwpgpI/AAAAAAAAcvY/PYNHbCN2HY4UrkBape7-tde8Zdaz2qxFgCLcBGAsYHQ/w640-h340/freshFoodMonitoringWithSQL.png)](https://1.bp.blogspot.com/-Plt9ByZA2DE/YBxxGSwpgpI/AAAAAAAAcvY/PYNHbCN2HY4UrkBape7-tde8Zdaz2qxFgCLcBGAsYHQ/s872/freshFoodMonitoringWithSQL.png)
  

[![](https://1.bp.blogspot.com/-CBAIqugPWbQ/YBxxG_-2uiI/AAAAAAAAcvc/xzd36KQI1-A5D01IQSUIwvtcNFipoTzrACLcBGAsYHQ/w640-h596/instoredatacollection.png)](https://1.bp.blogspot.com/-CBAIqugPWbQ/YBxxG_-2uiI/AAAAAAAAcvc/xzd36KQI1-A5D01IQSUIwvtcNFipoTzrACLcBGAsYHQ/s920/instoredatacollection.png)
  

[![](https://1.bp.blogspot.com/-I2d9RltlxtY/YBxxHaPzUyI/AAAAAAAAcvg/BOqKD43fZwIN9BNiu_pMZ3Qbm0kd0yJyACLcBGAsYHQ/w640-h288/listminififlows.png)](https://1.bp.blogspot.com/-I2d9RltlxtY/YBxxHaPzUyI/AAAAAAAAcvg/BOqKD43fZwIN9BNiu_pMZ3Qbm0kd0yJyACLcBGAsYHQ/s2641/listminififlows.png)
  

[![](https://1.bp.blogspot.com/-jk6VAZOimrY/YBxxHoCLk3I/AAAAAAAAcvo/1G0RV11TsiUw2vaYIx045VXCrEQmW1mtgCLcBGAsYHQ/w640-h296/nifiretailpricing.png)](https://1.bp.blogspot.com/-jk6VAZOimrY/YBxxHoCLk3I/AAAAAAAAcvo/1G0RV11TsiUw2vaYIx045VXCrEQmW1mtgCLcBGAsYHQ/s2611/nifiretailpricing.png)
  

[![](https://1.bp.blogspot.com/-dhdjlRTpzX0/YBxxHyjivZI/AAAAAAAAcvk/5aKpwUDs-pgNgj65EqQqUGfhvg0FnzI7QCLcBGAsYHQ/w640-h226/pointOfSaleDataRealtime.png)](https://1.bp.blogspot.com/-dhdjlRTpzX0/YBxxHyjivZI/AAAAAAAAcvk/5aKpwUDs-pgNgj65EqQqUGfhvg0FnzI7QCLcBGAsYHQ/s2500/pointOfSaleDataRealtime.png)
  

[![](https://1.bp.blogspot.com/-KHZA-vnXCEE/YBxxH-buo9I/AAAAAAAAcvs/Pf2z7uR5wgcs_b_s4A7klkkCzWCl7TfVACLcBGAsYHQ/w640-h378/posCollection.png)](https://1.bp.blogspot.com/-KHZA-vnXCEE/YBxxH-buo9I/AAAAAAAAcvs/Pf2z7uR5wgcs_b_s4A7klkkCzWCl7TfVACLcBGAsYHQ/s1176/posCollection.png)
  

[![](https://1.bp.blogspot.com/-gfETSGbQuOg/YBxxEzQ46wI/AAAAAAAAcu0/V-EnexAyO0cU_P-mUqGomwsKugvUzXKOQCLcBGAsYHQ/w640-h566/POStoKafka.png)](https://1.bp.blogspot.com/-gfETSGbQuOg/YBxxEzQ46wI/AAAAAAAAcu0/V-EnexAyO0cU_P-mUqGomwsKugvUzXKOQCLcBGAsYHQ/s1222/POStoKafka.png)
  

[![](https://1.bp.blogspot.com/-571XEAS5UFM/YBxxICqKkwI/AAAAAAAAcv4/Ce2z4phw3ZYeJxRDwKQZt5hMQICOGnm5QCLcBGAsYHQ/w536-h640/pricingoverview.png)](https://1.bp.blogspot.com/-571XEAS5UFM/YBxxICqKkwI/AAAAAAAAcv4/Ce2z4phw3ZYeJxRDwKQZt5hMQICOGnm5QCLcBGAsYHQ/s1027/pricingoverview.png)
  

[![](https://1.bp.blogspot.com/-4z1SViS8nQo/YBxxIMi4TBI/AAAAAAAAcvw/6ZL9xPlfBa0PYs2rPTl_JWEW6tZ82MO4ACLcBGAsYHQ/w640-h326/querydatastatecdc.png)](https://1.bp.blogspot.com/-4z1SViS8nQo/YBxxIMi4TBI/AAAAAAAAcvw/6ZL9xPlfBa0PYs2rPTl_JWEW6tZ82MO4ACLcBGAsYHQ/s1474/querydatastatecdc.png)
  

[![](https://1.bp.blogspot.com/-Sxr1s728Gdc/YBxxIGZ0uNI/AAAAAAAAcv0/RpiY6Tvv4wUiS1R4yqi_3j62yQLRHE6OwCLcBGAsYHQ/w640-h192/reportLineageToAtlasState.png)](https://1.bp.blogspot.com/-Sxr1s728Gdc/YBxxIGZ0uNI/AAAAAAAAcv0/RpiY6Tvv4wUiS1R4yqi_3j62yQLRHE6OwCLcBGAsYHQ/s1532/reportLineageToAtlasState.png)
  

  

  

  

[![](https://1.bp.blogspot.com/--wsG-hJW4HI/YBxxIW5uB5I/AAAAAAAAcv8/bMsEzVoBJYglOL1m3DithgaV_wE6-wMJQCLcBGAsYHQ/w640-h222/retailHue.png)](https://1.bp.blogspot.com/--wsG-hJW4HI/YBxxIW5uB5I/AAAAAAAAcv8/bMsEzVoBJYglOL1m3DithgaV_wE6-wMJQCLcBGAsYHQ/s2215/retailHue.png)
  

[![](https://1.bp.blogspot.com/-SVlXo4-fqkc/YBxxIkWRmkI/AAAAAAAAcwA/cb_VP8aikzwRTfQbZ9eYy3Pvo01Xy-NOQCLcBGAsYHQ/w640-h302/retailpricingdeployment.png)](https://1.bp.blogspot.com/-SVlXo4-fqkc/YBxxIkWRmkI/AAAAAAAAcwA/cb_VP8aikzwRTfQbZ9eYy3Pvo01Xy-NOQCLcBGAsYHQ/s2580/retailpricingdeployment.png)
  

[![](https://1.bp.blogspot.com/-N_2jzCBIoxg/YBxxJIGgUPI/AAAAAAAAcwE/eq4YSCzqAxIP2uvC5KRRI7RHOwh83vlYgCLcBGAsYHQ/w640-h120/retailpricingevents.png)](https://1.bp.blogspot.com/-N_2jzCBIoxg/YBxxJIGgUPI/AAAAAAAAcwE/eq4YSCzqAxIP2uvC5KRRI7RHOwh83vlYgCLcBGAsYHQ/s3122/retailpricingevents.png)
  

[![](https://1.bp.blogspot.com/-wMMMliufFt4/YBxxJcMnZJI/AAAAAAAAcwI/itL41S3q_XAyZmVVwHeBcX9XwzM3UzQDACLcBGAsYHQ/w434-h640/setPriceonShelf.png)](https://1.bp.blogspot.com/-wMMMliufFt4/YBxxJcMnZJI/AAAAAAAAcwI/itL41S3q_XAyZmVVwHeBcX9XwzM3UzQDACLcBGAsYHQ/s1117/setPriceonShelf.png)
  

[![](https://1.bp.blogspot.com/-CAsIuNMovBI/YBxxJpp7qzI/AAAAAAAAcwM/aKtLx0bMOLcdTO16Gt59Yoqi9CyKhSggwCLcBGAsYHQ/w640-h310/smmPriceChanges.png)](https://1.bp.blogspot.com/-CAsIuNMovBI/YBxxJpp7qzI/AAAAAAAAcwM/aKtLx0bMOLcdTO16Gt59Yoqi9CyKhSggwCLcBGAsYHQ/s2545/smmPriceChanges.png)
  

[![](https://1.bp.blogspot.com/-CL0cBL-GtZM/YBxxKA_meJI/AAAAAAAAcwQ/vR-Zce4wYs8H08blxPwlC1d0Q2EeddJ-wCLcBGAsYHQ/w640-h330/smmRetailPricing.png)](https://1.bp.blogspot.com/-CL0cBL-GtZM/YBxxKA_meJI/AAAAAAAAcwQ/vR-Zce4wYs8H08blxPwlC1d0Q2EeddJ-wCLcBGAsYHQ/s2048/smmRetailPricing.png)
  

[![](https://1.bp.blogspot.com/-gWO0gM1saic/YBxxKLDugRI/AAAAAAAAcwU/H-QrRO1zH50Okk3nK91k-sZTNTZO4rmMgCLcBGAsYHQ/w640-h326/thistableisbananas.png)](https://1.bp.blogspot.com/-gWO0gM1saic/YBxxKLDugRI/AAAAAAAAcwU/H-QrRO1zH50Okk3nK91k-sZTNTZO4rmMgCLcBGAsYHQ/s1949/thistableisbananas.png)
  

[![](https://1.bp.blogspot.com/-dXv7fFSgSLQ/YBxxKXuNTnI/AAAAAAAAcwY/yVhKUT2nRVQ5EEQj0LC9GKv71i3ZhpC1ACLcBGAsYHQ/w640-h272/updatingCloudPostgresql.png)](https://1.bp.blogspot.com/-dXv7fFSgSLQ/YBxxKXuNTnI/AAAAAAAAcwY/yVhKUT2nRVQ5EEQj0LC9GKv71i3ZhpC1ACLcBGAsYHQ/s2725/updatingCloudPostgresql.png)
  

[![](https://1.bp.blogspot.com/-fCgJIINIde0/YBxxK52U2OI/AAAAAAAAcwc/aScSdJwGMsQFasvskgcpD53bCzIwGrVngCLcBGAsYHQ/w640-h548/validateAndDistributePOSAlerts.png)](https://1.bp.blogspot.com/-fCgJIINIde0/YBxxK52U2OI/AAAAAAAAcwc/aScSdJwGMsQFasvskgcpD53bCzIwGrVngCLcBGAsYHQ/s1064/validateAndDistributePOSAlerts.png)