How to get customer group name

[kashyap]

Customer/Actor have customerPriceGroup1 and customerPriceGroup2.  We could not found in which table its relate it.

query GetCustomers($companyNo: Int = 4611115, $pageSize: Int = 10, $after: String) {
  useCompany(no: $companyNo) {
    associate(
      first: $pageSize
      after: $after
      filter: {
        createdDateTime: {_gte: "2023-01-01T10:00:00"},
        customerNo:{
          _gt: 0
        }
      }
    ) {
      totalCount
      pageInfo {
        hasNextPage
        hasPreviousPage
        startCursor
        endCursor
      }
      items {
        companyNo
        associateNo
        customerNo
        name
        addressLine1
        addressLine2
        addressLine3
        addressLine4
        postCode
        postalArea
        emailAddress
        phone
        mobilePhone
        privatePhone
        countryNo
        customerPriceGroup1
        country: joinup_Country {
          name
        }
        creditLimit
        creditDenied
        createdDate
        createdTime
        createdDateTime
      }
    }
  }
}

[omelhus]

These are text types in the text table. Check https://model.vbnxt.rocks/Associate#content to easily find what text type the different columns reference.

 

[kashyap]

This we know, but how we can joinup with Txt table?

[omelhus]

You can’t. You need two queries and stitch it afterwards.

I’ve suggested that Visma add a separate helper using data loader for this, but it did not get any traction.