Logic App Twitter Connector and Multiple User Names with CosmosDB

David McCarter 1 Reputation point MVP
2020-07-25T16:50:16.433+00:00

Is there a way to have a Logic App or something similar trigger when a tweet is posted by a list of users from Cosmos DB? So many choices and articles, they all show hardcoded search terms. I need some guidance :-)

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,962 questions
Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,515 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Anurag Sharma 17,586 Reputation points
    2020-07-27T09:57:25.517+00:00

    Hi @DavidMcCarter-5256, yes Logic App is one way to do it. You can try below steps to get the desired result through Azure Logic App:

    1) Create New Logic App and provide a primary connection account:

    13778-image.png

    2) Configure the next step in workflow by getting the usernames from all documents in collection. It will be good idea to save the username with '@' prefix, so to match the twitter account names:

    13856-image.png

    3) Then we need to create another step and loop through the result set from prior step as below:

    13767-image.png

    4) Finally, we can write the result by creating another document in the 'For Each' container.

    Please let me know if this helps or any other information is needed.


    If an Answer is helpful, please “Accept Answer” or Up-Vote for the same which might be beneficial to other community members reading this thread.

    0 comments No comments