From chatGPT: CSV (Comma-Separated Values): CSV is a simple and widely supported file format that stores tabular data. It is human-readable and can be easily imported into various applications like spreadsheets and databases. However, CSV files can be large and may not be the most efficient option for very large datasets. JSON (JavaScript Object Notation): JSON is a lightweight and flexible format for representing structured data. It is commonly used for web APIs and data interchange. JSON files are human-readable, widely supported, and can handle complex nested data structures. However, they can also be large and may not be the most space-efficient format. Parquet: Parquet is a columnar storage file format designed for big data processing frameworks like Apache Hadoop and Apache Spark. It offers efficient compression and encoding, which can significantly reduce the file size and improve query performance, especially for analytics workloads. Parquet files are optimized for column-wise data access and are suitable for large datasets. Avro: Avro is a compact, efficient, and self-describing binary file format developed by Apache. It supports schema evolution, allowing you to add, remove, or modify fields without breaking compatibility with existing data. Avro files are suitable for large datasets and are commonly used in big data processing pipelines. HDF5 (Hierarchical Data Format): HDF5 is a versatile file format designed for storing and organizing large and complex datasets. It supports hierarchical data structures, compression, and efficient chunking for accessing subsets of data. HDF5 files are commonly used in scientific and numerical applications. Apache Arrow: Apache Arrow is an in-memory data format and columnar storage system that aims to provide a common data representation for different programming languages and systems. It is designed for high-performance analytics and can facilitate efficient data exchange between different frameworks and tools.   I'm not sure what the best would be here - but Json I think is both more stable (feks CRLF, CR, special characters and so on) and easier to handle (by JsonConverters) as CSV?   But I'm not sure about this bigdata-problem actually? Did you get many threads here about timeouts when handling many pages? Or is this a question about quota limitation?   Florian      ... View more

Yes I guess you are right about that. We consider to use Insomnia instead of Postman but we have to test a bit more how the caching of the schema is handled there.   ... View more

At least when we tried on Friday with a bit of bad optimized code it was enforced in that way:   HttpRequestException: Klarer ikke å sende data! Response status code does not indicate success: 401 (Unauthorized).   I used the night from Monday to Tuesday to delete about 400.000 loglines with that message 🙂 We optimized our code and it was working again after that but in the meanwhile it stopped all calls from this client-id.    Florian ... View more

After mailing with Alexandra I try to follow up this thread again: - Is there any documentation in the meanwhile? - We are working on a quite big customer with startup on the 1st of september. Here are really a lot of integrations running and there will be thousand of API-calls in a short time. Have you any idea how we can handle that we don't stop the customer at once when we hit the quota and how we can avoid stop in the production system in a longer time when we have to optimize our systems. Here we need to help each other to avoid a bad experience for the customer. We could also show you what we are working on and what the scope of the project will be. - we did hit the quota on Monday - due to a bad handled programcode - but that stopped a lot of extensions here. I think we could from our site setup the client-id for each integration-thread, but that will cause to give access to many client-Ids in the user setup at the customer. Maybe we can see what your suggestion about this would be.        Florian   ... View more

Nothing is working here about the Swagger. What is the correct address just now? ... View more

I was just a bit surprised because I just tried to send a Base64 encoded file string which I got first from the API right back again. I changed nothing in the file content   You wrote: "We can increase the max size of the upload limit" - who is we? - I or You or Visma? If "I" than how?   🙂   Florian   ... View more

The same here, I get flooded by these error-messages in our alert-system! And the statuspage still shows operational?  ... View more

It does not exist any standard solution for that? At least I see that this is a standard issue 🙂 https://github.com/graphile-contrib/postgraphile-plugin-connection-filter/issues/113   I guess that building a parser would be a lot of work and you have to consider the security regarding code injection and building filters which will create a huge load on the sql-server. The next best solution actually would be the enumeration way.    But I understand that there is no quick fix on that.    Florian  ... View more

