Re: Timeouts from the InventoryTransfer endpoint

Kjetil Ringstad · ‎19-08-2021

Hi

The last few days inventory transfers through /controller/api/v1/inventoryTransfer results in timeout error messages returned from the API gateway.

The request itself does not time out, but the timeout message is being returned.

Can you please look into it?

Example, company id 2693113 , today 19.08.2021 10:16:35 , payload:

{"warehouseId":{"value":"1"},"toWarehouseId":{"value":"1"},"transferLines":[{"toLocationId":{"value":"GA-16-05"},"operation": "Insert","inventoryNumber":{"value":"23420"},"locationId":{"value":"VM-00-00"},"quantity":{"value": 11},"uom":{"value":"STK"}}],"hold":{"value":false},"externalReference":{"value":""},"description":{"value":""}}

AliMKhan · ‎08-06-2023

Hello.

We have done some major performance improvements on GET InventoryTransfer endpoint in Tuesdays version.

https://community.visma.com/t5/News-in-Developers-Visma-net/Release-Notes-Visma-Net-API-9-50-0-06-06...

It should fetch bigger datasets much faster.

Please provide feedback on the improvements.

JacobIpsen · ‎16-12-2022

Hey Magnus
Thanks again for the debug session today, As promised i just bump this tickes as it seems like this issue is still ongoing

Some timing on responce time, our client are running 20 warehouses doing 600-700 trsafares weekly
for one day it will take aroung 30-40 sec to retrive data from this endpoint
https://integration.visma.net/API/controller/api/v1/inventoryTransfer?status=Balanced&lastModifiedDa... 08:00:27.621&lastModifiedDateTimeCondition=%3E

If i draw for a longer period lets sat 14 days - 30 dags
the request time ends up around 1min - 1.5min (this is oretty consistent)

It seems like there is still somthing that can be done for performence in this endpoint 🙂

Jacob Ipsen
CINO - FlexPOS

AliMKhan · ‎24-04-2023

Hello.

You now have the possibility to filter on warehouse on the inventorytransfer endpoint:

Release notes 9.41
This should help on getting more in-point data in your use case.
We are also working on improving this endpoint on a general level and the improvement will come in a couple of weeks.

JacobIpsen · ‎20-06-2023

Hey AliMKhan

So i played around with the warehouse and toWarehouse filter options
it almost seems like u made the to depended of eachother.
so u cannot use toWarehouse alone(without warehouse)

So for the use case we have this will not work.
here is why.
Whe warehouse is stores, and we created a simpel tool to make it simpel for store workers to find inmound
InventoryTransfares to thair store (toWarehouse) but as from can ba another store or a central warehouse , we would have to create 20 calls for this endpoint to check all "FromStores(Warehouse)"

Using the toWarehouse alone have no impact(before adding warehouse)

Jacob Ipsen
CINO - FlexPOS

JacobIpsen · ‎20-06-2023

Super
where do i find the dokumenationtion on how ?
(seems like the swagger is down)

Jacob Ipsen
CINO - FlexPOS

AliMKhan · ‎28-06-2023

You can find the swagger documentation here:
https://integration.visma.net/API-index/

JacobIpsen · ‎29-06-2023

i Got it working my local cashe where playing a trick on me Ctrl+Shift+R got it working.
have u seem my question regarding findings in regards to warehouse and toWarehouse filtes ?
it seems like toWarehouse filter only works if used WITH warehouse and not alone

is this intended ?

Jacob Ipsen
CINO - FlexPOS

schimmel-hsleiden · ‎14-09-2021

Hello Magnus,

Last night we have set our import time of Visma that started at 6:30 back to 1:20 midnight (CET), and now we got a timeout again. It looks like the extra API server performance is not enough at this time of the night.

We got a 504 response at 01:56:44 and the import stopped.

This is our API log that started at 1:20

09/14/2021, 01:55:45 AM	GET	https://api.hsleiden.nl/provider/visma/visma_stichting_hsl/v1/customerinvoice?pageSize=1000&pageNumber=2	200	200	619 B	3.26 MB	8.92 s	8.89 s	195.169.84.220
09/14/2021, 01:55:54 AM	GET	https://api.hsleiden.nl/provider/visma/visma_stichting_hsl/v1/customerinvoice?pageSize=1000&pageNumber=3	200	200	619 B	3.26 MB	8.61 s	8.59 s	195.169.84.220
09/14/2021, 01:56:03 AM	GET	https://api.hsleiden.nl/provider/visma/visma_stichting_hsl/v1/customerinvoice?pageSize=1000&pageNumber=4	200	200	619 B	3.26 MB	8.74 s	8.72 s	195.169.84.220
09/14/2021, 01:56:12 AM	GET	https://api.hsleiden.nl/provider/visma/visma_stichting_hsl/v1/customerinvoice?pageSize=1000&pageNumber=5	200	200	619 B	3.26 MB	12.61 s	12.58 s	195.169.84.220
09/14/2021, 01:56:24 AM	GET	https://api.hsleiden.nl/provider/visma/visma_stichting_hsl/v1/customerinvoice?pageSize=1000&pageNumber=6	200	200	619 B	3.69 MB	12.06 s	12.04 s	195.169.84.220
09/14/2021, 01:56:37 AM	GET	https://api.hsleiden.nl/provider/visma/visma_stichting_hsl/v1/customerinvoice?pageSize=1000&pageNumber=7	200	200	619 B	2.47 MB	7.46 s	7.44 s	195.169.84.220
09/14/2021, 01:56:44 AM	GET	https://api.hsleiden.nl/provider/visma/visma_stichting_hsl/v1/customerinvoice?pageSize=1000&pageNumber=8	504	504	619 B	401 B	10.17 s	10.17 s	195.169.84.220

