How to consume multiple/all messages from a topic subscription?
I have an On-Premise Data Gateway that will send data to an on-prem SQL DB via Logic App, received from the Service Bus.
I've got a Logic App that is currently triggering on When a message is received in a topic subscription (auto-complete). It then passes the decoded contents of that message into an array, where it is JSON formatted and then sent to the on-prem SQL DB via an Execute stored procedure (V2) action.
Currently, it does this instance by instance - but I'd like to reduce transactional cost by batching all available messages into one array via a single Logic App instance.
What would be the best way of achieving this?
Currently, it does this instance by instance
This is the behavior of this connector. For parallelly picking messages you can use When one or more messages arrive in a topic (peek-lock) and can add Maximum message count, but it will also invoke instance parallelly:
According to Microsoft-Document, it says:
The operation receives one or more messages from a topic with peek-lock. If maximum message count is not provided, it reads 20 messages.
- adding a sql api connection using systemassignedmanaged identity from ARM template for azure logic app
- How to consume multiple/all messages from a topic subscription?
- Azure Logic App HTTP Trigger Event Grid Topic
- Connecting to service bus from logic app standard workflow in vs code
- Can't create a file share in a storage account while deploying Logic App from the Portal
- How to pass connection parameters in pulumi python code
- Edit the host.json in my Azure Standard Logic App
- Logic Apps: HTTP request return error code '403'
- Logic Apps copy action gives: The managed identity used with this operation no longer exists. To continue, set up an identity or change the connection
- ARM template for Azure Log Analytics Data Collector
- How do I correctly increase the variable Size in my Azure Logic App?
- Workflow and API connection provisioning for Standard logic app via Bicep templates/scripts
- Azure Logic App Designer shows Run After Task in designer but not in code view
- Logic app - When a new email arrives in a shared mailbox (v2) is not triggering logic app
- How to operate on value in Create CSV step of Logic App?
- Azure Logic App on .NET 6, .NET 8 required
- How do you select one item from a JSON array object in an Azure Workflow
- LogicApp reading from Sharepoint subfolders
- How to write a Bicep API Connection formrecognizer with api key
- How to pass several Id to SQL filter Logic Add?
- Email errors from all activities in ADF at once
- Azure Logic Apps - Queries for telemetry 2.0 show no results
- Case sensitivity in file name and extension in managed File System Connector using Data Gateway
- Logic App - Configure to follow a 308 PermRedirect
- ExpressionEvaluationFailed. The execution of template action 'For_each' failed:
- Azure Logic Apps - Log Analytics - where can I find the output error message?
- How do you get a Key Vault secret using inline ‘CSharp Script Code’ In an Azure Workflow?
- Equivalent Connector for Create Block Blob in Azure Standard Logic App
- Workflow validation failed for the workflow 'shiptest'. {"error":{"code":"WorkflowTriggerTypeUnsupported",
- How can you remove the odata.etag when using the Get Entities action with an Azure Table?