to get a personalized navigation.
to get a personalized navigation.
I get an error on a big associate query with several joinups and joindowns of different associates. It seems I have reached some sort of limit, because if I remove a few fields it works. Error message is just the following:
{
"errors": [
{
"message": "Error executing document.",
"extensions": {
"code": "INVALID_OPERATION",
"codes": [
"INVALID_OPERATION"
]
}
}
]
}
Query that doesn't work:
query VBNxtGetAssociatesQuery($companyId: Int!, $customerId: Int!, $associatesLimit: Int!, $endCursor: String) {
useCompany(no: $companyId) {
associate(
filter: {_and: [{customerNo: {_eq: $customerId}}]}
after: $endCursor
unoptimized: true
first: $associatesLimit
) {
totalCount
pageInfo {
hasNextPage
hasPreviousPage
startCursor
endCursor
}
items {
associateNo
privatePerson
employeeNo
customerNo
supplierNo
invoiceCustomerNo
sendToAssociateNo
sendInToAssociateNo
contactFor
seller
name
companyNo
webPage1
webPage2
title
phone
fax1
mobilePhone
memoFileName
customerPriceGroup1
customerPriceGroup2
group1
group2
emailAddress
addressLine1
addressLine2
postCode
postalArea
addressLine3
addressLine4
visitPostCode
visitPostalArea
countryNo
currencyNo
creditLimit
creditDenied
createdDateTime
changedDateTime
joinup_Country {
countryNo
name
isoCode
companyRate
privateRate
minInterestPerTransactions
interestFee
defaultTaxCode
}
joinup_Associate_via_Seller {
associateNo
privatePerson
employeeNo
customerNo
supplierNo
invoiceCustomerNo
sendToAssociateNo
sendInToAssociateNo
contactFor
seller
name
companyNo
webPage1
webPage2
title
phone
fax1
mobilePhone
memoFileName
customerPriceGroup1
customerPriceGroup2
group1
group2
emailAddress
addressLine1
addressLine2
postCode
postalArea
addressLine3
addressLine4
visitPostCode
visitPostalArea
countryNo
currencyNo
creditLimit
creditDenied
createdDateTime
changedDateTime
}
joinup_Associate_via_ContactFor {
associateNo
privatePerson
employeeNo
customerNo
supplierNo
invoiceCustomerNo
sendToAssociateNo
sendInToAssociateNo
contactFor
seller
name
companyNo
webPage1
webPage2
title
phone
fax1
mobilePhone
memoFileName
customerPriceGroup1
customerPriceGroup2
group1
group2
emailAddress
addressLine1
addressLine2
postCode
postalArea
addressLine3
addressLine4
visitPostCode
visitPostalArea
countryNo
currencyNo
creditLimit
creditDenied
createdDateTime
changedDateTime
}
joinup_Associate_via_InvoiceCustomer {
associateNo
privatePerson
employeeNo
customerNo
supplierNo
invoiceCustomerNo
sendToAssociateNo
sendInToAssociateNo
contactFor
seller
name
companyNo
webPage1
webPage2
title
phone
fax1
mobilePhone
memoFileName
customerPriceGroup1
customerPriceGroup2
group1
group2
emailAddress
addressLine1
addressLine2
postCode
postalArea
addressLine3
addressLine4
visitPostCode
visitPostalArea
countryNo
currencyNo
creditLimit
creditDenied
createdDateTime
changedDateTime
}
joindown_Associate_via_SendToAssociate {
totalCount
items {
associateNo
privatePerson
employeeNo
customerNo
supplierNo
invoiceCustomerNo
sendToAssociateNo
sendInToAssociateNo
contactFor
seller
name
companyNo
webPage1
webPage2
title
phone
fax1
mobilePhone
memoFileName
customerPriceGroup1
customerPriceGroup2
group1
group2
emailAddress
addressLine1
addressLine2
postCode
postalArea
addressLine3
addressLine4
visitPostCode
visitPostalArea
countryNo
currencyNo
creditLimit
creditDenied
createdDateTime
changedDateTime
}
}
joindown_Associate_via_SendInToAssociate {
totalCount
items {
associateNo
privatePerson
employeeNo
customerNo
supplierNo
invoiceCustomerNo
sendToAssociateNo
sendInToAssociateNo
contactFor
seller
name
companyNo
webPage1
webPage2
title
phone
fax1
mobilePhone
memoFileName
customerPriceGroup1
customerPriceGroup2
group1
group2
emailAddress
addressLine1
addressLine2
postCode
postalArea
addressLine3
addressLine4
visitPostCode
visitPostalArea
countryNo
currencyNo
creditLimit
creditDenied
createdDateTime
changedDateTime
}
}
}
}
}
}
Response:
{
"errors": [
{
"message": "Error executing document.",
"extensions": {
"code": "INVALID_OPERATION",
"codes": [
"INVALID_OPERATION"
]
}
}
]
}
Query that works (removed 4 fields from the query above):
query VBNxtGetAssociatesQuery($companyId: Int!, $customerId: Int!, $associatesLimit: Int!, $endCursor: String) {
useCompany(no: $companyId) {
associate(
filter: {_and: [{customerNo: {_eq: $customerId}}]}
after: $endCursor
unoptimized: true
first: $associatesLimit
) {
totalCount
pageInfo {
hasNextPage
hasPreviousPage
startCursor
endCursor
}
items {
associateNo
privatePerson
employeeNo
customerNo
supplierNo
invoiceCustomerNo
sendToAssociateNo
sendInToAssociateNo
contactFor
seller
name
companyNo
webPage1
webPage2
title
phone
fax1
mobilePhone
memoFileName
customerPriceGroup1
customerPriceGroup2
group1
group2
emailAddress
addressLine1
addressLine2
postCode
postalArea
addressLine3
addressLine4
visitPostCode
visitPostalArea
countryNo
currencyNo
creditLimit
creditDenied
createdDateTime
changedDateTime
joinup_Country {
countryNo
name
isoCode
companyRate
privateRate
minInterestPerTransactions
interestFee
defaultTaxCode
}
joinup_Associate_via_Seller {
associateNo
privatePerson
employeeNo
customerNo
supplierNo
invoiceCustomerNo
sendToAssociateNo
sendInToAssociateNo
contactFor
seller
name
companyNo
webPage1
webPage2
title
phone
fax1
mobilePhone
memoFileName
customerPriceGroup1
customerPriceGroup2
group1
group2
emailAddress
addressLine1
addressLine2
postCode
postalArea
addressLine3
addressLine4
visitPostCode
visitPostalArea
countryNo
currencyNo
creditLimit
creditDenied
createdDateTime
changedDateTime
}
joinup_Associate_via_ContactFor {
associateNo
privatePerson
employeeNo
customerNo
supplierNo
invoiceCustomerNo
sendToAssociateNo
sendInToAssociateNo
contactFor
seller
name
companyNo
webPage1
webPage2
title
phone
fax1
mobilePhone
memoFileName
customerPriceGroup1
customerPriceGroup2
group1
group2
emailAddress
addressLine1
addressLine2
postCode
postalArea
addressLine3
addressLine4
visitPostCode
visitPostalArea
countryNo
currencyNo
creditLimit
creditDenied
createdDateTime
changedDateTime
}
joinup_Associate_via_InvoiceCustomer {
associateNo
privatePerson
employeeNo
customerNo
supplierNo
invoiceCustomerNo
sendToAssociateNo
sendInToAssociateNo
contactFor
seller
name
companyNo
webPage1
webPage2
title
phone
fax1
mobilePhone
memoFileName
customerPriceGroup1
customerPriceGroup2
group1
group2
emailAddress
addressLine1
addressLine2
postCode
postalArea
addressLine3
addressLine4
visitPostCode
visitPostalArea
countryNo
currencyNo
creditLimit
creditDenied
createdDateTime
changedDateTime
}
joindown_Associate_via_SendToAssociate {
totalCount
items {
associateNo
privatePerson
employeeNo
customerNo
supplierNo
invoiceCustomerNo
sendToAssociateNo
sendInToAssociateNo
contactFor
seller
name
companyNo
webPage1
webPage2
title
phone
fax1
mobilePhone
memoFileName
customerPriceGroup1
customerPriceGroup2
group1
group2
emailAddress
addressLine1
addressLine2
postCode
postalArea
addressLine3
addressLine4
visitPostCode
visitPostalArea
countryNo
currencyNo
creditLimit
creditDenied
createdDateTime
changedDateTime
}
}
joindown_Associate_via_SendInToAssociate {
totalCount
items {
associateNo
privatePerson
employeeNo
customerNo
supplierNo
invoiceCustomerNo
sendToAssociateNo
sendInToAssociateNo
contactFor
seller
name
companyNo
webPage1
webPage2
title
phone
fax1
mobilePhone
memoFileName
customerPriceGroup1
customerPriceGroup2
group1
group2
emailAddress
addressLine1
addressLine2
postCode
postalArea
addressLine3
addressLine4
visitPostCode
visitPostalArea
createdDateTime
changedDateTime
}
}
}
}
}
}
Solved! Go to Solution.
Seems like it was a temporary issue. Working fine now.
Copyright © 2022 Visma.com. All rights reserved.