We restarted the import at 6:30. This import went fine and continued till the end.

/2021, 07:06:02 AM	GET	https://api.hsleiden.nl/provider/visma/visma_stichting_hsl/v1/customerinvoice?pageSize=1000&pageNumber=5	200	200	619 B	3.26 MB	14.21 s	14.19 s	None	195.169.84.220
09/14/2021, 07:06:17 AM	GET	https://api.hsleiden.nl/provider/visma/visma_stichting_hsl/v1/customerinvoice?pageSize=1000&pageNumber=6	200	200	619 B	3.69 MB	9.37 s	9.34 s	None	195.169.84.220
09/14/2021, 07:06:26 AM	GET	https://api.hsleiden.nl/provider/visma/visma_stichting_hsl/v1/customerinvoice?pageSize=1000&pageNumber=7	200	200	619 B	2.47 MB	7.54 s	7.52 s	None	195.169.84.220
09/14/2021, 07:06:34 AM	GET	https://api.hsleiden.nl/provider/visma/visma_stichting_hsl/v1/customerinvoice?pageSize=1000&pageNumber=8	200	200	619 B	1.03 kB	1.26 s	1.26 s	None	195.169.84.220
09/14/2021, 07:06:35 AM	GET	https://api.hsleiden.nl/provider/visma/visma_stichting_hsl/v1/project?pageSize=1000&pageNumber=1	200	200	611 B	332.56 kB	9.22 s	9.22 s	None	195.169.84.220
09/14/2021, 07:06:44 AM	GET	https://api.hsleiden.nl/provider/visma/visma_stichting_hsl/v1/project?pageSize=1000&pageNumber=2	200	200	611 B	1.03 kB	602.04 ms	601.48 ms	None	195.169.84.220
09/14/2021, 07:06:45 AM	GET	https://api.hsleiden.nl/provider/visma/visma_stichting_hsl/v1/projectbudget?pageSize=1000&pageNumber=1	200	200	617 B	464.43 kB	1.05 s	1.04 s	None	195.169.84.220
09/14/2021, 07:06:46 AM	GET	https://api.hsleiden.nl/provider/visma/visma_stichting_hsl/v1/projectbudget?pageSize=1000&pageNumber=2	200	200	617 B	1.03 kB	437.78 ms	437.28 ms	None	195.169.84.220

Can you see any performance troubles at around 1:56 last night?

Kind regards,

Frank Schimmel

Magnus Johnsen · ‎14-09-2021

Hi,

We'll look into it and see if we can see any issues.

Thank you for letting us know.

schimmel-hsleiden · ‎17-09-2021

Hello Magnus,

Last night we have had another 'Gateway timeout' 504 error at 1:52:50 (last entry in this table):

09/17/2021, 01:52:29 AM

GET

https://api.hsleiden.nl/provider/visma/visma_stichting_hsl/v2/journaltransaction?periodId=202107&pag...

200

639 B

990.18 kB

3.2 s

3.19 s

None

195.169.84.220

West Europe

8b24b6ce-1351-4695-b410-5fe327e5ba51

09/17/2021, 01:52:32 AM

GET

https://api.hsleiden.nl/provider/visma/visma_stichting_hsl/v2/journaltransaction?periodId=202107&pag...

200

639 B

999.97 kB

3.32 s

3.31 s

None

195.169.84.220

West Europe

287027eb-ffda-41a0-b8b2-2fe1f288be7d

09/17/2021, 01:52:36 AM

GET

https://api.hsleiden.nl/provider/visma/visma_stichting_hsl/v2/journaltransaction?periodId=202107&pag...

200

639 B

986.91 kB

3.29 s

3.28 s

None

195.169.84.220

West Europe

aa5d823d-308f-43c4-8219-042edd90477b

09/17/2021, 01:52:39 AM

GET

https://api.hsleiden.nl/provider/visma/visma_stichting_hsl/v2/journaltransaction?periodId=202107&pag...

200

639 B

973.74 kB

3.44 s

3.42 s

None

195.169.84.220

West Europe

681ca658-ba30-4dfe-b1ce-73dcece1f290

09/17/2021, 01:52:42 AM

GET

https://api.hsleiden.nl/provider/visma/visma_stichting_hsl/v2/journaltransaction?periodId=202107&pag...

200

639 B

983.05 kB

3.79 s

3.78 s

None

195.169.84.220

West Europe

517b273f-1f79-4d40-ab13-8dac8bde34cc

09/17/2021, 01:52:46 AM

GET

https://api.hsleiden.nl/provider/visma/visma_stichting_hsl/v2/journaltransaction?periodId=202107&pag...

200

639 B

998.55 kB

4.02 s

4.01 s

None

195.169.84.220

West Europe

da7a4bd1-7c6a-4c95-8360-821e8d48a24f

09/17/2021, 01:52:50 AM

GET

https://api.hsleiden.nl/provider/visma/visma_stichting_hsl/v2/journaltransaction?periodId=202107&pag...

504

639 B

401 B

Magnus Johnsen · ‎17-09-2021

Hi,

If it's only an occasional there should not be an issue in general.

How long did it take before timing out? Did it work when trying again?

andreasaulin · ‎17-09-2021

As Frank, we did get 504's at about the same time last night.

I addition there were some new 504 right now at 12:27