About omelhus

omelhus · ‎09-08-2022

Awesome! This took the schema from 26.68 MB to 1.23 MB!

omelhus · ‎09-08-2022

Awesome! Thanks!

omelhus · ‎30-06-2022

Thank you. I'll make sure you don't forget 😎

omelhus · ‎30-06-2022

You will always get a 200 response with GraphQL, unless your token is expired. Then it's 401. All errors are reported in the errors-property on the response object, and some libraries (like StrawberryShake) provide helpers like ".EnsureSuccessful()" to verify that the response is without errors. The drawback with this is that a query or mutation can be partially successful and return a warning, but you won't consider it an error.

omelhus · ‎27-06-2022

Perfect!

omelhus · ‎24-06-2022

Alright, I want to build business-to-business e-commerce solutions fetching product groups, products, prices, customers directly from VB NXT. We have this with Zpider and VB on-premise today, and it would be great if we could do the same with VB NXT, but in a Cloud fashion. This is also why it's important that the process to fetch prices is fast.

omelhus · ‎24-06-2022

Do you have the rate limiting documented anywhere? There's no headers advising on rate limiting. If you get the processing for customer product pricing there will be a business case for quota limit plans.

omelhus · ‎24-06-2022

Hey, Do you have a timeline for the webhooks support?

omelhus · ‎22-06-2022

Hey, Do you have a timeline for this?

omelhus · ‎08-06-2022

So it turns out that this was solvable with a processing called assignVoucherNumber all along. mutation AssignVoucherNumberAndFinishBatch($cid: Int!, $batchNo: Int!, $updateBatch: Boolean = false) { useCompany(no: $cid) { batch_processings { assignVoucherNumber(filter: { batchNo: { _eq: $batchNo } }) { succeeded } updateBatch(filter: { batchNo: { _eq: $batchNo } }) @include(if: $updateBatch) { succeeded voucherJournalNo } } } }

omelhus · ‎25-05-2022

The query to fetch available companies is the following: query GetAvailableCompanies { availableCompanies { totalCount items { name vismaNetCompanyId } } } Note that for the time being this only works in the user context (authorization code flow).

omelhus · ‎24-05-2022

In my opinion "SuggestValue" should be default for all properties where it's available, unless it's provided in the object. Does the model contain information about what fields have SuggestValue available?

omelhus · ‎23-05-2022

I think it would be better as a parameter for voucher_create instead of a property on Voucher_Insert. mutation create_voucher($cid: Int!, $bno: Int!, $cno: Int!, $valuedt: Int!) { useCompany(no: $cid) { voucher_create( values: { batchNo: $bno debitAccountNo: 1930 creditAccountNo: $cno customerNo: $cno amountDomestic: 100 valueDate: $valuedt } suggestValues: { voucherNo: { type: DEFAULT } } ) { affectedRows items { batchNo voucherNo voucherDate valueDate } } } } This way SuggestValueInInterval also could be implemented with a type: INTERVAL, start: N, end: N+X and thus fix my issues with creating customers and suppliers as well.

omelhus · ‎23-05-2022

Hey, How are we suppose to see what companies are accessible when we use client credentials? According to the docs availableCompanies aren't supposed to work with client credentials, but then the only way to see what companies are available is to authenticate using a user context to check what companies the client credentials have access to. https://docs.business.visma.net/docs/schema/queries/companies

omelhus · ‎23-05-2022

Yes, I'm using voucher_create to create the lines after I've created the batch. You have two options here. Either you can set SuggestValue for the columns by default and let the user override them afterwards, or you can take an argument with array of fields to suggest values for. If you first run SuggestValue and then SetIntergerValue afterwards it won't suggest a value but use the value that's set by SetIntegerValue. If you have the time we can setup a google meet and I can show you how this is a major issue.

omelhus · ‎18-05-2022

Hey, I've already discussed this with Øyvind and Suzdar, but it might be an issue worth tracking in the community. Current behavior When I create a batch I expect the voucher number (voucherNo) to be automatically set by the API, based on the provided voucherSeriesNo set on the batch. In the current implementation in the API the nextVoucherNo on voucherSeries won't even increment after I've created a new line using voucher_create. I can then continue to register multiple vouchers using the same voucherNo via the API. When I go to "Bilagsregistrering" in the UI and press + the number increases and I get an when I try to add a new voucher with the same number. Expected behavior TLDR: Work like VBS. When I create a batch I also provide the voucherSeriesNo the vouchers for that batch should automatically set the voucherNo for each line based on that series. This is exactly what happens if you use the sample from the SDK with VBS. Snippet from SDK

omelhus · ‎16-05-2022

Hey, I see that compression is still missing in the API. Especially the schema, which is 27MB, would benefit from adding compression. I'm guessing you're running the API on .NET 6, so adding compression should be straight forward. var builder = WebApplication.CreateBuilder(options); builder.Services.AddResponseCompression(options => { options.EnableForHttps = true; }); builder.Services.Configure<BrotliCompressionProviderOptions>(options => { options.Level = CompressionLevel.Fastest; }); And as the absolutely first middleware on the app builder var app = builder.Build(); // this must come before all the other middlewares app.UseResponseCompression();

omelhus · ‎13-05-2022

