About omelhus

omelhus · ‎26-08-2022

You'll have to use a user context to fetch the correct customer number using the availableCustomers query, and then use the availableCompanies query to find what companies are available for that customer. Use https://business.visma.net/api/graphql-service. fragment VismaCompany on VbcCompany { name vismaNetCompanyId } query GetAvailableCompanies($customerNo: Long!) { availableCompanies(customerNo: $customerNo) { totalCount items { ...VismaCompany } } }

omelhus · ‎25-08-2022

Ok, I'll just have to add an additional setup layer then. I'm working on a bank-integration (like Autopay). It would be cool to just be able to give the client access, and off it goes.

omelhus · ‎25-08-2022

Ok, this was what I meant when I asked if it would "be the same method with the same signature and response", which this clearly isn't. As far as I can see this new functionality serves no purpose over what we had available before. Any plans for implementing availableCustomers for services?

omelhus · ‎25-08-2022

Ok, I managed to find the correct customer number using availableCustomers in a user context, but this is not available in the service context. I don't really understand what problem this is suppose to solve? I need to see what companies my service has access to (without brute-force), and this is still not possible.

omelhus · ‎25-08-2022

Cool, but I'm getting a new error now. { "errors": [ { "message": "Could not fetch the list of available companies. Customer number is mandatory." } ], "data": { "availableCompanies": null }, "extensions": { "vbnxt-trace-id": "000000000000000083b98bacc6b8f94b" } }

omelhus · ‎24-08-2022

It works on my machine (or phone, that is). Are you sure you are logged in with a user with access in vb nxt?

omelhus · ‎24-08-2022

Hey, What is triggering this error from the API? I get that it's the "Same request made too many times", but what is too many times and what is the timespan?

omelhus · ‎23-08-2022

Hey! Will this be released this Thursday?

omelhus · ‎12-08-2022

Just to verify. It will be the same method with the same signature and response that will be used here? Just so I know that I can mock this for a couple of weeks.

omelhus · ‎09-08-2022

Is this in prod now?

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!

Sv: Service integration returns 401 in postman

Re: Getting availableCompanies with Client Credent...

Re: Getting availableCompanies with Client Credent...

Re: Getting availableCompanies with Client Credent...

Re: Getting availableCompanies with Client Credent...

Sv: QraphiQL not working

Same request made too many times

Re: Getting availableCompanies with Client Credent...

Re: Getting availableCompanies with Client Credent...

Re: Getting availableCompanies with Client Credent...

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

Useful pages

About Visma

Contact us

Follow us