Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,312 questions
making a csv file everyday but on day 2 there is not only the new data but also the data from day 1 in the csv
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 12%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMX%3C/text%3E%3C/svg%3E)
Maebe Xander
0
Reputation points
so for my final i need to make a csv with data from a sensor and every day at 0:00 the data should be put in that csv file the problem that is occuring is that whenever the second day is there that the data from day 1 is also in the csv from day 2 even tho we only want the data that the sensor has sent to us on that day below you see my logic app and how everything is set up right now
{count} votes
-
Aki Nishikawa 1,830 Reputation points Microsoft Employee2024-06-15T06:16:37.96+00:00 Hello @Maebe Xander , Sorry to be so direct, but could you please check if you can retrieve all data emitted on the last day using your SQL statement running on your Logic App? I suppose you can retrieve data filtered by where-clause in the SQL statement, but if all data in the target table are retrieved, you should modify the statement.
-
Maebe Xander 0 Reputation points
2024-06-15T08:15:47.1066667+00:00 hello @Aki Nishikawa euhm im not sure what your asking her but if your aksing if iam getting all the data in my sql statment then yes that statment is just reading all the data in the database instead of only the new data since the last run
Sign in to comment
Sign in to answer