About omelhus

omelhus · ‎01-12-2023

I second this. All tables where Chtmms (ChangeTimeInMs) is present should use that for millisecond precision on time, whilst the others can fall back to chtm (ChangedTime).

omelhus · ‎29-11-2023

So you are saying that the functionality with suggesting values for entities using null is moot when you are using variables? When I create or update entities I almost exclusively use variables for inputs. Using parameters for all just doesn't make any sense. Please disable the suggest-functionality for entities in a variable, that is not enabled by suggest: { field: true }.

omelhus · ‎27-11-2023

Yeah, but this still skips the reason for the null-debacle. It's because you need to set fields in a set order, like defining currency before you set an exchange rate. You code should then be something like: var orderInputList = new List<Order_Input> { new Order_Input { OrderNo = null, OrderType = 1, CustomerNo = 123456, OrderDateAsDate = new DateOnly(2023, 12, 19) } }; var insertMutation = vbNxtClient.UseCompanyMutationFor<Order>(4816282) .Insert(orderInputList) .Select(x => new { x.OrderNo, x.OrderStatus1Flags }) .Suggest(x => new {x.OrderNo}) .CreateMutation(); But still I think that Visma should support generic clients like StrawberryShake, and not be tied to a custom client. I like your fluent approach though. Managed to get it up on github yet?

omelhus · ‎27-11-2023

Using this method I'm either unable to suggest values at all, or I have to suggest values for all fields. Please only suggest values if the field is included in suggest:. This is making it really troublesome to use input variables with .NET applications. Javascript has the notion of null or undefined, where undefined will be omitted, and null values included, but .NET doesn't. It's all or nothing.

omelhus · ‎24-11-2023

Permalinks to an order. When you open an order i BNXT the URL is something like https://business.visma.net/305/50038, so you can't share that url. Being able to deeplink to an order would be cool, but that would be more of a frontend BNXT thing, not api. If you open an order i LETT for Business NXT you get an url like https://lett.as/3757761/order/2619.

omelhus · ‎24-11-2023

I'd like us to do suggest: { voucherNo: true } like before, and rather let a voucherNo: null in the entity define the order of the properties. If I set the json-serializer to omit null values, I'm no longer able to suggest values at all.

omelhus · ‎24-11-2023

I'm still really unhappy with this doing suggest without setting it in suggest:. It's not clear (unless you read the docs, of course) that this will happen, but by using the suggest:-functionality it's really clear what the intent is.

omelhus · ‎24-11-2023

Hey @Marius Bancila, If i run a create-mutation with null-values for some properties, will it suggest values for those properties, even though I haven't set suggest for them? If so, this is a major issue. Both (System.Text.Json and NewtonSoft) will serialize all unset properties of a class to null, so then the suggest-value-logic will run for all properties where a value is not set. It's fundamental that you don't run suggest on a field unless suggest is provided as a parameter to the create-mutation.

omelhus · ‎31-10-2023

https://community.visma.com/t5/Forum-in-Developers-Visma-net/Set-Sales-Category-on-Inventory-via-API/m-p/315034 I need this.

omelhus · ‎26-10-2023

I second this frustration.

omelhus · ‎19-10-2023

🥳

omelhus · ‎19-10-2023

No news during happy hour, but last I heard it’s pushed to Q1.

omelhus · ‎16-10-2023

Batch does not give you a transaction and the parts run sequentially on the server anyway so there is not much performance difference. Parallel requests are always faster Thanks for the insights. It's completely useless then. I'll just send requests in parallell - that works just fine.

omelhus · ‎16-10-2023

Alright, thank you for taking time to do the extra tests. Are you using postman, insomnia, or something else? I'm getting the exact same error from both node and httpie, so I'm at a loss at what can be wrong. Looks like I won't be using $batch in production either. Bummer.

omelhus · ‎16-10-2023

Thank you for testing. I cannot believe that compression is still an issue after almost a year. Are you using user context or m2m? I'm testing with a token generated with a tenant id, and it is not working. I can't see that I've enabled compression anywhere in this request.

omelhus · ‎16-10-2023