Is this still not supported? 🙂  We see that we would have use for that quite often... ... View more

1) Async query is not an option since the integration platform does not support that 2) I will test to reduce the number of items per page, but not ideal due to a expected number of total rows over 1 mill 3) I'm aware of this 200 handling, I just wanted to discuss that this causes some interesting problems when using tools which are expecting that 200 really means that things went ok   Florian   ... View more

We are using ngrok a lot. This also has a web-interface and a great way to see if the webhook is triggered and also the payload of the webhook message.   Florian ... View more

When will this change go in production? We are trying to make some integrations here based on service authorization where we need access to the system-tables and just now we are a bit stuck on that...   Florian ... View more

Hi Magnus   what is the status here? We have still the same issue...   Florian ... View more

Maybe this could work? query($maxDate: Int) { useCompany(no: 2136125) { free1: freeInformation1_aggregate(filter:{_or:[{freeInformationType1:{_eq:2}},{freeInformationType1:{_eq:4}}]}) { maximum { changedDate @export(as: "maxDate") } } freeInformation1_aggregate( filter: {_and:[ {_or:[ {freeInformationType1:{_eq:2}}, {freeInformationType1:{_eq:4}} ]} , {changedDate: {_eq:$maxDate}} ]}) { maximum { changedDate, changedTime } } } } ... View more

Yes, you are right.   I did not recognize that because I try to find the max-value of changedDateTime. So far the best idea was to sort by changedDateTime descending and take the first one. But in the orderBy this alias is not available. Next try is to use the aggregates, but also there alias is not available.    Any further ideas?   Florian       ... View more

I see your point. Indexing could be possible, but to handle this as a part of the return-text is maybe not such a good idea? Maybe the errormessage should be a bit more structured?   "error":"{"message":"A record with the same primary key already exists","Status":3,"Index":1}   I don't know what Status:3 means. But I see that it could be important to know if this is a warning or an error. Or if the row is created with error or not created.  ... View more

Interesting, we just discussed the same topic internally.   But: How would the Graph-query above work when we send in a list of orders? I can't see how we should connect the lines to the correct order-header even if the bug would be fixed? And that leads to the next question: In the GraphQL we can send a list of orders but the error-return does not contain a reference to the right order as far as I know, right? So its maybe better or more correct to send the orders one by one? Than the next question is how to handle the lines? Lets for example post 15 lines. The error return would could give a error-list with three errors. How can we relate the errors to the right lines? Or should we also post the lines one by one to get the right error for the right line?     ... View more

Is there any progress here? We also do need that.   Florian ... View more

Hi Yildirim,   sorry that this takes a bit of time. But now I have found out that the problem could be, that the user which is connected to the used token has been deleted. That was not us who generated the token and we are not using it either. Therefore it was difficult to understand what happened here. In addition I got feedback that only calls to to the print endpoint are not working - but now I guess that the whole integration stopped. We generate a new token on a new user and check if this solves the problem.   Florian     ... View more

Hi Yildirim,   in postman it looks this way: I wonder if there has changed something about the user-roles in admin - I will check this at the same time and we try to do the same operation in the UI ... View more

- Do you have any exception? We only have this status code: 11:20:51.0 (39088503)|CALLOUT_REQUEST|[24]|System.HttpRequest[Endpoint=https://integration.visma.net/API/controller/api/v1/customerCreditNote/402831/print, Method=GET] 11:20:51.0 (356186286)|HEAP_ALLOCATE|[EXTERNAL]|Bytes:512 11:20:51.0 (371086413)|CALLOUT_RESPONSE|[24]|System.HttpResponse[Status=Forbidden, StatusCode=403]   - Is the error company specific ? (Please also try on another company and inform us) We don't have another company to check it out.    - Have you checked the access roles of the user that the token generated with  ? We haven't change anything with our roles or a token. We use the same token all the time and previously these endpoints worked fine with the current token.     ... View more