About omelhus

omelhus · ‎04-06-2024

Hey, In the UI I have the option to "insert line above" in the order line view. This will insert a line with an incremented lineNo, but a sortSequenceNo making it go to the line above. Would it be possible to open up for this in the API as well? Cheers

omelhus · ‎31-05-2024

This makes sense to me.

omelhus · ‎30-05-2024

Good! Visma added some more logging after I encountered this, so now maybe they’ll be able to figure it out. The update is successful even though the response says otherwise.

omelhus · ‎30-05-2024

Please include the visma trace id for this response, as this is bug that I haven't been able to reproduce, but have encountered myself. This is probably an issue somewhere between vbus an graphql, and must be investigated by Visma.

omelhus · ‎30-05-2024

I think the bigger issue is that this has been changed without any notice, no release notes, no heads up for integrations to change. We only notice when the integrations blow up after a release has been done, without notice.

omelhus · ‎30-05-2024

Hey, This is probably in regards to Visma moving away from VBS - a change we were suppose to not notice at all. Your mutation is updating with empty values. If you want to maybe update some fields, you should have the whole entity as a parameter instead. At least that's your workaround until Visma (maybe) fixes this. mutation UpdateCompany($companyID: Int!, $customerNo: Int!, $entity: Associate_Input!) { useCompany(no: $companyID) { associate_update(filter: {customerNo: {_eq: $customerNo}}, value: $entity) { affectedRows } } } { "companyID" : 4000000, "customerNo": 11000, "entity": { "phone": "94000000" } } The drawback here is that if you are using dotnet you need to make sure that your serializer is set to not include NULL-values, or you'll be in for a surprise with suggested values.

omelhus · ‎29-05-2024

The sample code I presented at ISV Partner day today is available at https://git.new/bnxt-hooks. Install the Connect Application Access window from NXT Ninja to start setting up webhooks. But webhooks is not working at the moment, unfortunately, so no need to start playing with this yet. I'll update this thread when I see that it's up and running again.

omelhus · ‎28-05-2024

A sample project processing webhooks will be available tomorrow afternoon 🙂 I'm not sure when Visma will release the updated docs, but I'd guess it'll be available after the presentation at Visma tomorrow.

omelhus · ‎27-05-2024

Hey, I just saw that availableCompanies now returns all available companies across all customers in user context as well. Good job! query availableCompanies { availableCompanies { items { name vismaNetCompanyId vismaNetCustomerId } } }

omelhus · ‎24-05-2024

Hey Sander, You should use a service application instead of a web-application for this use case. Access to your app will be granted through the app store, and you won't have this problem. This will let you authenticate using client_credentials with a tenant id instead.

omelhus · ‎24-05-2024

It would be so helpful if we could add a scope like "company:12345", and then the only company accessible from the token would be 12345. I need this primarily for the graphql-service endpoint.

omelhus · ‎24-05-2024

I'm getting this error when updating orderlines in a batch-request. It's only one item in the batch that fails. The trace id is 0000000000000000f9fa0c783b96d593. Can you have a look?

omelhus · ‎14-05-2024

Hei! Savner du import-filter for Business NXT? Jeg har laget https://importfilter.no/, som lar deg importere CSV, Excel og Visma Business-import-filer til Business NXT. Du lager enkelt en ny import ved å laste opp en eksempel-fil, og koble kolonner fra filen til felter i tabellene i Business NXT. - Ole

omelhus · ‎26-04-2024

Hey, So we already kind of have OnConflictDoNothing, but it would be so cool if we could have the equivalent of OnConflictDoUpdate as well. I imagine this would be an additional property on _create, where you could select what target-fields should trigger an update and what fields that should be updated from the values.

omelhus · ‎26-04-2024

This was implemeted a while ago. Can also be combined with @export to fetch keys from one table and look them up in another.

omelhus · ‎12-04-2024