Request POST /API/controller/api/v1/$batch HTTP/1.1 Accept: application/json Authorization: Bearer ... Content-Length: 345 Content-Type: multipart/mixed; boundary=a49c65ed-9964-4c48-92b0-99754c008590 Host: integration.visma.net User-Agent: HTTPie --a49c65ed-9964-4c48-92b0-99754c008590 Content-Type: application/http; msgtype=request GET /api/v1/salesordertype/SO HTTP/1.1 Host: integration.visma.net --a49c65ed-9964-4c48-92b0-99754c008590 Content-Type: application/http; msgtype=request GET /api/v1/organization HTTP/1.1 Host: integration.visma.net --a49c65ed-9964-4c48-92b0-99754c008590-- Response HTTP/1.1 500 Internal Server Error Cache-Control: no-cache,no-cache Connection: close Content-Type: application/json; charset=utf-8 Date: Mon, 16 Oct 2023 08:29:41 GMT Expires: -1 Feature-Policy: geolocation 'none'; vr 'none'; payment 'none'; midi 'none'; microphone 'none'; fullscreen 'none'; encrypted-media 'none'; camera 'none'; autoplay 'none'; Ipp-Request-Id: 3cd9b6e5-b720-43cd-8983-069b9d98cb13 Pragma: no-cache Referrer-Policy: origin-when-cross-origin Server: Nginx Set-Cookie: .ASPXROLES=YyiGvqobVOCIWgmoyV1Rww_q782ug9EidG_2W9yAmhCNWSirt3d5uUnxz27HFCpk_QRQz3w_0YQSqn82SVdFSgqqzwMQu7Xw0-SHaJrWMagz8qzVI9j-yn2Ffnzww2H-OMFzdnA_0Jb9c8Ihz_F1vQxfboL7K5IbQGl7G5XwtA9K_QDbrqD3bvIxcsUs2EQjKMUAdPoGw81ueAFF-M7JRZtsCErvDO4Tjo8nMvHOcWGsX35-Qe15vPowBAt2VUG8nMM_ey_uXkAClU9mz1M5RraV_wGeCgfT34YjYInwAvHwDZFtsbgt4oOu3lE9sVolxpkcxy8iBnjaFZSpDN85yk9g6Lw26o-KjQDLYM_ASWj0Eb95wHBVTyYytKLTXy1o4z0FxxvJ3dfl8qn4FO-85j4XIv34LINJC3G8a_s3XPKSiaIydqyNcZZdvwq5-pRVPc5jMFrHbTbrn1V2isLBCsybiws-1iOIFhUKRo6VnoB8wOaz0; path=/; secure; HttpOnly Strict-Transport-Security: max-age=31536000; includeSubDomains, max-age=31536000; includeSubDomains Transfer-Encoding: chunked X-Content-Type-Options: application/json X-Handled-By: Visma-PX.Export/AuthenticationManagerModule X-Xss-Protection: 1;mode=block {"message":"An error has occurred.","exceptionMessage":"Error parsing HTTP message header byte 5 of message System.Byte[].","exceptionType":"System.InvalidOperationException","stackTrace":" at System.Net.Http.HttpContentMessageExtensions.<ReadAsHttpRequestMessageAsyncCore>d__12.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at System.Web.Http.Batch.DefaultHttpBatchHandler.<ParseBatchRequestsAsync>d__14.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at System.Web.Http.Batch.DefaultHttpBatchHandler.<ProcessBatchAsync>d__12.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at System.Web.Http.Batch.HttpBatchHandler.<SendAsync>d__12.MoveNext()"}

omelhus · ‎15-10-2023

As I saw during the happy hour, this is in the works. Thank you, I'm looking forward to that. 🙂

omelhus · ‎15-10-2023

Bummer. Thanks for the reply. Can you see if you can nudge the team for a timeline? Would be handy to not need import scenario for this.

omelhus · ‎14-10-2023

Hey, How can I update/set supplier prices using the API? Screen id AP202000. - Ole

omelhus · ‎09-10-2023

Would be cool if you made an @exportArray directive that aggregated the values into a distinct array and we then could to { textNo: { _in: $array} }. Or even made @export able to see if the export parameter is an array it pushes the values instead of setting them. That would solve all of these cases.

omelhus · ‎06-10-2023

No, but you can use batch queries to fetch companyNo from companyInformation in parallel, so you’ll practically only need two queries to fetch the information for all companies.

omelhus · ‎30-09-2023

This is the forum for Business NXT and not on-premise. If you need a graphql api for on-premise, have a look at https://apps.visma.com/NO/app/isv_onit_graphql_service. Images, documents and memo file content are all available through that api.

