Create a parent-child relationship between two triggers

👋 Hey @benjamink9 ,

Am I correctly understanding that the goal is the following flow?

1. User selects an entity
2. Depending on the entity selected, show different dropdown options in the Project field

If so, the issue currently appears to be that there’s no way to map the entity_id field in the hidden get_project trigger.

Instead, I might suggest trying the following:

• Remove the entity_id field from the get_project trigger
• Paste the entity_id field into the lorem_ipsum action so the action has two fields, one for entity and one for project
• Add altersDynamicFields: true to entity_id so the project field is recomputed when entity_id changes

This way, when the user selects an entity from the entity field, the bundle will include the value the that the project field needs to run its perform and return the corresponding dropdown choices.

The action might then look something like the following:

const perform = async (z, bundle) => {
  return {id: 1, name: 'Lorem Ipsum'};
};

module.exports = {
    display: {
      description: 'lorem ipsum',
      hidden: false,
      label: 'Lorem Ipsum',
    },
    key: 'lorem_ipsum',
    noun: 'Lorem',
    operation: {
      inputFields: [
        {
          key: 'entity_id', // copied over from get_project
          label: 'Entity ID',
          type: 'integer',
          required: true,
          dynamic: 'get_entity.id.name',
          altersDynamicFields: true // new
        },
        {
          key: 'project_id',
          label: 'project',
          type: 'integer',
          dynamic: 'get_project.id.name',
          required: true,
          list: false,
          altersDynamicFields: false,
        },
      ],
      outputFields: [
        { key: 'id' },
        { key: 'name' },
      ],
      perform: perform,
    },
  };

Apologies if I’ve misunderstood, but I hope this is a step in the right direction.

I actually need to use the parent (entity_id) to restrict multiple children (project, department, location).  I think I would need to have multiple references to entity_id in the action, one for each child.

Will your approach work for this?

Using the entity_id repeatedly didn’t work--each input needs to have a unique name.  Is there another approach?

Currently, I have three triggers:

get_legal_entities:

const perform = async (z, bundle) => {
  const options = {
    url: 'https://apis.paycor.com/v1/legalentities/ActivatedLegalEntityTenantList',
    method: 'GET',
    headers: {
      Accept: 'application/json',
      'Ocp-Apim-Subscription-Key': bundle.authData.subscription_key,
      Authorization: `bearer ${bundle.authData.access_token}`,
    },
  };

  return z.request(options).then((response) => {
    response.throwForStatus();
    const results = response.json;

    // becasue Zapier requires that each array element have an id property
    results.userLegalEntities.forEach(element => {
      element.id = element.legalEntityId
    });

    return results.userLegalEntities;
  });
};

get_work_locations:

const perform = async (z, bundle) => {
  const options = {
    url: `https://apis.paycor.com/v1/legalentities/${bundle.authData.legal_entity_id}/worklocations`,
    method: 'GET',
    headers: {
      Accept: 'application/json',
      'Ocp-Apim-Subscription-Key': bundle.authData.subscription_key,
      Authorization: `bearer ${bundle.authData.access_token}`,
    },
  };

  return z.request(options).then((response) => {
    response.throwForStatus();
    const results = response.json;

    return results.records;
  });
};

and

get_job_titles:

const perform = async (z, bundle) => {
  const options = {
    url: `https://apis.paycor.com/v1/tenants/${bundle.authData.legal_entity_id}/jobtitles`,
    method: 'GET',
    headers: {
      Accept: 'application/json',
      'Ocp-Apim-Subscription-Key': bundle.authData.subscription_key,
      Authorization: `bearer ${bundle.authData.access_token}`,
    },
  };

  return z.request(options).then((response) => {
    response.throwForStatus();
    const results = response.json;

    // becasue Zapier requires that each array element have an id property
    results.records.forEach(element => {
      element.id = element.JobTitleId
    });

    return results.records;
  });
};

Currently,I get the legal_entity_id from the authentication script:

    {
      computed: false,
      key: 'legal_entity_id',
      required: true,
      label: 'Legal Entity Id',
      type: 'string',
      helpText: 'LegalEntityId = ClientID',
    },

These triggers are referenced by two inputs in create_employee action:

      {
        key: 'WorkLocation',
        label: 'Work Location',
        type: 'integer',
        dynamic: 'get_work_locations.id.name',
        required: false,
        list: false,
        altersDynamicFields: false,
        helpText: 'The name of the Work Location to associate with new hire.'
      },
      {
        key: 'JobTitle',
        label: 'Job Title',
        type: 'string',
        dynamic: 'get_job_titles.JobTitle',
        required: false,
        list: false,
        altersDynamicFields: false,
        helpText: "The employee's job title."
      },  

What I want to be able to include a reference to the get_legal_entity trigger, such that I can use the bundle.inputData.legal_entity_id, rather than bundle.authData.legal_entity_id (I don’t want to hard code this value in the auth settings).  Unfortunately, I haven’t been able to get this to work.

Any suggestions?