How do I Get Compound Values from Confident via Zapier Integration?

This article describes how Clients of Labs can get compound values and data out of Confident by utilizing a Zapier integration.

Set up a Zapier Integration with Confident LIMS

1. To connect Confident LIMS to Zapier, first ensure that Zapier API keys are enabled for your account by going to Clients > Settings > Organization > Integrations > Zapier. If you enable Zapier here, you should see instructions and you will need to click the this link to join the Confident LIMS for Clients Zapier page.
   See How do I Integrate Confident LIMS data with 3rd-party applications? for more information on how to set up 3rd-party integrations.
2. After accepting the Zapier invite, you'll be able to build Zaps (automations) to connect Confident LIMS with other apps.

Set up Zapier to Get Compound Values and Data

Set up a Zap to get compound values and data from Confident by following the steps in the screenshots below and utilizing javascript to parse through analytes.

1. Set up Zap to trigger when an order is Completed for a New Sample
2. Have Zapier find the Sample by it's Sample ID
3. Have Zapier find Assay compound line items and format data
4. Send Data to Code by Zapier and Run Javascript to pull out Sample Data
5. Compound Values are pulled out of Confident for the Sample!
   

   Overall Steps

   

Set up Zap to trigger when an order is Completed for a New Sample

Have Zapier find the Sample by it's Sample ID

Have Zapier find Assay compound line items and format data

Send Data to Code by Zapier and Run Javascript to pull out Sample Data

Javascript:
const text = inputData.text.split('|||');
let obj = {};
text.forEach((element) => {
const [name, value] = element.split('***');
obj[name] = value;
});
output = [obj];

If you have any questions or need additional support, please reach out to api@confidentlims.com!