There will be thousands of messages in the SQS.
Is it possible in the Step functions wait until OrderId:123
(json) is in the SQS and then execute the Lambda function when specific Order Id is received?
Edit: Step Functions to call the Lambda function at regular intervals until it manages to retrieve a message with a particular attribute. OrderId attribute will be in the body message. For example:
{
"OrderId": 1235,
"Items": [{"Id":1, "Name": "Item 1"}]
}