omelhus · ‎27-09-2023

You can use https://model.vbnxt.rocks/ to generate the GraphQL query field selection that alias to the corresponding SQL name. Just hold shift or ctrl and press the "copy" button and it will be copied to your clipboard. This will result in the following being saved to your clipboard: OrdDocNo: orderDocumentNo DocTp: documentType DocDt: documentDate FormNo: formNo LayNo: layoutNo PgElNo: pageElementNo OrdNo: orderNo ... and 200+ more lines.

omelhus · ‎26-09-2023

But this is solved by using the suggest-feature. I don't think the nextVoucherNo updates until you release the voucher.

omelhus · ‎26-09-2023

You'll run into concurrency issues if you don't use the suggestion-approach.

omelhus · ‎26-09-2023

You can't. Create the first line first, return the voucherNo and set the voucherno on the rest of the lines before you create them. If you are able to find a better way to do this I'll be grateful, but this is the only way I've been able to do this.

omelhus · ‎25-09-2023

The example is wrong. You need to set voucherNo to null and it will be suggested. Not sure if you need to add it to the suggest parameter still. I guess @Marius Bancila should update the example.

omelhus · ‎18-09-2023

Send the whole object as a variable. The only way. mutation CreateOrderLines($input: [OrderLine_Input]!) { useCompany(no: 4655191) { orderLine_create(values: $input) { affectedRows items { orderNo lineNo description changedByUser changedDateTime } } } } { "input": [ { "orderNo": 1736, "lineNo": 1, "productNo": "TEQ1001", "processingMethod2": 81920, "processingMethod1": 0, "processingMethod4": 262144, "quantity": 1, "priceInCurrency": 9999 }, { "orderNo": 1736, "lineNo": 2, "productNo": "TEQ1", "structureLevel": 1, "processingMethod2": 16385, "description": "Eldøyane Camp Aker, Eldøyane, Stord, Norge-\"Busshålo\", Stord, Norge", "processingMethod1": 4096, "quantity": 1, "orgUnit1": 3131, "transactionInformation1": "TB-032193-S01-N002", "transactionInformation2": "STD", "structureHeadLineNo": 1, "priceInCurrency": 9999 }, { "orderNo": 1736, "lineNo": 3, "productNo": "TEQTurInf", "processingMethod2": 422330368, "memoNo": 1538 } ] }

omelhus · ‎18-09-2023

What I want is for the api to have a different level of access than a user. When it’s a user context it’s it should be like today, but when we are using the service client ids we should have the same access as the edi import.

omelhus · ‎18-09-2023

export enum OrderTypeEnum { NormalOrder = 1, DirectOrder = 2, CashOrder = 3, RealisedOrder = 4, QuotationOrder = 5, UnprocessedOrder = 6, AdvanceOrder = 7, BudgetOrder = 8, CreditCardOrder = 9, } export enum TransactionTypeEnum { Sales = 1, Hire = 2, Loan = 3, Loss = 4, FurtherProcessing = 5, Purchase = 6, Production = 7, StockTransfer = 8, }

Sv: Invoice changedDateTime not showing seconds

Sv: Problem with price when sending order lines as...

Re: Suggest values without suggest: ?

Re: Suggest values without suggest: ?

Re: URL for specific resource in GUI

Re: Suggest values without suggest: ?

Re: Suggest values without suggest: ?

Suggest values without suggest: ?

Set sales category on inventory via api

Sv: Field origin ids not defined …

Re: Join in text from Text table in queries

Re: Webhooks

Re: Exception when using $batch. "Error parsing HT...

Re: Exception when using $batch. "Error parsing HT...

Re: Exception when using $batch. "Error parsing HT...

Exception when using $batch. "Error parsing HTTP m...

Re: Join in text from Text table in queries

Re: Update supplier prices

Update supplier prices

Re: Join in text from Text table in queries

Sv: Organization number in availableCompanies

Sv: Getting Product Info via SQL

Sv: Visma XML document format

Sv: VoucherNo for each batch

Sv: VoucherNo for each batch

Sv: VoucherNo for each batch

Sv: VoucherNo for each batch

Sv: Orderline - description "å"

Re: Origin of Batch

Sv: How do we get order type and transaction type ...

Useful pages

About Visma

Contact us

Follow us