Get all Insight Links using Groovy

[Andrew Downs]

Hi guys,

I need some assistance please.

I have Insight by Riada and have configured a schema as follows:

1) Customer

2) Warehouse

3) Warehouse Lookup Table

The customer contains the names of various customers, while the Warehouse relates to a location and the Warehouse Lookup Table links to Customer and Warehouse.

Then on the issue when it is created I have two fields which utilize the Insight Lookup as follows:

Customer = Customer Name from Customer insight Scheme

Warehouse = Warehouse Name from Warehouse Insight Scheme

What I am needing to do is based on the customer and warehouse I need to get the Key from Warehouse Lookup Table.

The call then needs to be assigned to the user linked on the Warehouse Lookup Table

As an example of a entry in the Warehouse Lookup table is as follows:

Key: SCMD-123

Name: Warehouse Mapping 1

Warehouse: Cape Town

Customer: Customer 1

Owner: John.Doe

Is this possible?

I can get the ID of the Customer field, but cannot seem to extend beyond that.

Hope that all makes sense.

[Yinon Negev]

As you've also created a Support Ticket in https://portal.riada.io we will answer you on the Ticket directly.

For other users sake:

AS for Groovy script - you can run Groovy scripts in Insight's Postfunctios, Automations Rule, or using a 3rd party addon if needed.

We do have a Groovy Script Consol in Insight for Testing, and we also provide some Groovy Script Examples as well as our Java APIs in our documentation.

Kind regards,

Yinon

Team Riada