Query

id: dataverse_query_accounts
namespace: company.team

tasks:
  - id: query
    type: io.kestra.plugin.microsoft365.dynamics365.dataverse.Query
    tenantId: "{{ secret('AZURE_TENANT_ID') }}"
    clientId: "{{ secret('AZURE_CLIENT_ID') }}"
    clientSecret: "{{ secret('AZURE_CLIENT_SECRET') }}"
    orgUrl: "https://myorg.api.crm.dynamics.com"
    entitySetName: "accounts"
    filter: "statecode eq 0"
    select: "accountid,name,emailaddress1"
    top: 50
    fetchType: FETCH

id: dataverse_store_contacts
namespace: company.team

tasks:
  - id: store
    type: io.kestra.plugin.microsoft365.dynamics365.dataverse.Query
    tenantId: "{{ secret('AZURE_TENANT_ID') }}"
    clientId: "{{ secret('AZURE_CLIENT_ID') }}"
    clientSecret: "{{ secret('AZURE_CLIENT_SECRET') }}"
    orgUrl: "https://myorg.api.crm.dynamics.com"
    entitySetName: "contacts"
    select: "contactid,fullname,emailaddress1"
    fetchType: STORE