Hey, I've created a simple demo-application for .NET 6 using the StrawberryShake API Client. The library uses source generators in .net to generate a client with the required methods and types based on GraphQL files you add to the project. It's pretty cool. Check out https://github.com/omelhus/VBNXT.Console

omelhus · ‎13-05-2022

Hey, I have this query where I include StockBalance for the products. Without the joindown the query takes 2 seconds, but with it takes 14 seconds. Any chance you will be looking to improve this? Are you using dataloaders to avoid N+1 issues? query GetProduct($cid: Int!, $includeStock: Boolean!) { useCompany(no: $cid) { product { totalCount items { number: productNo description information1 information2 information3 information4 joinup_Unit { unit description quantityPerUnit } joinup_ProductCategory_via_ProductCategory1 { productCategoryNo description } joinup_ProductCategory_via_ProductCategory2 { productCategoryNo description } joindown_StockBalance_via_Product @include(if: $includeStock) { items { available physicalStockValueDomestic } } } } } }

omelhus · ‎13-05-2022

Hey, Will you consider supporting subscriptions over websockets in addition to webhooks? It would be really cool for user interactive apps. Cheers!

omelhus · ‎13-05-2022

I get the sentiment, but I don't see the issue with creating an "extensions" field on a table in order to achieve this. I would not consider this a processing, but additional computed information. The reason I want this on the product table is that I want to fetch the product information with the prices alongside it in one request. But your suggested approach might work if customer_price can take a filter of type FilterExpression_Product, and adhere to the same pagination cursor as Product. I can then send the same filter expression to both queries and stitch them afterwards.

omelhus · ‎06-05-2022

Hey, Figured this would be a good place to discuss customer specific prices in the API. It would be wonderful to have a field on product taking customerNo and quantity as parameters, and return customer specific prices.

omelhus · ‎01-12-2021

Thank you for clarifying. Can I trust the order of the lines? Will it be the same as I’ve posted?

omelhus · ‎01-12-2021

Hey, I'm creating new journal transaction entries with set lineNumbers, but Visma.net does not care about the numbers I send in. Is there any logic I'm missing here? This is the dto I'm sending, and the lineNumbers returned are 2 and 4. { "transactionDate": { "Value": "2021-12-01T00:00:00.000Z" }, "currencyId": { "Value": "NOK" }, "postPeriod": { "Value": "082021" }, "description": { "Value": "[abc123] TESTING" }, "journalTransactionLines": [ { "accountNumber": { "Value": "5000" }, "transactionDescription": { "Value": "TESTING" }, "creditAmountInCurrency": { "Value": 500.0 }, "lineNumber": { "Value": 1 }, "debitAmountInCurrency": { "Value": 0.0 }, "operation": "Insert" }, { "accountNumber": { "Value": "1920" }, "transactionDescription": { "Value": "TESTING" }, "debitAmountInCurrency": { "Value": 500.0 }, "lineNumber": { "Value": 2 }, "operation": "Insert" } ] }

omelhus · ‎22-10-2021

Perfect, thanks! This also makes more sense as I’m able to get any ledger/ documenttype from the endpoint.

omelhus · ‎14-10-2021

Thanks mate!

omelhus · ‎14-10-2021

Hey, I'm unable to upload attachments to journal transactions for batches with the module "ModuleIN". "ModuleGL" works just fine. I've tested in the web ui and I'm able to upload attachments perfectly fine. When I try to upload an attachment to a journalTransaction with "ModuleIN" i receive a status 400 with a json body stating { "message": "Journal transaction not found: NN" }. I have not tested with other modules.

omelhus · ‎23-02-2021

Hey, Would love it if you could add Warehouse to both the DTO and as a query filter on CustomerSalesPrice. I want to use this in conjunction with a priceCode-filter. Cheers!

omelhus · ‎28-01-2021

We also need to be able to filter based on attributes and/or customerrefno and paymentref.

omelhus · ‎20-10-2020

Hey, Can you provide an up-to-date list of endpoints that support/require the new pagination scheme? I could scour through the api, but I would prefer an official list from you. - Ole

Sv: Add compression to the responses

Re: VoucherNo should be provided by VB and not by ...

Sv: Timeline for webhooks

Sv: Errorhandling

Re: Getting availableCompanies with Client Credent...

Re: Quota on API

Re: Quota on API

Timeline for webhooks

Re: Getting availableCompanies with Client Credent...

Sv: VoucherNo should be provided by VB and not by ...

Sv: Access API by Codeflow - Company missing

Re: VoucherNo should be provided by VB and not by ...

Re: VoucherNo should be provided by VB and not by ...

Getting availableCompanies with Client Credentials

Re: VoucherNo should be provided by VB and not by ...

VoucherNo should be provided by VB and not by look...

Add compression to the responses

.NET 6 Demo Application

Performance issues with joins

GraphQL Subscriptions in addition to webhooks

Sv: Customer Specific Prices

Customer Specific Prices

Re: POST to JournalTransactionV2 does not care abo...

POST to JournalTransactionV2 does not care about l...

Re: Unable to upload journal transaction attachmen...

Re: Unable to upload journal transaction attachmen...

Unable to upload journal transaction attachments f...

Wish for improvement: Add warehouse to endpoint Cu...

Sv: POST/GET attributes to SalesOrder / SalesOrder...

List of paginated endpoints

Useful pages

About Visma

Contact us

Follow us