82148af6-3788-4526-8b41-2727f858a34b.jpg

Technical Lead

This snippet can be used to calculate a date after certain working days starting from current date.

  

While calculating dates, the process ignores:

1.  Week OFF "Saturday and Sunday" (or days of the week passed as input argument "in\_strWeekOffDays").
2.  Holiday Dates passed in "MM/dd" format as comma separated String to input argument "in\_strHolidayDates".

**Note:** If Holiday dates are year specific, then please pass date in string using the "MM/dd/yyyy" format.

  

**Input Arguments:**

1.  in\_intWokingDaysCount (int) - input of number of days required.
2.  in\_strWeekOffDays (String) - comma separated values of days of the week which are to be considered as non-working days, e.g.: "Saturday,Sunday".
3.  in\_strHolidayDates (String) - comma separated values of dates which are to be considered as to be holiday, e.g.: "07/04,08/15,01/18/2018".
4.  out\_dateAfterWorkingDays (String) - Date in "MM/dd/yyyy" format after "x" working days from current date.

Calculate and get a working date starting with current date.

RabbitMQ is a simple/traditional publish-subscribe message broker. It is usually used as middleman, where a system simply needs to notify another part of the system to start to work on a task, like ordering handling in a webshop (order placed, update order status, send order, payment, etc.). Another main use case is for long-running tasks or when you want to perfome reliable background jobs.

  

It can be used when web servers need to quickly respond to requests. This eliminates the need to perform resource-intensive activities while the user waits for a result. RabbitMQ is also used to convey a message to various recipients for consumption or to share loads between workers under high load (20K+ messages/second).

  

  

In current version the exchange type is default and the queue name is considerd the routing Key.

  

This package contains two activities:

  

1) **Publisher** - This activity can be used to publish a message to a queue.

In-Arguments

a) Hostname: hostname of your server

b) PortNumer: Port Number on which your server is listing (By Default it is 5672)

c) Username

d) Password

e) Queue Name: Queue name in which message is to be pushed (It will create a new queue if a queue does not exist)

f) Durable Queue: If you need or have a durable queue set its value to True

g) Message: Message needs to be sent to Queue

2) **Consumer** - This activity can be used to consume message from a queue.

In-Arguments

a) Hostname: hostname of your server

b) PortNumer: Port Number on which your server is listing (By Default it is 5672)

c) Username

d) Password

e) Queue Name: Queue name from which the message is to be consumed (It will create a new queue if a queue does not exist)

f) Durable Queue: If you need or have a durable queue set its value to True

g) Wait Until: Time in Milliseconds activity will check for message in queue

h) Acknowledgement: true to send acknowledgement of message

Out-Argument

a) Message : Message consumed from the Queue

NOTE: This is the first version, later updates will cover more features like exchange, routing key.

Activities to publish and consume messages from Rabbit MQ

Amazon Simple Queue Service (SQS) is a fully managed message queuing service that enables you to decouple and scale microservices, distributed systems and serverless applications. 

  

SQS eliminates the complexity and overhead associated with managing and operating message oriented middleware, and empowers developers to focus on differentiating work. Using SQS, you can send, store, and receive messages between software components at any volume, without losing messages or requiring other services to be available.

  

AWS SQS Queue Creation Steps : https://docs.aws.amazon.com/AWSSimpleQueueService/latest/SQSDeveloperGuide/sqs-create-queue.html

  

This package consists of 5 activities:

1) Connect SQS

2) Send Message

3) Receive Message

4) Delete Message

5) Purge Queue

Amazon SQS UiPath Integration Activities are developed to access AWS SQS queue via UiPath

About me