About filip-yabieenterprise

filip-yabieenterprise · ‎07-02-2024

Hi! Since about a week ago, we have had problems reading out some TaxAndAccountingGroup information from the GraphQL api. The reason we found out about this problem was when a join to include TaxAndAccountingGroup returned null when trying to list a product. Example Query: query GetTaxAndAccountGroups($cid: Int!) { useCompany(no : $cid) { taxAndAccountingGroup { totalCount items { joindown_TaxAndAccountingInformation_via_TaxAndAccGroup { totalCount items { joinup_TaxCode_via_TaxCodeSales { joinup_Vat { rate } } } } } } } } Response we get: { "data": { "useCompany": { "taxAndAccountingGroup": { "totalCount": 15, "items": null } } }, "extensions": { "vbnxt-trace-id": "000000000000000050a3746391f40f0b" } } The expected response we would have wanted is to be able to read out the vat rates of all the TaxAndAccountingGroups. We tried adding description to the query but it didn't help, it is still acting strange. Example 2: query GetTaxAndAccountGroups($cid: Int!) { useCompany(no : $cid) { taxAndAccountingGroup { totalCount items { description joindown_TaxAndAccountingInformation_via_TaxAndAccGroup { totalCount items { description joinup_TaxCode_via_TaxCodeSales { joinup_Vat { rate } } } } } } } } Response 2: { "data": { "useCompany": { "taxAndAccountingGroup": { "totalCount": 15, "items": [ { "description": "Råvarer over lager", "joindown_TaxAndAccountingInformation_via_TaxAndAccGroup": { "totalCount": 20, "items": [ { "description": "Råvarer over lager", "joinup_TaxCode_via_TaxCodeSales": null }, { "description": "Råvarer over lager", "joinup_TaxCode_via_TaxCodeSales": null } ] } }, // ... More items returned but they all look the same as the first, with no vat rate ] } } }, "extensions": { "vbnxt-trace-id": "0000000000000000350bd2bd24c7cf5c" } } If this is something we have done wrong, then please let me know. However, since this used to work, I feel like it's a bug?

filip-yabieenterprise · ‎19-01-2024

Hi! Since the maintenance yesterday, we have started getting "Error: Illegal query.Illegal query" for many of our queries. The same problem happened last week, but was resolved after it was posted about on https://status.visma.com. Example queries we're running that we're running into problems with: query ListOrders($cid: Int!, $filter: FilterExpression_Order!) { useCompany(no: $cid) { order( filter: $filter, sortOrder: {orderNo: DESC}) { totalCount items { orderNo yourReference customerOrSupplierOrderNo orgUnit1 orgUnit2 orgUnit3 orgUnit4 orgUnit5 orgUnit6 invoiceNo information1 information2 orderSumGrossInCurrency createdDate joinup_Associate_via_Customer { name } joindown_OrderLine_via_Order { items { description } } } } } } Variables: { "cid": xxxxxxx, "filter":{ "customerNo":{ "_eq":13 }, "invoiceNo":{ "_eq":"" }, "_and":[ { "information1":{ "_not_eq":"PRICEQUERY" } }, { "information1":{ "_not_like":"RECEIPT:%" } }, { "information3":{ "_not_like":"RECEIPT:%" } } ], "_or":[ { "orderType":{ "_eq":1 } }, { "orderType":{ "_eq":3 } } ] } } Example 2: query GetAllOrgUnit2($cid: Int!) { useCompany(no: $cid) { orgUnit2 { totalCount items { orgUnit2No customerNo information1 name group2 orgUnit1 orgUnit3 orgUnit4 orgUnit5 orgUnit6 orgUnit7 orgUnit8 orgUnit9 orgUnit10 orgUnit11 orgUnit12 actualStartDateAsDate actualEndDateAsDate } } } } Hopefully this is resolved and is not a recurring problem, because it is very inconvenient when trying to query info. Best regards, Filip

Problem reading TaxAndAccountingGroups

Illegal query after maintenance yesterday

Useful pages

About Visma

Contact us

Follow us