Use Case: Retrieving Information for Selected Employees through connector

Camunda 8 Topics Discussion & Questions
1

We have a list of 20 employees, and we need to obtain the contact information for 12 specific employees. These 12 employees may or may not be listed consecutively in the employee data.

one way could be through a common identifier like same department or team
but what will be the expression for it?

Thanks!

2

Hi @Wish , thanks for reaching out!

The best solution would depend on a few things:

  • How and where the list of 20 employees is stored (e.g., in a SQL database, in a process variable)?
  • Are you already using a Connector to solve this problem? If so, please let us know which Connector you’re using :smile:
3

Hey!

Im trying to get the data from sheets using the google sheet connector

4

Thanks for letting us know!

I don’t think you could write a single expression in the Google Sheets Connector that could extract that data for you.

Here are some potential workarounds that use the Google Sheets Connector:

  1. Inside the Google Sheet, write a formula that obtains the information for the 12 specific employees. Then, with the Google Sheets Connector, use the “Get row by index” operation to get the results of that formula.
  2. Use the Google Sheets Connector to get the list of 20 employees and output it to a process variable. Then, use a FEEL expression inside a Script Task to obtain the information for the 12 specific employees.

I hope this helps! :smile:

5

Can you please help me with the expression
i tried this one
= output2[item.department=department].contact(output2 being the data that was read from the sheet)
but the value was giving me empty brackets
I tried this aswell
output2[item in item[5] = department][2]
this is giving a data of
[“########”,“Eva”,“5870000000”,“53”,“sales”] but not all data for the members in the department sales

6

Hi @Wish - I am going to mark @ev.bilske’s reply as the solution and close this thread, since you opened a new topic for your FEEL question: Expression help!

7

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.