1 mill transaksjoner er fryktelig mye, så det vil nok ta litt tid. I en av spørringene som kjører i dag ser jeg at vi henter 28k transaksjoner på ca. 35 sekunder. Med litt serviett-matematikk vil 1 mill transaksjoner da ta over 20 minutter, så det er ikke sikkert det passer. Men det avhenger mye av dataene som skal hentes og om det må joines mot andre tabeller. Joins koster gjerne en del i tid. Spørringen jeg refererer til deles opp med en pagesize på 1500, som så transformeres og strømmes ned til Power Query. 1500 var der vi fant sweet-spoten for hastighet i den casen. Vi kan teoretisk hente 5000 records av gangen, litt avhengig av tabellen, så det kan arte seg annerledes i din use-case. Om PowerPivot har mulighet til å lese csv eller json-data direkte fra et API så trenger du ikke gå via Excel. Du kan få ut en URL som returnerer dataene i rapporten direkte. Det aller beste er å få apiet til å gruppere og summer dataene man ønsker å presentere, slik at hovedtyngden av jobben kan gjøres før vi får data i retur. NXT Report kan ta parametere til spørringene, slik at man f.eks. kan styre spørringene på dato.

omelhus · ‎12-04-2024

Hei, Det er en god stund siden dette spørsmålet ble stilt, men nå er det kommet en ny mulighet for rapportering i Business NXT. Med NXT Report kan du lage GraphQL-spørringer mot APIet og kjøre den samme spørringen mot flere selskap. Det er på tilgangsnøkkelen du styrer hvilket selskap du ønsker at data skal hentes fra. Om du ikke er helt stø på GraphQL-spørringer kan du få hjelp av en AI-assistent, som genererer spørringer basert på dine ønsker. Du kan også få konsulent-hjelp til å skrive spørringene, om det er ønskelig. Dette blir da en levende kobling mot Business NXT, og ikke en synkronisering til en ekstern database. Se demonstrasjon i video under. Kontakt meg på ole@on-it.no eller +4747464945 ved spørsmål, eller bare test ut løsningen på https://nxt.report 🙂

omelhus · ‎12-04-2024

Hei, Med LETT for Business NXT har jeg laget en bookmarklet som lar deg åpne en dokumentviser i et nytt vindu. Den vil åpne ordren du har markert og la deg vise vedleggene og sende dem på epost, så lenge ordrenummer er synlig i tabellen. Du installerer bookmarklet fra https://lett.as/bookmarklet. Vis og send dokumenter med LETT for Business NXT Om du ønsker mer informasjon kan du sende meg en epost på ole@on-it.no, eller ringe meg på 47464945.

omelhus · ‎11-04-2024

Introducing the Layout Library for Business NXT! Visibility of shared layouts have three levels. Public are listed and searchable for everyone, unlisted are not searchable, but you can send your customers a direct link to the layout and they will be able to install it. Private are private. Only you can access those. You share a new layout by clicking the "Upload layout" button and selecting the layout you want to share. The default visibility is Private, and you change that by pressing the edit button. https://nxt.ninja/library Layout Library for BNXT

omelhus · ‎05-04-2024

That field is read only. You can see what fields are writable and not at https://model.vbnxt.rocks/UpdatedVoucher

omelhus · ‎05-04-2024

I've started the work on a "Layout Library" where you'll be able to share layouts publicly or privately as needed. I'll let you know when I have more updates.

omelhus · ‎05-04-2024

