Echo Dot (3rd Gen) - Smart speaker with Alexa - Charcoal

Use your voice to play a song, artist, or genre through Amazon Music, Apple Music, Spotify, Pandora, and others. With compatible Echo devices in different rooms, you can fill your whole home with music.

Buy Now

Wireless Rechargeable Battery Powered WiFi Camera.

Wireless Rechargeable Battery Powered WiFi Camera is home security camera system lets you listen in and talk back through the built in speaker and microphone that work directly through your iPhone or Android Mic.

Buy Now

Twitter Bot in Minutes with Azure

0
118


Step-5: Loop through results, Set Variables from JSON

Step-6: Execute SQL Query with set Variable

Add SQL server action, were going to query the DB for any row that has the timeStamp from the JSON here we insert our Variable into Query to make it Dynamic.

Query DB for Results with timeStamp

Step-7: Parse Query set Schema

The SQL Query returns the results in JSON so we can easily Parse JSON and understand if new timeStamp exists in the DB.

Parse JSON from SQL query

Step-8: Add Condition, find if Empty

Add Condition logic to determine if JSON result from SQL contains new value if it does not than we know its a new question since that timeStamp does not exist inside the DB. I simply check if ResultSets are not Empty.

Determine if DB contains new Values from JSON
Conditional logic to determine if to Post to Social Media



Read More

LEAVE A REPLY

Please enter your comment!
Please enter your name here