Do you have the equivalent query to get it on-premise? ... View more

The limitation is enforced in the reverse proxy. ... View more

Should we have a way to report these kind of core issues? Are these a better fit for the main Business forum? I think we should have a way to report and follow up on core issues as well. ... View more

I'm still getting an error when I try to suggest a textNo.   { "errors": [ { "message": "A record with the same primary key already exists.", "path": [ "useCompany", "text_create", "values/0" ], "extensions": { "data": { "status": 3 } } } ], "data": { "useCompany": { "text_create": { "items": null } } }, "extensions": { "vbnxt-trace-id": "000000000000000001d1d2d89e53ddfe" } } ... View more

I doubt that 1 is the correct company number. Please have a look at https://docs.business.visma.net/docs/schema/queries/companies ... View more

The schema type of textNo is Long!, so null is not allowed.   { "errors": [ { "message": "Argument 'values' has invalid value. In field 'textNo': [Expected 'Long!', found null.]", "locations": [ { "line": 26, "column": 7 } ], "extensions": { "code": "ARGUMENTS_OF_CORRECT_TYPE", "codes": [ "ARGUMENTS_OF_CORRECT_TYPE" ], "number": "5.6.1" } } ] } ... View more

  mutation createText($cid: Int, $textType: Long!, $textNo: Long!, $text: String!, $language: Int! = 1) { useCompany(no: $cid) { text_create( values: {textType: $textType, languageNo: $language, text: $text, textNo: $textNo} ) { items { textNo } } } }    Unfortunately suggest for textNo does not work in this mutation. Maybe it should though, @Marius Bancila? ... View more

Did a quick test appending .pdf to an xml-file and it did not work, unfortunately. ... View more

I doubt it.   The only file type you are allowed to upload in the UI is pdf, so I expect the same constraints are applied to the API.   I don't think there's any integrity check though, so you could probably just append .pdf to the file name and live happily ever after. ... View more

Thank you for your reply.   My comment was not related to the absolute best performance, but a more performant way to fetch data than going through VBS for every request. I think wiring up all the queries and joins manually for a complex system as VB will take so much time that the API is obsolete before it's done, and with the performance in existing ORMs I see no reason to invent the wheel again.   I'm mentioning specifically EF Core because that's what I have experience with and have been tinkering with using the Business data model, scaffolding and GraphQL. Dapper or other ORMs might have scaffolding solutions, but I know nothing about that.   I think the API would benefit tremendously by skipping the VBS for queries that don't access calculated fields. This would probably also lower the compute power required to run the API-solution, as much of the query can be off-loaded to the SQL-server(s). Computed fields can be fetched using a data loader using primary keys. I'm seeing a 10x improvement in query times using the SQL+dataloader approach over the implementation in nxt, using approximately the same dataset.   I'm happy to demonstrate this over teams. ... View more

Would be cool if batch operations were executed in parallel, since they won’t share any data between them. And if you need something executed sequentially you could use the “inline batch”. ... View more

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. ... View more

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.         ... View more

Awesome! ... View more

query WithVatRate($cid: Int!, $accountSet: Int = 0) { useCompany(no: $cid) { companyInformation { items { defaultAccountSet @export(as: "accountSet") } } product( first: 50 after: "" filter: {_and: [{changedDateTime: {_gte: "2023-04-20T12:12:00"}}]} ) { items { productNo description productType1 productPriceGroup1 changedDateAsDate changedTimeAsTime productPriceGroup2 quantityPerUnit productCategoryNo1 productCategoryNo2 taxAndAccountingGroup: joinup_TaxAndAccountingGroup_via_TaxAndAccGroup { taxAndAccountingInformation: joindown_TaxAndAccountingInformation_via_TaxAndAccGroup( filter: {accountSet: {_eq: $accountSet}} ) { items { taxCode: joinup_TaxCode_via_TaxCodeSales { vat: joinup_Vat { rate } } } } } joinup_ProductCategory_via_ProductCategory1 { productCategoryNo description } } totalCount pageInfo { hasNextPage hasPreviousPage startCursor endCursor } } } } ... View more

if it’s only vat rate you are after you can find it in vat. Order by after date and filter for valid ones. If afterdate is set and passed use newrate, else rate. useCompany(no: 123){ vat { vatNo # VatNo rate # Rt fromDate # AfterDt newRate # NewRt } }   If you need customer specific prices, or vat rate for that matter, I’ve created an extension on for the bnxt api that adds customerPrice as a property on product. You can test the extension by swapping the endpoint url to https://api.vbnxt.rocks/graphql, and if you grant isv_onit_vbnxt_service access to your bnxt client you will get customer prices available within 5 minutes. ... View more

I’m on holiday and on my phone, so bear with me here.   Generate a query like this. That’s what I do on https://lett.as. I update the order, create, update and delete lines in one single query. Create order requires two queries. mutation Many($cid: Int!, $filter1: FilterExpression_OrderLine, $update1: OrderLine_Input, $filter2: FilterExpression_OrderLine, $update2: OrderLine_Input){   update1: orderLine_update(filter: $filter1, value: $update1) { affectedRows } update2: orderLine_update(filter: $filter2, value: $update2) { affectedRows }   } ... View more

Inline the mutations and send the updates as parameters. Works like a charm for me. ... View more

Thank you for adding it to the backlog. I'm already doing inline batching with lots of variables, but with "real" batching we'd get individual error handling for each operation. ... View more

You can also do Number(base64decode(endCursor)) == totalCount, but I know a lead dev that won't be too happy about that.   I'm doing it though. ... View more

I see this was implemented in yesterdays release. Thank you!   Now please do @export and if the parameter it exports to is an array, append the values to the array as a HashSet.   query Currency($cid: Int!, $currencies: [Int!]) { useCompany(no: $cid) { associate(filter: {currencyNo: {_in: [46, 47]}}) { items { associateNo name customerNo currencyNo @export(as: "currencies") } } vars: currency(filter: {currencyNo: {_in: $currencies}}) { items { currencyNo isoCode } } currency(filter: {currencyNo: {_in: [46, 47]}}) { items { currencyNo isoCode } } } }   ... View more