My bad! (like there's anybody else to blame) I had renamed a route, and forgotten about it in a fairly important place. It's fixed now - just refresh the site.

omelhus · ‎04-04-2024

Yeah, totally agree. My plan is to implement cross-account sharing of both layouts and packages/folders of layouts. This has just been a weekend-project of the "I wonder if this is possible"-kind for now, so I can't promise any dates for when this will become available. Contact me on ole@on-it.no if Pector might be interested in funding the development of said features. I'd love to be able to set aside time to do it. This goes for any other ISV that reads this as well 🙂

omelhus · ‎03-04-2024

I've created a tool for this over at https://nxt.ninja/

omelhus · ‎11-03-2024

Hey, Seems like distinct values are missing from the new aggregates method.

omelhus · ‎11-03-2024

I have not had any issues since that. Thank you!

omelhus · ‎10-03-2024

Hey, Getting sporadic errors like this. Often the query works, but way too often it fails with the following error. If I retry a few times it works again. Vbnxt-trace-id: '0000000000000000f67c369be95bcc41' ClientError: Already closed: The AMQP operation was interrupted: AMQP close-reason, initiated by Library, code=541, text='Unexpected Exception', classId=0, methodId=0, cause=System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown. at System.GC.AllocateNewArray(IntPtr typeHandle, Int32 length, GC_ALLOC_FLAGS flags) at System.GC.<AllocateUninitializedArray>g__AllocateNewUninitializedArray|66_0[T](Int32 length, Boolean pinned) at System.Buffers.TlsOverPerCoreLockedStacksArrayPool`1.Rent(Int32 minimumLength) at RabbitMQ.Client.Impl.CommandAssembler.ParseHeaderFrame(InboundFrame& frame) at RabbitMQ.Client.Impl.CommandAssembler.HandleFrame(InboundFrame& frame) at RabbitMQ.Client.Impl.Session.HandleFrame(InboundFrame& frame) at RabbitMQ.Client.Framing.Impl.Connection.MainLoopIteration() at RabbitMQ.Client.Framing.Impl.Connection.MainLoop()

omelhus · ‎07-03-2024

It would be helpful if the resolution could be posted here as well.

omelhus · ‎07-03-2024

Hey, I'm fetching all available companies for all customers in a single query, but for users with access to heaps of customers this is taking a lot of time. It looks like that this query executes in sequence instead of parallel. Any suggestion on how I can fix this? It does seem like that executing it using batchRequest has the same issues. In this sample I'm fetching the same over and over, but in my actual use case I'm fetching companies for all available customers. For each additional availableCompanies I add to the query, it adds around 100ms to the response time. query availableCompanies { availableCompanies { items { vismaNetCompanyId name vismaNetCustomerId organizationNo } } a_2: availableCompanies { items { vismaNetCompanyId name vismaNetCustomerId organizationNo } } a_3: availableCompanies { items { vismaNetCompanyId name vismaNetCustomerId organizationNo } } a_4: availableCompanies { items { vismaNetCompanyId name vismaNetCustomerId organizationNo } } }

omelhus · ‎04-03-2024

Hey, This would be incredible useful. Please see if there's any chance to implement it.

Setting sortSequenceNo on orderLine

Re: Fields are cleared on update mutation

Sv: Fields are cleared on update mutation

Sv: Fields are cleared on update mutation

Re: Fields are cleared on update mutation

Sv: Fields are cleared on update mutation

Sv: Webhooks docs?

Sv: Webhooks docs?

availableCompanies now returns all available compa...

Re: Getting access_token returns invalid_grant aft...

Use scopes in Visma Connect to limit accessible co...

Error: The request could not be executed: unable t...

Import-filter for Business NXT

Upsert - OnConflictDoUpdate

Sv: Add _in operator to filters - Status endret ti...

Sv: Visma Nxt og data tilgjengelig i PowerPivot - ...

Sv: Visma Nxt og data tilgjengelig i PowerPivot - ...

Sv: Dokumentviser Visma NXT

Re: Tool for export and import layouts

Sv: using updateVoucher_Update

Re: Tool for export and import layouts

Re: Tool for export and import layouts

Re: Tool for export and import layouts

Sv: Tool for export and import layouts

Distinct with the new aggregate

Sv: System.OutOfMemoryException when executing que...

System.OutOfMemoryException when executing queries...

Sv: Fetching PDF attachments associated with trans...

query does not execute in parallel

Sv: Filter on values from joinup

Useful pages

About Visma

Contact us

Follow us