Release Notes of Invantive(R) Data Access Point 20.0.145

Invantive(R) Data Access Point

Invantive Data Access Point

Created: 03/03/2021 15:53:37 (UTC, deploy001)

Version: 20.0.145

State: Production

MSI Product ID: 2f2a336d-5d88-4f96-a981-e2084cdb5834

MSI Version ID: 2f2a336d-5d88-4f96-a981-910000001400

MSI Product Name: Invantive Data Access Point 20.0.145

Manufacturer: Invantive Software B.V.

Brand: Invantive

Category: Business

Download (URL): https://download.invantive.com/release/msi/Invantive%20Data%20Access%20Point-20.0.145.msi

File size: 60 MB

Manual (URL): https://documentation.invantive.com/2017R2/invantive-data-access-point/webhelp/index.html

Manual (PDF): https://documentation.invantive.com/2017R2/invantive-data-access-point/Invantive%20Data%20Access%20Point%20Manual.pdf

Memory Requirements: 1000 MB

Permissions: Software Requirements:

Included Components:

Version 20.0.92, released 2020-09-16.

Bug fixes:
- Do not show kind request twice on Data Access Point errors.

Version 20.0.38, released 2020-06-17.

Enhancements:
- Also return fields with null values on results

Version 20.0.34, released 2020-05-28.

Enhancements:
- Include message codes in some errors.

Version 20.0.13, released 2020-04-06.

Bug fixes:
- Allow larger URLs with large numbers of divisions.

Version 20.0.0, released 2020-02-13.

Enhancements:
- Split message codes per type of activity.
- Improve layout of HTML output.
- Improve CSS layout capabilities of HTML output.
- Enable use of format in URL when no format in preset is specified.
- Allow entry of refresh token value directly in mini query editor.
- Describe what file must be configured to fix itgenpxy011 error.
- Raise HTTP request limits.
- Add content creation date and content type output parameters for data downloads.
- Improve performance by replacing DateTime.Now by UTC now.
- Set cache control on static files for one hour.
- Allow anonymous use of Data Access Point [ITGEN-4123].
- Display partition code in error message [ITGEN-3990].
- Allow handling of up over 4 billion rows.
- Upgrade to Microsoft.net 4.7.2.
- Changes due to adding support for Linux/Unix/Mac OS on Invantive Producer products.
- Improve startup performance [ITGEN-451].
- Make DAP more resilient when the server is rebooted in the middle of an OAuth authentication process.
- Add support for logging in on Teamleader using OAuth.
- Update documentation for processing files.
- Allow uploading files, now stored as byte arrays in the parameters. It could be useful to store more information later on, like the name of the document and other properties provided.

Bug fixes:
- Always set creation date of content on Data Access Point.
- Do not break words in HTML output.
- Error handling.
- Avoid ArgumentNullException when refresh token is not presented.
- Ignore user name and password when authenticating using OAuth.
- Defaulting data container alias when just one aliased data container is present.
- A generic error occurred in GDI+. on AutoFitColumns in ExportToExcel of Data Access Point [ITGEN-3515].
- A generic error occurred in GDI+. on AutoFitColumns in ExportToExcel of Data Access Point [ITGEN-3515].
- Set language of Data Access Point correctly for translations [ITGEN-3205].

Version 17.28.0, released 2018-10-23.

Enhancements:
- Allow exporting documents.
- Allow OEM use of Data Access Point.
- Relocate templates folder.
- Add configuration file config.json to Data Access Point.
- Add configuration file config.json to Data Access Point.
- Increase maximum size of result set to above 4 billion rows.
- Add log folder.
- Make parameter value in preset optional instead of enforced until true is added  [ITGEN-3184].
- Add support for JSON flattened output. Traditional format renamed to jsondataset.
- Log off from Data Access Point.
- Log off from Data Access Point.
- Improve clarity of title on error window.
- Upgrade components.
- Allow split transfer of X-Refresh-Token for Zoho Reports.
- Define Excel names for the ranges filled for the result sets.
- Retrieve SQL parameter bind values from Preset file.
- Allow specification of content file name for exports.
- DAP: Load OAuth information from the connection provider, rather than then config.json.
- Support for OAuth Code Grant Flow from AngularJS.
- Allow use of technical headers in Data Access Point.
- Improved logon dialog. Updated credentials storage.
- Add Excel export to DAP. Fix minor bug along the way.
- Add folder Scripts for Invantive SQL scripts called by '@@'.
- Add parameters to SQL statements for context.
- Add configuration folder Config to App_Data.

Bug fixes:
- Remove null check since that defaults to the current requested path.
- Avoid NullReferenceException when no configuration has been set up.
- Avoid errors at web session start going unnoticed.
- Avoid interim internal error when following redirect during authentication on OAuth.
- Improve display of complex error messages such as "One or more errors occurred".
- Correctly format dates in Excel export.
- Apply header format on first row of Excel, and include all rows in Excel export.
- Improve performance by avoiding start XSLT processor for a ping.
- Correct determination of skin.css for HTML output.
- Exclude unsupported export format from manual.
- Remove folder Providers which movied into App_Data.
- Avoid StackOverflow by applying missing refactoring.


Details of Release Notes:

Version 20.0.38:
Also return fields with null values on results
#	src/Invantive.DataAccessPoint/DAP/DataAccessPointHelper.cs