Release notes

If you already purchased software then you must download ODBC PowerPack installation file from Customer Download Area (Click here). You cannot activate purchased license key if you downloaded Trial build from public site. To apply license key you must download FULL version.

Version 1.8.3.10208 [Feb 27, 2024]

New Features/Improvements

NEW: API Connector - SharePoint - Modify get_main_site uses endpoint to use SiteId parameter so Test connection doesn't fail due to default root site usage
NEW: All API Drivers - Add Support for NOT IN clause
NEW: All Drivers - Edited Custom Object name is not selected or visible
NEW: API Connector - Azure DevOps - Add new endpoints get_queries and get_workitems_by_query_id to fetch result from predefined query by its id
NEW: API Connector - ElasticSearch - Add Anonymous / Windows Authentication (No UserId/ Password)
NEW: API Connector - FastSpring - New connector to read / write data in FastSpring (Accounts, Orders, OrderItems, Products, Subscriptions, Quotes and more)
NEW: API Connector - Google BigQuery - Add Project and Dataset dropdown for easy selection on connection screen
NEW: API Connector - Power BI - New connector to read / write Power BI Datasets, Query using DAX
NEW: API Connector - Shopify - Add Insert, Update and Delete operations for Product, ProductVariant
NEW: API Connector - Shopify - Add new tables Locations, InventoryItems, InventoryLevels, Payouts
NEW: API Connector - Shopify - Allow Product Add, Update, Delete
NEW: API Connector - Shopify - By default include all orders (rather than just Open orders) to show POS orders
NEW: API Connector - Zendesk - Added API call delay property NextUrlWaitInMs to avoid error 429 (too many requests) during Pagination
NEW: API Connector - Zendesk - Added CRUD operations (Insert, Update, Delete and Upsert) for Users and Organizations table. For Users table you can do Upsert in Bulk mode
NEW: API Connector - Zendesk - Change Domain Label to Sub Domain to avoid confusion
NEW: API Connector - Zoho SalesIQ - New connector to read data from Zoho Chat System (SalesIQ) - Read Chats, Operators, Feedbacks, Reports and more
NEW: API Connector Framework - Add an option CacheClearFor to trigger cache invalidation for specific endpoints when this endpoint is called
NEW: API Connector Framework - Allow <Column Name="my_array_name[].id" along with DotAsPath to produce SingleDataset input (e.g. nested Array as input without using LayoutMap)
NEW: API Connector Framework - Allow row column values in ValueTemplate for Input/Output Columns (i.e. Calculated Column Scenario) - Example <Column Name="Display" ValueTemplate="<<[$parent.first$] [$parent.last$],FUN_TRIM>>" ... >
NEW: API Connectors - Zendesk - Allow bulk update for Users / Organization table
NEW: General - Improve license validation speed, add Subscription Id in UI
NEW: General - Show better message that you need Admin permission rather than "Custom object wasn't saved"
NEW: JDBC Bridge - Add Support for Infor JDBC running on Java11, Java17 (right now copy of ionapi file needed)
NEW: JDBC Bridge Driver - Add custom QuoteChar option for underlying JDBC Driver (<blank>=never quote)
NEW: JDBC Bridge Driver - Add support for additional properties (not passed via Connection URL) - Salesforce CDP usecase
NEW: JDBC Bridge Driver - Add support for removing catalog, schema and quoted identifiers issued by apps like Power BI in Table mode (helps when JDBC driver doesnt support SQL sent by caller app)
NEW: JDBC Bridge Driver - Add support for removing Schema, Catalog names from table name (Use cases - Salesforce CDP in Power BI Table import)
NEW: JDBC Bridge Driver - Add support for reporting multiple catalogs (useful 3-levels nested Power BI view)
NEW: JDBC Bridge Driver - Add support for unquoting objects (Use cases - Apache Drill, Salesforce CDP in Power BI Table import)
NEW: JDBC Bridge Driver - Allow JdbcBridge.properties file location in Root directory or Local directory (i.e. where JdbcBridge.jar found) - Local file should take precedence
NEW: JDBC Bridge Driver - Allow Proxy settings (via JdbcBridge.properties file in java.args)
NEW: JDBC Bridge Driver - Java missing prompt should allow to choose Java version use like to install (e.g. Java11, 17, 21) rather than default to Java 8
NEW: JDBC Bridge Driver - Log additional properties on JDBC Bridge Log file
NEW: JDBC Bridge Driver - Log MM/dd prefix in Java log
NEW: JDBC Bridge Driver - Provide a way to do rolling log
NEW: JDBC Bridge Driver - Provide a way to include dependency jar files like DBeaver and other tools like BRIC
NEW: JDBC Bridge Driver - Provide a way to use user defined path for JAVA Version in JdbcBridge.properties file (e.g. java.path=c:\java\java8\bin)
NEW: JSON Driver - Add support for "@param" syntax along with "?" to support apps like MS Access + Data Gateway using SQL Native Client in ODBC

Bug fixes

FIX: All Drivers - Order grid not sorting by actual value
FIX: All Drivers - Some apps (e.g. Informatica ASCII instance requests SQL_C.CHAR) shows null string data due to invalid string length error (Apps requesting unicode string SQL_C.WCHAR works fine)
FIX: All Drivers - When Driver={....} is missing in connection string Load Settings fail
FIX: API Connector - Shopify - Product and ProductVariant table shows wrong datatypes
FIX: API Connector Framework - Allow brackets and other special character as column name for [$parent.column_name$] placeholder
FIX: API Connector Framework - AllowParamBindForLayoutMap and MultiSelectTemplate doesn't work with ValueTemplate
FIX: API Connector Framework - Endpoint flagged as AllowParamBindForLayoutMap=true not visible in EndPoint list on UI
FIX: API Connector Framework - Larger than 64MB file upload hangs (or timeout) - SharePoint, OneDrive, Google Drive Connector upload issue
FIX: API Connector Framework - Multiple Template Usage can cause issue if you do not set EndPoint Properties in first Template
FIX: API Connector Framework - ValueTemplate invokes DirectPlaceholder function in wrong order (i.e. its called before {$value$} and [$param$] )
FIX: API Driver - Add support for 3 Part Column names so apps like MS Access works fine with Linked Table mode
FIX: API Driver - INSERT then SELECT cause Object disposed error
FIX: API Driver - near "Order": syntax error (For any Reserved Keywords)
FIX: API Driver - Query Builder doesnt generate column list for Dynamic Expanded Columns which requires Parameters
FIX: API Driver - Query Builder shows unquoted Name in some cases
FIX: Data Gateway - Code Generation doesnt comment some unwanted lines and used wrong user name
FIX: Data Gateway - Service doesn't restart if JDBC Bridge request was made in last one minute (jar file locked)
FIX: Data Gateway - Some apps like MS Access might fail to connect via SQL Native Client 11.0 - Object reference not set
FIX: Data Gateway - Use SHA256 for encryption to avoid FIPS violation
FIX: Data Gateway - When FIPS Policy turned on you cannot use Gateway UI - Provide a better error message with workaround
FIX: Data Gateway - You may get Object reference not set error when no users / dataset defined
FIX: JDBC Bridge - Large decimal types throws error - Unsupported numeric type (E.g. NUMERIC(255,2))
FIX: JDBC Bridge Driver - Dates like 0001-01-01 not allowed- Error: Ticks must be between DateTime.MinValue.Ticks and DateTime.MaxValue.Ticks.
FIX: JDBC Bridge Driver - Improve GetColumns ODBC compatibility
FIX: JDBC Bridge Driver - MA Access - List Tables fails
FIX: JDBC Bridge Driver - read error if column type is NUMERIC and precision > 28
FIX: JDBC Bridge Driver - Same table name in multiple catalogs cause issue (generate 3 parts table on UI table list pick if catalog is present)
FIX: JDBC Bridge Driver - Some JDBC Drivers (e.g. Amazon Athena) fails to query table list - Error : Unrecognized table type: "'TABLE'"
FIX: JDBC Bridge Driver - TIME datatype throws error - Row read error: JBR error: java.lang.IllegalArgumentException at java.sql.Time.getYear(Time.java:161)
FIX: JDBC Bridge Driver - Very long sql statement cause IO Exception - Throw meaningful error
FIX: JDBC Bridge Driver, Salesforce Driver - Implement default QuerySpecialColumns
FIX: JDBC Driver - Wrong column metadata returned in some cases when you query multiple tables over same connection
FIX: JSON, XML, CSV Drivers - "Meta" property does not support columns with square brackets in the name
FIX: Salesforce Driver - MS Access Failed in Linked Table Mode - Didn't understand relationship 'DATA' in field path
FIX: Salesforce Driver - Nested Subquery IN clause not supported
FIX: Salesforce Driver - Python 64 Bit Error - The driver did not supply an error!
FIX: Salesforce, API Driver - If you use true/false keyword in SQL it throws error - Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index

Version 1.8.2.11019 [Nov 22, 2023]

New Features/Improvements

NEW: All Drivers - Remember last query when you Open / Close UI
NEW: JDBC Bridge Driver - Hide objects like INDEX, SEQUENCE, SYSTEM INDEX, Blank Type
NEW: JSON / XML/ CSV Driver - Add support for AccessMode in WITH clause - Query builder generated SQL throws error - Execution error: Query execution error: Option 'accessmode' is not supported!
NEW: JSON / XML/ CSV Driver - When Direct Value set and you select from Table dropdown throwing an error for Direct String mode 'Data Path' parameter must be set
NEW: JSON, XML Drivers - Treat "$" as blank filter

Bug fixes

FIX: All JSON / XML / CSV Drivers - Casting and aggregate functions is not working for the string type data like 0000160209
FIX: API Driver - Query Example correction needed for generic_endpoint (should be changed to generic_request)
FIX: Data Gateway - Catalog / Schema Name with Dash, dot or space cause issue
FIX: Data Gateway - In a rare case you might get error loading Setting dialog box - Cannot load assembly - Path not found
FIX: Data Gateway - JDBC Bridge - Power BI Error - Communication Link failure - When underscore or dot found in object name
FIX: Data Gateway - No tables / schema listed for some drivers (e.g. PostgreSQL JDBC) - When JDBC Bridge accessed via SQL Native Client ODBC talking to Gateway
FIX: Data Gateway - Salesforce - Many catalogs listed when you connect gateway via SQLNcli driver
FIX: Data Gateway - Salesforce - You may get malformed query error in Apps like Power BI when you access in Table selection mode
FIX: Data Gateway - Some JDBC fails when catalog (3part query) not supported but App like Power BI sends 3 parts query
FIX: JDBC Bridge - Schema name is not used to fetch table fields
FIX: JDBC Bridge Driver - Encountered Unexpected token ";"
FIX: JDBC Bridge Driver - Give option [Quote names] to handle quoted names correctly (e.g. column-1 to "column-1" ) when you select table name on the Preview tab
FIX: JSON / XML / CSV Driver - Column names with # and ? characters needs proper quoting in auto generated query
FIX: JSON / XML / CSV Driver - Some columns with accent / unicode character in the name might not be quoted in auto generated query
FIX: Salesforce Driver - Quoted identifiers generated by apps like Power BI throws error

Version 1.8.1.10901 [Sep 21, 2023]

New Features/Improvements

NEW: All Amazon, Azure, Secure FTP Drivers- Allow ConvErrorHandlingMode option to continue on type conversion / truncation errors
NEW: All API Drivers - Add support for CASE Statement in WHERE / GROUP BY Clause
NEW: All Drivers - Add Advanced Option TempStorageMode (Memory=0, Disk=1) and TempStorageDirectory to handle OutOfMemory Exception for large dataset result
NEW: All Drivers - Allow to change max rows setting more than 20000 rows in the Preview Tab
NEW: API Driver - Add support for Multi Key Lookup in SELECT statement (e.g. select * from OrderDetails where OrderId=100 and ItemId=22)
NEW: API Driver - Add Support for true | false keywords in INSERT / UPDATE statements
NEW: Data Gateway - Prompt to restart like datasources tab when user edit Users and dont restart
NEW: Data Gateway - Salesforce - List Tables in SSMS for Linked Server
NEW: Excel Driver - Choose Tab automatically with matching string in any Tab - New Property SearchStringForTabSelect
NEW: Excel Driver - Provide a way to read all Tabs with matching regex
NEW: General - New connection level property ConnectionStringFile property to load long connection string from file - Specifically addressing the 1024+ character limit with ConnectionString for Ado.net / OdbcConnection classes in programming (e.g. C#)
NEW: JDBC Bridge Driver - Add Option to force output on or off ( Prefix #Output-On or #Output-Off)
NEW: JDBC Bridge Driver - Provide options to enable retry certain errors (e.g. RetryCount, RetryDelay,RetryDelayMultiplier,RetryMessageRegex)
NEW: Salesforce Driver - Add support for AssignmentRuleId, UseDefaultAssignmentRule options in UPDATE, INSERT, UPSERT
NEW: Salesforce Driver - Add Support for Odbc SQLPrepareW (Fetch Meta without invoking Data Fetch)
NEW: Salesforce Driver - Increase default BatchSize from 200 to 2000 rows per batch to increase the read speed
NEW: Salesforce Driver - Provide a connection UI option - IncludeDeleted (Includes deleted rows in SELECT query)
NEW: Salesforce Driver - Update examples to indicate how to use FieldsToSetNullIfInputNull, AssignmentRuleId, UseDefaultAssignmentRule, AllOrNone, AllowFieldTruncation, AllowSaveOnDuplicates options

Bug fixes

FIX: All API Drivers - EXEC WebRequest might fail sometimes with SSL/TLS Error
FIX: All API Drivers - Failure in EXEC WebRequest does not show full error sometimes - It shows just one line error - Target Invocation error instead
FIX: All API Drivers - Long Text (i.e. DT_NTEXT) is detected as DT_WSTR(50) when you choose XML Connector Format to view metadata
FIX: All API Drivers - When you use ConvErrorHandlingMode option in WITH clause it says not supported
FIX: All Drivers - ConvErrorHandlingMode option not working correctly
FIX: API Driver - Create Virtual table with re-ordered required columns only and on preview it is loading data based on column index instead of the particular column data
FIX: API Driver - Created Custom Virtual Table is not listed in the drop down
FIX: API Driver - Only last statement executed when multiple SQL executed in a batch separated by semicolon (e.g. your-sql-stmt; your-sql-stmt ; your-sql-stmt)
FIX: API Driver - Qualified Key (tablename.keyname) in WHERE is not parsed as Primary Key (e.g. SELECT * FROM MyTable WHERE MyTable.Id=123)
FIX: API Driver - Quote around for column names with special characters (e.g. - , $, . )
FIX: API Driver - When WHERE clause not supplied DELETE / UPDATE doesnt do anything
FIX: API Driver - You may get OutOfMemory Exception for large dataset (Cache Options in WITH clause not working either)
FIX: Data Gateway - Empty Query might hang
FIX: Data Gateway - Enforce Database name in connection setting / throw better error when DB name is not set - Currently you see misleading error: Object reference not set
FIX: Data Gateway - In certain situation you will see CAL needed error (even previous connection failed) - For example connection from Machine-1 caused SSL/TLS secure channel... and later connect fromMachine-2
FIX: Data Gateway - Some registry key entries not cleaned up (under HKEY_CURRENT_USER\.DEFAULT\SOFTWARE\Classes\CLSID) if Service account has no write access to HKEY_CLASSES_ROOT
FIX: Data Gateway - SqlNative Client DSN UI doesnt show any entry for Database dropdown
FIX: JDBC Bridge Driver - After caller app is crashed java.exe is not released from memory (orphaned)
FIX: JDBC Bridge Driver - Catalog name listed many times in Power BI / Excel or some other Apps or Sometimes tables not listed
FIX: JDBC Bridge Driver - Files sitting in same folder as driver jar not detected (e.g. Infor *.ionapi file not found error)
FIX: JDBC Bridge Driver - Hide unwanted objects from preview tab (e.g. SYSTEM VIEWS, INDEX)
FIX: JDBC Bridge Driver - High CPU usage issue
FIX: JDBC Bridge Driver - Stored Proc doesnt return output
FIX: Salesforce Driver - Column [__id] wasn't found - Error occurs if system columns used in the WITH Clause Output attribute for INSERT / UPDATE / DELETE / UPSERT
FIX: Salesforce Driver - ConcurrencyMode option in INSERT / UPDATE / UPSERT .... WITH clause throws error - Invalid cast from 'System.String' to 'ZappySys.Crm.Salesforce.ConcurrencyMode'.
FIX: Salesforce Driver - EnableBulkMode=1 causes duplicate data for INSERT / UPSERT Operation when called via OPENQUERY in SQL Linked Server but if you use EXEC .. AT works fine
FIX: Salesforce Driver - Inner Exception not displayed in some cases (e.g. Proxy Issue)
FIX: Salesforce Driver - UPDATE / INSERT Static Value doesnt output column if you use Output=[columns list]
FIX: Salesforce Driver - UPDATE Not showing columns in the output if its not matching exact case as defined in Salesforce
FIX: Salesforce Driver - UPDATE with OUTPUT=[column list] doesnt work (it skips columns you like to output)
FIX: Salesforce Driver - When Where clause in DELETE / UPDATE returns no record then you might get error - Index was out of range
FIX: Salesforce Driver - When you use SOURCE Clause with Output='Column1, Column2, ...' or Output='*' you always get lower case names in the output
FIX: Salesforce Driver - White space before DELETE / UPDATE causes error - Index and length must refer to a location within the string
FIX: Salesforce Driver - You may get OutOfMemory exception when many input rows supplied by SOURCE clause in UPDATE/DELETE/INSERT/UPSERT statement plus Output option supplied in WITH
FIX: Salesforce, API Driver - CRUD Operations with SOURCE clause may not fire operation if issued via ExecuteNonQuery Method

Version 1.8.0.10601 [Jul 11, 2023]

New Features/Improvements

NEW: API Driver - CosmosDB - New connector to Read / Write / Query documents and other objects (e.g. Database, Containers)
NEW: API Driver - Azure DevOps (TFS) - New connector to Read / Write / Query items (e.g. Tasks, Bugs, User Story)
NEW: API Driver - ServiceNow - New connector to Read / Write / Query tables (e.g. Incidents, Tasks, Users)
NEW: API Driver - MailChimp - New connector to Read / Write / Query MailChimp data (e.g. Campaigns, Lists, Subscribes, Reports)
NEW: All API Drivers - Allow bool as alias for boolean type in META clause (e.g. META='flag: bool')
NEW: All API Drivers - Allow just column names without datatype in Meta - use string(2000) as default if type missing (e.g. select * from tbl WITH(META='col1;col2;col4;col5:int;col6:string(100)') )
NEW: Amazon JSON / XML /CSV Driver - Update AWS SDK (Core Driver to v3.7)
NEW: API Connector Framework - Add Support for Multiple LookupEndPoints based on Parameter count (LookupEndPoint="ep_by_customerid, ep_by_orderid")
NEW: API Driver - HubSpot - Add Upload File endpoint
NEW: Data Gateway - Encrypt Setting File with user defined password
NEW: General - Update Client Side Query Engine to v3.40
NEW: JDBC Bridge Driver - Add logging
NEW: JSON / XML / CSV Driver - Add option to Create new API Connector File from UI settings on the Preview Tab
NEW: JSON / XML / CSV Driver - Add support for reading *.tar.gzip file (multiple files in one tar.gzip)
NEW: JSON / XML / CSV Driver - ClientCertificate not supported if you change SslVersion settings other than Default

Bug fixes

FIX: All API Drivers - Certain errors not bubbled up to the caller application
FIX: All API Drivers - When META is set to int, bool, date and you encounter blank data then it throws error about conversion (we should treat blank number, date, bool as null) - Error Input string was not in a correct format.
FIX: All Drivers - Misleading error is thrown (Value cannot be null) when you run Stored Proc which has syntax issue (i.e. not starting with CREATE PROC statement)
FIX: All Drivers - Duplicate column names in SELECT cause misleading error (Item Key already added)
FIX: All Drivers - More than 900 columns throws error - too many SQL variables
FIX: All Drivers - Preview Tab shows duplicate entries in Table dropdown if you click Dropdown multiple times too quick
FIX: All Drivers - View Metadata shows wrong code for API Connector XML option (Rather than DataType=xx , it shows Type=xx)
FIX: API Driver - Always Treat Blank Number, Date, Bool as Null is not working
FIX: API Driver - Delete / Update clause does not set Table Parameters from WITH clause
FIX: API Driver - Limit rows coming back from WHERE clause in Update / Delete in Preview (Honor Max Rows setting)
FIX: JDBC Bridge Driver - Cache Settings not saved
FIX: JDBC Bridge Driver - Stored Proc doesnt return output
FIX: JSON / XML / CSV Driver - Direct String option not saved and only works if you use WITH (DATA=xxxx) in SQL, UI option ignored
FIX: JSON / XML / CSV Drivers - Value for Direct Data and Keep Date As String Option not saved
FIX: JSON, XML , CSV Driver - Placeholder function doesnt work in URL / Body / Headers (When entered on UI) - Works ok if you override in WITH Clause SRC
FIX: JSON, XML Driver - Curly bracket in comment section cause error when URL JOIN (e.g. JOIN_1 in WITH ) feature is used - Error - Input string was not in a correct format

Version 1.7.0.10327 [Apr 15, 2023]

New Features/Improvements

NEW: API Driver - Outlook Mail (Office 365) - New connector to read / download mail and attachments from Office 365 Mail account
NEW: API Driver - Shopify - New Connector to Read / Write Shopify data (e.g. Customers, Products, Orders)
NEW: API Connector - Google BigQuery - Add Job Location Option for get_query and connection Level
NEW: API Connector Framework - Add Option TreatBodyAsDirectValue (Body parsed as input data rather than calling URL)
NEW: API Connector Framework - Allow to Read data From Local File - (Set <EndPoint Url="c:\data\file.json" or ".xml" or ".csv")
NEW: API Connector Framework - Generic Request - Make Content-Type and Request Method visible by default
NEW: General - Add API Connector format in View Metadata dialog box
NEW: JDBC Bridge Driver - Check Java found - If missing then Download JRE in single click
NEW: JDBC Bridge Driver - Replace Named Pipes to Socket to avoid orphan process / hang / access denied / timeout issues
NEW: JSON / CSV / XML Driver - Add an option to support high precision / scale decimal numbers (more than 15 digits numbers)
NEW: JSON, CSV, XML Driver - Add Support for high precision decimal numbers (New Option under Date/Number Handling)

Bug fixes

FIX: API Connector Framework - When Direct Placeholder Function used along with [$SomeParam$] in ValueTemplate of InputColumn then it doesnt evaluate for each row (Using Cached Value rather than Row By Row) - Example [$p1]<<{$value$},FUN_BASE64ENC>>
FIX: API Connector Framework - When Key column not declared in InputColumns - Delete / Update might fail - error near "from" ()
FIX: API Connector Framework - When nested column under Unbound node found in LayoutMap not supplied you may see bad JSON created
FIX: API Connector Framework - Zendesk - When you dont supply requestor / comment your create Ticket call might fail
FIX: API Driver - When WHERE clause not supplied DELETE / UPDATE doesnt do anything
FIX: Data Gateway - CAL is taken by unwanted callers even they are not logged in
FIX: Data Gateway - Existing connections created before v1.6.0 corrupted (Before Aug 10, 2022)
FIX: Data Gateway - IP Filter Rules not working for multiple conditions
FIX: General - Click on Activate License throws misleading error if activation fails - It says could not load file or assembly Rebex.Http
FIX: General - Preview window Trims error message to 1024 characters
FIX: JSON Driver, XML Driver - When nested filter used (e.g. $.customers[*].orders ) along with IncludeParentColumns option not working sometimes (Throws error or shows wrong value for parent column)

Version 1.6.3.10117 [Jan 17, 2023]

New Features/Improvements

NEW: All Drivers - Add support for Turkey (tr-TR) and Azerbaijani (az-Cyrl) environment
NEW: JDBC Bridge Driver - Change Driver name from "Jdbc Bridge" to "JDBC Bridge"

Bug fixes

FIX: All Drivers - Load Connection Settings can only accept string upto 32KB - Longer settings cannot be loaded (Truncated)
FIX: All Drivers - Load Settings might throw error if new line found - Error-Invalid ConnectionString format. Name value pair is missing for [ newline ]
FIX: All Drivers - Logging feature is not working as expected sometime (Some Log entries not found in File)
FIX: API Driver - BigQuery - Data Fetch Request Fired two times
FIX: API Driver - Query Builder generated SQL for Generic_Request endpoint does not work correctly when you pass Body / Headers (renaming RequestData, RequestMethod works)
FIX: API Driver, Excel Driver - LogPath, LoggingLevel is not applied correctly via Odbc ConnectionString
FIX: JDBC Bridge Driver - Copy ConnectionString (without Password) option copies password
FIX: JDBC Bridge Driver - For some JDBC Views not reported in the Dropdown (Preview Tab) - Problem in Infor JDBC
FIX: JDBC Bridge Driver - In some apps (like VS Solution Explorer) - Tables / Views / Procs not reported
FIX: JDBC Bridge Driver - java.exe process is not released from memory in some cases (e.g. Power BI Desktop)
FIX: JDBC Bridge Driver - Object reference not set error in log when JDBC driver throws error
FIX: JDBC Bridge Driver, API Driver - Wrong Catalog name is used
FIX: Salesforce Driver - When you call INSERT with EnableBulkMode you may get error - Could not load file or assembly ZappySys.Json
FIX: SFTP / Azure Blob Drivers (for CSV / JSON / XML) - You may get error - Could not load file or assembly ZappySys.Json on UI load or execution
FIX: SFTP CSV / XML / JSON Driver - Detailed Log is not produced

Version 1.6.2.11031 [Nov 01, 2022]

New Features/Improvements

NEW: API Driver - Allow placeholders in ValueTemplate property for Columns with Dynamic Expand option set to true
NEW: API Driver - Use example values from Input Columns to generate CRUD statements if Connector file supports it
NEW: API Driver - Zendesk - Show all custom fields when you query Tickets (Previous approach was limited to 5 fields only)
NEW: API Driver - Zendesk - Update Read Tickets (Incremental) endpoint to support functions in Start Time Parameter. Now you can use date time function (i.e. yesterday, monthstart etc) along with static date (i.e. 2021-01-01 or 2021-01-01 23:59:59) to set
NEW: Salesforce Driver - Provide an option to supply API Version for Bulk / SOAP API (Right now BULK API version is hardcoded and no way to change, SOAP also same way but work around is there to change Service Type=Other)
NEW: Salesforce Driver - Update API Version to 55.0 for SOAP and Bulk API to take advantage of new features

Bug fixes

FIX: API Driver - Some properties like Functions, ValueTemplate, Order, Label etc doesnt work in Param Template
FIX: API Driver - Stripe - Update endpoints to for date time as input / output rather than Unix timestamp

Version 1.6.1.11017 [Oct 18, 2022]

New Features/Improvements

NEW: API Driver - Youtube - New connector to read, search Videos / Playlists and other information (like, view, share, title, watch time etc)
NEW: API Driver - Stripe - New connector to read / write Customers, Orders, Invoices, Products, Subscriptions and more
NEW: API Driver - Zoom - New connector to read Meetings, Webinars, Attendees and other information from Zoom Service
NEW: API Driver - Amazon Ads - New connector to read reports for Amazon Ads Account
NEW: API Driver - ManageEngine ServiceDesk Plus- New Connector to read data from Requests, Tasks, Notes, Worklog and more
NEW: API Driver - HubSpot - Add support for PrivateApp Authentication (Using Static Access Token)
NEW: API Driver - SharePoint - Added support for Managed Metadata fields (Show Label, WssId and TermGuid)
NEW: General - Show user friendly license error when either valid license not found or its expired

Bug fixes

FIX: All API Drivers - Duplicate Custom Objects entries listed sometimes on Preview Table for Table dropdown
FIX: All API Drivers - WaitTimeMs conflicts with other property, RetryMode appears twice
FIX: All Drivers - After you preview 100 queries you start getting error - capacity was less than the current size
FIX: All Drivers - Generated query should quote around name if it contains @ char
FIX: All Drivers - Saving Metadata option not working
FIX: All Drivers - When you use parenthesis or some other invalid chars in DSN names it throws error
FIX: API Driver - OAuth Generate Token button remains disabled in some cases also not showing count down
FIX: General - WHERE clause not invoked when called from SELECT * INTO
FIX: JDBC Bridge Driver - BigInteger error
FIX: JDBC Bridge Driver - If you choose object with space in the name from non default schema - you might get error - Incorrect syntax near
FIX: JDBC Bridge Driver - Metadata for string columns not reported correctly (Length always zero)
FIX: JDBC Bridge Driver - Numeric values might fails to import in apps like SSIS
FIX: JDBC Bridge Driver - Some datatypes not handled correct way (e.g. variant in MSSQL)
FIX: ODBC SFTP JSON / XML / CSV Driver - You may get Object must be the same type as the enum error when you click on preview tab (It only happens if DSN not saved)

Version 1.6.0.10801 [Aug 10, 2022]

New Features/Improvements

NEW: All API Drivers - Add support for OAuth 1.0 with SHA256 (Usecase like NetSuite API)
NEW: All API Drivers - Add Support for Tls 1.3
NEW: All API Drivers - Allow Regular Expression Extract for Paginate using [Response Header Contains Continuation Toke] Mode (e.g. nextHeader=someResponseHeader(your-regular-expression) )
NEW: All API Drivers - Allow to use different header name for next request for Paginate using [Response Header Contains Continuation Toke] Mode (e.g. header::nextHeader=someResponseHeader )
NEW: All API Drivers - Generate Meta data in compact mode by default, also give option to generate legacy Json based format
NEW: All API Drivers - List custom PROC in Preview Dropdown
NEW: All API Drivers - Paginate using Pass Response Header to Next URL Mode throws error - Specified value has invalid HTTP Header characters
NEW: All API Drivers - Provide right click menu - for Create new Table (SQL Mode) or new table (ConnectionString Mode) - Faster (for New Virtual Table)
NEW: All API Drivers - When you add custom object (Table Type) user doesnt have option to choose Mode (i.e. SQL or Connection)
NEW: All SFTP Drivers - Add support for Ed25519 (EdDSA on edwards25519 curve)
NEW: API Driver - Add support for Zip format
NEW: API Driver - Show Virtual Tables on Preview Dropdown
NEW: Data Gateway - Add new Connector for Excel
NEW: Excel Driver - New ODBC Driver to read / write Excel
NEW: General - Remember last N query for specific Data Source
NEW: JDBC Bridge Driver - Clicking view Meta data throws error in some case - Requested value 'Int16' was not found.
NEW: JDBC Bridge Driver - Some cases you might get Key not found error
NEW: JSON, XML, CSV , Azure , Amazon , SFTP Drivers - Recursive Scan option doesnt work
NEW: OAuth Connection Manager, Google Data Connection Manager (Google Analytics) - Use Loopback Redirect URL for Custom App to comply with new Google Changes (Disallow - Redirect to urn:ietf:wg:oauth:2.0:oob for apps created after Feb 2022)

Bug fixes

FIX: All API Driver - Custom Object Save saves bad syntax without warning
FIX: All API Drivers - Add support for 3 parts in SELECT Column names to support apps like MSAccess which can issue query like this (i.e. select DATA.Customers.CustomerID from DATA.Customers )
FIX: All API Drivers - Add support for 3 parts in SELECT Column names to support apps like MSAccess which can issue query like this (i.e. select DATA.Customers.CustomerID from DATA.Customers )
FIX: All API Drivers - Compact Mode Metadata might cause odd error about invalid syntax - SQL logic error or missing database
FIX: All API Drivers - ContineOnErrorForStatusCode doesnt work (Due to MatchForEqual is always Set as False rather than True)
FIX: All API Drivers - More than 16 arguments in function or VALUES clause throws error
FIX: All API Drivers - OAuth Option [Do Not Send Credentials in Body] doesnt work (It sends secret in Body regardless)
FIX: All API Drivers - Preview doesnt generate columns for Virtual Tables if it has columns with space inside it
FIX: All API Drivers - Preview for Custom Object hangs
FIX: All API Drivers - Warn user if trying to load wrong driver connection string
FIX: All API Drivers - You may get object reference not set error on Connection Configure link click
FIX: API Driver - Changing Refresh token path not detected once you wipe out file path
FIX: API Driver - Column listing fails for some tables (specially table name contains space or special character like $ or dash, do)
FIX: API Driver - Comment WHERE Key=somevalue part in generated SQL when WITH clause is included to avoid bad SQL
FIX: API Driver - Get Tables Operation fails for some apps (i.e. Sage)
FIX: API Driver - Query Builder does not recognize column mapping to Param and shows same in WHERE clause (needs to comment WHERE clause)
FIX: API Driver - Query Builder doesnt produce correct query for SELECT (Column list + WHERE clause issue)
FIX: API Driver - When you choose Table from Preview Dropdown it may not show Builder UI to choose required parameters
FIX: Data Gateway - Save Operation throws error - NullReference when Service not found
FIX: Data Gateway - Some users might get error on connection - The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel
FIX: General - Log doesnt include timestamp
FIX: General - Show errors in red on Custom Object UI
FIX: JDBC Bridge Driver - Support some advanced datatypes
FIX: JDBC Bridge Driver - Table mode fails from some tool (like Power BI - Table mode) - Throws Invalid object (when object is stored in non default schema)
FIX: JDBC Bridge Driver - When object name contains space - Table mode fails from some tool (like Power BI)
FIX: JDBC Bridge Driver - When object name contains system reserved word (i.e. dbo.Case )- Table mode fails from some tools like Power BI
FIX: JSON Driver - Virtual Table query fails to get metadata - Hangs on Fetching metadata step
FIX: Salesforce Driver - In some cases syntax of External Query might be cause object reference not set error

Version 1.5.1.10301 [Mar 10, 2022]

New Features/Improvements

NEW: JDBC Bridge Driver - Prefix schema name to table when you select it from table dropdown and default query is generated (by default schema is not prefixed)

Bug fixes

FIX: All API Drivers - Add support for Page End Indicator / Value for other pagination modes (currently it shows only for Pagination By Response Attribute Mode)
FIX: All API Drivers - Some Pagination notes are trimmed and no way to scroll view to see details
FIX: All API Drivers - When Meta is used exceptions are not thrown
FIX: All Drivers - Table name is not refreshed
FIX: All Drivers - You might get error Object reference not set - when you change focus while you are on Preview Tab and Table list dropdown is open
FIX: JDBC Bridge Driver - Column name with special characters (dash, space, dot, $) not quoted
FIX: JDBC Bridge Driver - For some numeric types you might get error - Row read error: JBR error: java.lang.Exception: Unsupported numeric type
FIX: JDBC Bridge Driver - Treat unsupported types as string rather than throw error
FIX: JDBC Bridge Driver - You may receive error - JBR error: java.lang.IndexOutOfBoundsException: Index: 1, Size: 0
FIX: Salesforce Driver - After you make changes on UI changes not applied so Test Connection, Table Dropdown may not use latest connection settings causing error / misleading information
FIX: Salesforce Driver - Execution error: INVALID_LOGIN: Invalid username, password, security token; or user locked out. >> Reason: Password or SecurityToken was empty. ErrorCode: ERR_EMPTY_CREDS

Version 1.5.0.10201 [Feb 02, 2022]

New Features/Improvements

NEW: All API Drivers - Allow to use Custom SQL for Virtual Table
NEW: All API drivers - META with extended query syntax cause invalid syntax error
NEW: All Drivers - Add option to export preview result to CSV / TSV file or copy to clipboard
NEW: All Drivers - Allow to cancel query execution on the preview tab
NEW: All Drivers - Show Preview errors in non-blocking text area rather than Blocking Popup
NEW: API Connector Framework - Allow to map __RAWDOC__
NEW: API Driver - Enhance Query Builder to add column list / key in WHERE for SELECT, UPDATE , INSERT, DELETE
NEW: API Driver - Some changes on UI not saved in active connection causing failure on Preview / Test Connection
NEW: API Driver - Support WHERE Clause in DELETE / UPDATE Operations
NEW: API Driver - Support WHERE Clause in SELECT
NEW: API Driver - Support WHERE clause server side execution for UPDATE / DELETE / SELECT if API can handle it
NEW: API Driver, Salesforce Driver - SOURCE clause should invoke on the same connection if Driver Type and ConnectionString parameters are not supplied
NEW: CSV Driver - Provide an option to output blank value as null
NEW: Data Gateway - Log Additional System Info
NEW: Data Gateway - Show warning about service restart required in order to apply changes
NEW: Data Gateway - Update SSL support to accept Tls1.1 and Tls1.2
NEW: General - Place holder function FUN_IF_NULL ( Syntax: input_value { |~| template_for_null_input } { |~| template_for_non_null_input } {|~| value_encoding_style } ) , Example: <<some input |~| Input is null |~| Input is $1 |~| jsonenc , FUN_IF_NULL>>
NEW: General - Provide F5 shortcut for Preview Data button
NEW: General - Provide max Log File Size option
NEW: JDBC Bridge Driver - Add path browse option for jar file
NEW: Jdbc Bridge Driver - Add Support for DateTimeOffset Type
NEW: Jdbc Bridge Driver - Return BIGINT type as Int64 rather than decimal
NEW: JSON Driver, XML Driver - Add Support regular expression in Filter (i.e. select * From $ WITH (Filter='$.[?(@.Company =~ /^Micro(.*)$/)]' ) )
NEW: JSON Driver, XML Driver - JSONPath Filter support for root objects (e.g. $..[?(@country=='USA')] )
NEW: JSON, XML, CSV Driver - Add Option to parse output from command line Standard Output Stream (e.g. select * from $ WITH(Data='cmd:>curl -k http://httpbin.org/get') )
NEW: Salesforce Driver - Add support for OAuth Tokens security rather than Password (useful for 2FA / MFA handling)

Bug fixes

FIX: All Drivers - Add Support for ODBC Command Timeout
FIX: API Driver - Add Support for RefreshTokenFilePath (Changing Token Pattern)
FIX: API Driver - GUID type might cause error - Unknown SQL Type - 0
FIX: API Driver - Hide any Endpoint which needs {$row$} input at runtime
FIX: API Driver - LIMIT Clause is not honored when you execute query outside Preview Tab (i.e. Call from ODBC Apps)
FIX: API Driver - UPDATE / DELETE may throw error when you have space in object name and WHERE clause is used
FIX: Data Gateway - Code generator uses SQLNCLI rather than SQLNCLI11 for SQL Server Linked Server creation code - This cause issue with some query because wrong driver is being used
FIX: Data Gateway - Default Script cause issue for EXEC AT with INSERT - Error in TDS Stream - The operation could not be performed because OLE DB provider "SQLNCLI11" / "MSOLEDBSQL" for linked server "ls_Json" was unable to begin a distributed transaction
FIX: Data Gateway - In some cases long running HTTP requests might hang connection (This usually happens when HTTP exception happens after Caller Timeout or CommandTimeout set too low or exception happens after CommandTimeout)
FIX: Data Gateway - New version throws error about SSL/TLS negotiation in some cases
FIX: Data Gateway - Query hangs on certain exceptions and might crash gateway
FIX: Data Gateway - When you click Restart button on gateway UI - You may receive Time out has expired and the operation has not been completed
FIX: Data Gateway - When you open UI it may open multiple instances
FIX: Data Gateway - You might get random license error when too many connections made same time
FIX: General - Brackets around column name in UPDATE does not work or throw error (i.e. UPDATE tbl SET [my column] = 1 )
FIX: General - Preview Grid might throw error when you sort column by clicking on header - Error - Object must be of type string
FIX: INTERNAL- Log Mode Dropdown on Gateway shows blank
FIX: JDBC Bridge Driver - Add Support for TIMESTAMP_WITH_TIMEZONE JDBC Type
FIX: JDBC Bridge Driver - Do not invoke SQL Parser (because syntax like CTE or CAST (c as varchar) fails )
FIX: JDBC Bridge Driver - Exception in thread "main" java.lang.NoClassDefFoundError:
FIX: JDBC Bridge Driver - Set working directory same as JDBC Driver (This helps scenario like Infor-ION driver JDBC Driver)
FIX: JDBC Bridge Driver - Show meaningful error rather than Pipe is broken (Capture unhandled exception right way)
FIX: JDBC Bridge Driver - When Pipe is broken error occurs certain Client Apps connecting to Gateway might hang
FIX: Jdbc Bridge Driver - You might get misleading message if JRE missing - Failed to launch interop server host process

Version 1.4.2.11005 [Oct 06, 2021]

New Features/Improvements

NEW: All API Drivers - Add support for window functions (e.g. ROW_NUMBER , RANK, PERCENT_RANK, NTILE, NTH_VALUE, LEAD, LAST_VALUE, LAG, FIRST_VALUE, DENSE_RANK, CUME_DIST)
NEW: All API Drivers - Provide a setting to apply META in merge mode in simple, extended, URL join queries
NEW: All API Drivers - Provide an example of merge mode ( OverrideMode )
NEW: All Drivers - Mask Connectionstring by default in Import Settings dialogbox by default (and give option to unmask)
NEW: All Drivers - More than 655 columns throws error about FillWeight
NEW: API Driver - Add Support for META clause
NEW: API Driver - Reset Table dropdown only when you leave Tab not clicking any where outside tab (e.g. Generate SQL Button)
NEW: Data Gateway - Add support for SSL / TLS Encryption for Secure TDS Protocol
NEW: Data Gateway - Provide IP / Range Block / Allow Feature (with Last Successful / Failed Login Attempt Indication)
NEW: Data Gateway - Support Dynamic SQL using Exec AT with parameters
NEW: General - Add Online page for SQL UDF
NEW: Installer - Rename License Manager to ODBC License Manager
NEW: Salesforce Driver - Multi statement support

Bug fixes

FIX: All API Driver - Quote symbol issue in SQL generation
FIX: All API Drivers - ConvertFormat has no effect if you set via UI
FIX: All API Drivers - Enable Custom Replace is not working when you set options from UI (however setting options in WITH clause works fine)
FIX: All API Drivers - Extra unwanted columns produced in some extended queries when * is used (provide * + const\expr columns support)
FIX: All API Drivers - Function names with builtin operator cause issue
FIX: All API Drivers - Headers grid is not reset after loading new Connection String
FIX: All API Drivers - Looks like if you use more than 8 parameters then you get error
FIX: All API Drivers - Pagination from Custom Header throwing error if you use EnablePageTokenForBody (i.e. use of [$pagetoken$] in body)
FIX: All API Drivers - Placeholder functions not working in URL (fails only if column type is numeric)
FIX: All API Drivers - Quote Symbol issue in ConnectionString generation
FIX: All API Drivers - When Connection String contains RequestData='[$tag$]' it removes brackets when you load connection string
FIX: All API Drivers - When same attribute name supplied multiple times in WITH clause, you might get misleading error
FIX: API Driver - Changing settings on UI (e.g. Connector File) doesnt reload Table dropdown on Preview Tab
FIX: API Driver - do not detect string as Int32 / Int64 (i.e. { id: "123" } JSON should be treated as string if in double quotes)
FIX: API Driver - Floating numbers are failed to parse for non English environment (i.e. Finland) - e.g. Number "1.267662916E9" failed with error Cannot convert [1.267662916E9] to [Double]
FIX: API Driver - New values not updated - Table dropdown reset based on old connection
FIX: API Driver - Show user friendly message when value is too large o fit - e.g. Int32 field may throw - Value was either too large or too small for an Int32.
FIX: CSV Driver - User may get unclear error if different value type detected after 300 rows - Input String is not in correct format error
FIX: Data Gateway - Many parallel connection can cause License not found error
FIX: Data Gateway - Multiple connections from the local device sometimes throws CAL error (if 127.0.0.1 is reported as local IP along with 192.xxx)
FIX: Data Gateway - When column name is great than 128 chars you may see odd error - Deferred prepare could not be completed
FIX: General - Function search by name not working in example browser
FIX: General - Undo is not possible after using query from Query Builder in Preview
FIX: JDBC Bridge Driver - NULL schema name cause issue with Power BI
FIX: JDBC Bridge Driver - On some queries you get error - Pipe is broken
FIX: JDBC Bridge Driver - You may get error "Host Process Broken" if data contains certain datatype
FIX: JSON Driver - Regex is truncated when loading the connection
FIX: Salesforce Driver - Query with SOURCE and WITH using wrong order throws object reference not set error rather than Grammer error
FIX: XML Driver - Error in OpenQuery when Nested query is used with BASE64 decode function

Version 1.4.1.10520 [May 21, 2021]

New Features/Improvements

NEW: Salesforce Driver - Enable Parallel Processing by default (Adjust MaxParallelThreads = 6)
NEW: Salesforce Driver - Update examples to include Bulk API, Parallel Processing and more

Bug fixes

FIX: All API Drivers - OAuth for Google Provider throws error about Certificate Path

Version 1.4.0.10518 [May 19, 2021]

New Features/Improvements

NEW: API Driver - Easy to use Driver to Read / Write data from Popular Online Data Sources - Inbuilt support for Google Sheets, BigQuery, JIRA, SharePoint Online, Amazon MWS, Zoho, Zendesk, OData - Download more connector files from online library
NEW: All API Drivers - Add better validation message when URL JOIN doesnt have alias defined
NEW: All API Drivers - Add new option MetaScanMode to define how metadata should be detected (i.e. Guess1x, Guess10x, Max String, Blob String and few more Mode)
NEW: All API Drivers - Add Support for create / edit Virtual Table with UI (Similar to Query Builder to construct custom settings)
NEW: All API Drivers - Add support for META clause in URL JOIN
NEW: All API Drivers - Allow [$body$] placeholder in String to Sign in HMAC / HASH Authentication Type to allow HASH function like SHA256(body+timestamp+secret)
NEW: All API Drivers - Allow custom replace before document is parsed (useful to remove / replace some characters in source data)
NEW: All API Drivers - Allow to export full setting of DSN (including Virtual Table / Metadata / Stored Procs)
NEW: All API Drivers - Give an option (EnableMultiPathMode) to treat SRC attribute as List of URLs / File Paths (separated by :: or {newline} ) - This allows UNION style feature to aggregate results from multiple URLs which has mostly similar structure
NEW: All API Drivers - Google Service Account support (Use of Private Key - P12 Files)
NEW: All API Drivers - Implement simpler META syntax - e.g. col1=string(10); col2=int,col3=numeric(18, 5)
NEW: All API Drivers - In URL Join allow to pass Parent Column Value in Header (i.e. join1_Header='x-hdr1: [$a.some_parent_col$]'
NEW: All API Drivers - Meta data UI improvements
NEW: All API Drivers - Retry 301 redirect Unauthorized requests for same domain and if new url is secure (i.e. https://)
NEW: All API Drivers - Significant Performance improvement for advanced queries (i.e. using WHERE, GROUP BY, ORDER BY) which returns more than 100000 rows
NEW: All API Drivers - Use Guess4x mode for Metadata scan rather than Guess1x
NEW: All Drivers - Do not convert Long to String (This was done to support legacy apps like old excel but no more issue in latest excel)
NEW: Amazon S3 Drivers - Add new Properties ForcePathStyle and ServiceURL to support S3 Protocol based 3rd party API services (i.e. Mini IO, Veritas, Ceph ...)
NEW: Data Gateway - Add new data source should open Edit UI (right now you have to click Edit manually)
NEW: Data Gateway - Display Version Number on Gateway UI
NEW: Data Gateway - Provide a way to use length rather than VARCHAR(MAX) for String type
NEW: General - Add new SQL Functions FILE_READ_TEXT / FILE_READ_BINARY to read text data or binary data from disk file
NEW: General - Improve logging (in some case error message not sent back to caller and its not logged in Debug Log mode)
NEW: General - Modify installer to create license folder with correct permissions for all to prevent license related issue when running product under non-admin account
NEW: General - Redesign Examples UI - Add features like group by category, preview SQL and description, search, syntax highlighting and more
NEW: JSON, XML Driver - Add options (EnableRawOutputModeSingleRow and RawOutputDataRowTemplate) to wrap response under special template (i.e. { data: [ ] } ) - Useful for case when you have to filter root level using JSONPath (i.e. [?(@code=='1')] )
NEW: JSON, XML, CSV Driver - Add Support for Custom SSL/TLS (Allow modern encryption ciphers for Older OS such as Windows Server 2012R2)
NEW: Salesforce Driver - Add Support for Bulk API
NEW: Salesforce Driver - Add Support for Bulk input from File (Insert, Delete, Update, Upsert values from File rather than static values)
NEW: Salesforce Driver - Add support for Bulk Update / Delete / Insert using ConnectionString (ODBC, SQL, OLEDB)
NEW: Salesforce Driver - Add Support for ContinueOnError in Insert / Update / Delete / Upsert for BULK
NEW: Salesforce Driver - Add support for EnableBulkMode, EnableParallelThreads, MaxParallelThreads in WITH clause
NEW: Salesforce Driver - Add Support for HTTP Proxy (Web Proxy using URL)
NEW: Salesforce Driver, API Driver - Change behavior so Output = 1 (ON) by default for CRUD Operations (INSERT, UPDATE, DELETE)

Bug fixes

FIX: All API Driver - Virtual Table changes are not saved and Prompt should say "Do you like to save changes?" rather "would you like to discard changes?"
FIX: All API Drivers - CertificatePassword is not treated as secret when generating SQL
FIX: All API Drivers - Create Custom Proc writes duplicate "CREATE PROCEDURE [XXXXXXX] AS" in default code
FIX: All API Drivers - Deleing unsaved Virtual Table or Stored Proc throws object reference not set error
FIX: All API Drivers - Deleting unsaved Stored Proc calls Compile operation
FIX: All API Drivers - Extended mode queries (with WHERE / GROUP BY) might show Quoted Columns
FIX: All API Drivers - Extended mode SQL issue when you specify column which doesnt exists
FIX: All API Drivers - Extended query throws error if you use expression and you have META clause defined - You may see error like expr_1 not found
FIX: All API Drivers - For extended queries or META clause use you may get error on some culture (i.e. Finland) - Parser error: String was not recognized as a valid DateTime.
FIX: All API Drivers - Length from META clause is ignored for extended SQL queries
FIX: All API Drivers - Length reported incorrectly by .net GetSchemaTable function
FIX: All API Drivers - Loading Full Setting throws error for New Data source
FIX: All API Drivers - Loading Full Setting with Custom Objects on new data source does not refresh UI
FIX: All API Drivers - Metadata detection reports exact length for string when only one sample row found (It should detect 4 times bigger for string types to cover data coming after 300 rows)
FIX: All API Drivers - Metadata operation fails if column / expression contains Byte array
FIX: All API Drivers - Pagination Tab trimmed some label text
FIX: All API Drivers - Provide a better error message when extra columns detected in SELECT which is not found in META list
FIX: All API Drivers - Save Stored Proc Removes placeholders from Proc Body on refresh
FIX: All API Drivers - Some SQL UDF (User defined function) doesnt return null if one or more input arguments are null
FIX: All API Drivers - Stored Procs with Parameters used inside Placeholder function not replaced correctly (It should replace Inner Parameter first and then call replace Placeholder but its doing other way around)
FIX: All API Drivers - Unable to cast object of type 'System.String' to type 'System.Byte[]'
FIX: All API Drivers - URL JOIN allow child with zero rows (after META clause defined)
FIX: All API Drivers - URL JOIN doesnt throw error if SELECT clause reference column which is not found in META
FIX: All API Drivers - URL JOIN doesnt understand metadata from file path (Embedded meta works fine)
FIX: All API Drivers - When CachingMode=All is set and you try to preview query on UI you may get - Object reference not set error on 2nd execution
FIX: All API Drivers - When you use Cache feature with CacheMode=CacheAll setting then it hangs on extended queries
FIX: All CSV Drivers - Custom date format option is not working
FIX: All Drivers - App - SSIS: In 2019 you might get error at runtime - Add support for SQLFetchScroll Feature
FIX: All Drivers - String more than 2000 characters are corrupted (Data fetch via Data Gateway works fine)
FIX: All JSON, XML Drivers - If you upload Body from File then Select Filter Option throws error (Because file content not posted as body)
FIX: App - Informatica Developer (JAVA Based IDE with Model Repository) detects integer column with Precision 1 which causes validation errors
FIX: CSV Driver, API Driver - When first row is blank and next row has number it detects datatype as String rather than number
FIX: Data Gateway - Clicking Cancel on UI warns about unsaved data
FIX: Data Gateway - Configuration not reloaded (renamed data set keep old entry)
FIX: Data Gateway - Jdbc Bridge driver crash to load when you edit Data Source on Gateway UI
FIX: Data Gateway - Process gets terminated on unhandled error in driver
FIX: Data Gateway - Restart option causes Timeout error some times (Start / Stop works fine)
FIX: Data Gateway - SELECT INTO with META clause cause Object reference not set error
FIX: Data Gateway - Service crash on certain unhandled exception and no error is logged
FIX: Data Gateway - Service might crash if parallel commands detected (e.g. TOP clause used with OPENQUERY)
FIX: General - After selecting example you cannot do Undo (Ctrl + Z)
FIX: General - Allow to set 0 / 1 for Bool type Parameters (Right now it must be set with True / False keyword)
FIX: General - Fix C# Example on code generator Tab
FIX: General - Scaling Issue with UI with HTTP Request (Edit Body button hidden)
FIX: JDBC Bridge Driver - Apps - Power BI - Data import in Table mode fails due to Quoted identifiers issue when Column name contains space or special character (i.e. dash or dot)
FIX: JDBC Bridge Driver - Executing DDL / DML Statements (i.e. CREATE, DROP, INSERT, UPDATE) fails with error - No results were returned
FIX: JDBC Bridge Driver - Tables are reported as Views
FIX: JSON Driver - After changing value in Advanced Grid when you edit connection you might get error
FIX: JSON Driver - Cache causing Issues with Nested SQL Scenarios
FIX: JSON Driver - Long Integers are not Returning Correctly with URL JOIN Queries
FIX: JSON, CSV, XML Driver - Custom Stored proc fails when SELECT INTO temp table used along with URL JOIN feature
FIX: Salesforce Driver - App - Power BI fails to import data in Table mode
FIX: Salesforce Driver - App - SSIS - Throws metadata validation error at runtime (Due to Quoted SQL sent by SSIS engine - SQL_IDENTIFIER_QUOTE_CHAR setting of ODBC Driver is ignored in SSIS)
FIX: Salesforce Driver - Bad requests not failing (i.e. INSERT duplicate row is not failing)
FIX: Salesforce Driver - Connections are opened multiple times and not reused
FIX: Salesforce Driver - Error is not reported correctly by driver in some cases
FIX: Salesforce Driver - Preview window might crash without error in some cases (e.g. Bad Table name in INSERT / UPDATE / DELETE )
FIX: Salesforce Driver - Set String length to Max length if Length=0
FIX: Salesforce Driver - Table list not populated
FIX: Salesforce Driver - UPDATE doesnt set column to NULL if you use SET Column=null (Instead of NULL it set to string "null" )
FIX: Salesforce Driver - You might get error when you read Binary date (i.e. Body field in Attachment table) - Error : Requested value 'Byte[]' was not found.
FIX: XML Driver - 0000 string truncated to 0
FIX: XML Driver - If response is blank - You might get error - Root element is missing even though you set META
FIX: XML/JSON/CSV Driver - Page Start Number doesn't accept 0 and gets reset to 1

Version 1.3.0.10909 [Sep 16, 2020]

New Features/Improvements

NEW: JDBC Bridge Driver - New driver allows to read data using any JDBC driver in ODBC Apps or SQL Server via Gateway
NEW: All API Drivers - Add Advanced Pagination Options on UI
NEW: All API Drivers - Add optional Parameter (3rd Argument) in json_value function to Throw Error when no match found for supplied JSON Path Expression
NEW: All API Drivers - Add support for EnableBodyCompression
NEW: All API Drivers - Allow File Upload Request in AWS API Provider (IsMultiPart=True)
NEW: All API Drivers - Allow to use Placeholder functions in URL JOIN (e.g. [$alias.somecolumn,FUN_TRIM$] )
NEW: All API Drivers - HTTP Connection - For Dynamic Token option when Auth Scheme contains space do not suffix another space (e.g. MyAuthScheme sess-id=)
NEW: General - Add support to check for Product Update
NEW: General - Some unhandled exceptions on UI not caught
NEW: General - Enforce License manager to run as Admin to avoid license activation issues
NEW: General - Add new functions LOWER, UPPER, FUN_UNIX_TIMESTAMP_TO_DATE (When input is Seconds format) and FUN_UNIX_TIMESTAMP_MS_TO_DATE (When input is Milliseconds format)
NEW: All API Drivers - HTTP Connection - Allow option to set DynamicToken request as Form-Data (Multi-Part) request
NEW: XML Driver - Add Culture Option - Support for parsing Culture Specific Numbers (e.g. in Finland - 1000,50 should be treated as decimal)
NEW: All API Drivers - Allow to pass non standard date format for If-Modified-Since Header (Xero API Usecase) - suffix date value with -raw to allow custom format (i.e. If-Modified-Since : 2020-12-31-raw)
NEW: All API Drivers - OAuth Connection - AWS v4 Provider - Allow to Supply Custom Region

Bug fixes

FIX: All API Drivers - Various drivers using ISO date formats may use wrong date format for some cultures where Time Separator is dot (i.e. Finland Culture fi-FI)
FIX: All API Drivers - Add support for functions in ORDER BY Clause
FIX: All API Drivers - Always first parameter value is used in custom stored proc
FIX: All API Drivers - Column DataType is detected as String When first value in first row is NULL
FIX: All API Drivers - DROP PROCEDURE statement doesn't remove Stored Proc from Storage
FIX: All API Drivers - For certain Regional Settings (e.g. Finland) you might get error - Parser error: String was not recognized as a valid DateTime
FIX: All API Drivers - IncludeParentColumns , TreatBlankXXXXAsNull Options not saved when you close UI
FIX: All API Drivers - Milliseconds part is removed from extended query output
FIX: All API Drivers - On Preview Tab - You may get error when you click on Table dropdown - Value cannot be null - Parameter name: first
FIX: All API Drivers - Prompt for unsaved changes on Custom Objects UI
FIX: All API Drivers - SupportCompression setting not saved
FIX: All API Drivers - User running fragments of SQL assuming it runs full SQL and got error expected : EXEC, DROP, CREATE, SELECT, INSERT, UPSERT, UPDATE, DELETE, ;
FIX: All API Drivers - When input is NULL for Regex_Search then it should return NULL rather than Blank String
FIX: All CSV Drivers - Column Delimiter is not Saved if you enter custom value (other than found in dropdown)
FIX: All Drivers - OdbcConnection GetTables method doesnt work
FIX: All Drivers - When you use custom Meta String Type column it may return numeric data in Culture Specific Format rather than Invariant format (e.g. for Finland Region it may return 1234,50 rather than 1234.50)
FIX: CSV, XML Driver - In some cultures (e.g. Finland) Decimal type is detected as String
FIX: Data Gateway - You might get error "Protocol Error in TDS stream" with Large Files (More than 40MB)
FIX: General - SQL UDF not throwing error in some function when its desired (e.g. Invalid File Path should throw error)
FIX: JSON Driver - Order By is not working while reading local file
FIX: JSON Driver - Clicking on Table dropdown on Preview Tab might throw error - Value cannot be null. Parameter name: first
FIX: XML Driver - Parsing Decimal might throw error in Extended Queries - Input string was not in a correct format

Version 1.2.1.10511 [May 15, 2020]

New Features/Improvements

NEW: All API Drivers - Add new User Defined Functions bytes_to_base64, text_to_base64, base64_to_text and file_to_base64
NEW: All API Drivers - Add support for Virtual Table (So Apps like MS Access, Informatica can use table list from same DSN without creating new DSN for new URL EndPoint or other settings)
NEW: All JSON Drivers - Add Support for JSON Line Format (i.e. [1,"AAA"] [2,"BBB"] )

Bug fixes

FIX: All JSON Drivers - Column less array 2DArray Transform produces wrong number of columns
FIX: General - ODBC is missing SFTP CSV, Azure CSV and Salesforce Drivers from ODBC Administrator

Version 1.2.0.10428 [Apr 27, 2020]

New Features/Improvements

NEW: All API Drivers - Add Custom Stored Procedure support (With Compiled Metadata support for faster performance)
NEW: All API Drivers - Add support for count(*)
NEW: All API Drivers - Add support for multi statements
NEW: All API Drivers - Add Support for Placeholder functions in HTTP Dynamic Token Request (i.e . Headers/Body/URL)
NEW: All API Drivers - Add support for temp tables (Save result into temp table and use in different query or in JOIN Syntax)
NEW: All API Drivers - Add two default headers Accept, Cache-Control
NEW: All API Drivers - Change IncludeParentColumns default to True
NEW: All API Drivers - Give option to pass content-type for multi-part upload request (Right now its guessed from file extension) - Google Drive Upload API Usecase
NEW: All API Drivers - OAuth Connection - Detect changing refresh token pattern and prompt to define file path on generate token click
NEW: All API Drivers - OAuth Connection - Implement External Browser Token Extract (Need this feature for APIs like Google which stop supporting Embedded Browser in App)
NEW: All Drivers - Allow to use Placeholders any where in Query Text (e.g. select * from $ WITH(Src='http://httpbin.org/get?id=2020-04-27') )
NEW: All JSON Driver, All XML Driver - Support Custom column list in Complex 2D Transform
NEW: Data Gateway - Add correct message in TDS response when no license found (it sends "Client unable to establish connection due to prelogin failure".)
NEW: Data Gateway - Improve Gateway Log (Added IP, Query Time, UserID, DB Name, SessionID, CPU %, Memory and more )
NEW: Data Gateway - Provide a clear indication which IPs using Gateway connections when license error is thrown
NEW: Data Gateway - Use of invalid catalog name can throw confusing error in SQL Linked server
NEW: General - Provide confirm dialog box before overwrite DSN with same name on config save

Bug fixes

FIX: All API Driver - Extended Query report Int32 data as Int64
FIX: All API Drivers - After entering URL in the path if you browse path it will not show local files
FIX: All API Drivers - Alias doesn't work for nested sub query
FIX: All API Drivers - AWS v4 Signature Provider doesnt work when you have URL like https://something.execute-api.eu-central-1.amazonaws.com/part1/part2/somename
FIX: All API Drivers - Changing Headers in Grid mode doesnt save when you close UI
FIX: All API Drivers - Escape Sequence issue for single quote in WITH clause
FIX: All API Drivers - Invalid meta entry name cause path not found error
FIX: All API Drivers - OAuth Connection - Retry option cause issue with Amazon MWS API
FIX: All Drivers - Driver name attribute is treated as case-sensitive
FIX: Amazon S3 Drivers (CSV, XML, JSON), Azure Blob Xml Driver - You may get error for - Rebex.Zip dll is missing
FIX: Amazon S3, Azure Blob, SFTP Drivers - Source Path hint is wrong - Change http:// in path to /myfolder to avoid confusion
FIX: Apps - MS Access - Selecting Primary Key field for Linked table fails
FIX: Data Gateway - CAL Limit error from multiple connection from same IP
FIX: Data Gateway - When CacheAll is enabled you may get zero rows in some cases if META clause used
FIX: Data Gateway - When CacheAll setting is On you may get Object reference not set error
FIX: Distinct doesnt work if WHERE clause / GROUP BY / ORDER BY not used
FIX: General - Help file doesnt show all examples
FIX: General - Installer doesnt prompt UAC in some cases
FIX: Informatica - nvarchar columns are loaded with scale > 0 causing issue in informatica developer IDE
FIX: JSON Driver - You may get error - Value was either too large or too small for an Int64
FIX: JSON Driver, XML Driver - When you select sub document as filter (e.g. $docs[*].info ) rather than array node (e.g. $docs[*] ) it may output NULL values
FIX: REOPEN-Data Gateway - Error not thrown back correct way
FIX: Salesforce - WHERE clause filter on DateTime field is not supported (i..e LastModifiedDate field)
FIX: Salesforce Driver - You may get error on Bool datatype
FIX: You may get error when you use URL JOIN - Input string was not in a correct format.

Version 1.1.4.10904 [Sep 11, 2019]

New Features/Improvements

NEW: All Drivers - New DSN dialogbox should suggest unique DSN name if already exists (Prevent accidental overwrite)
NEW: All Drivers - Add support for named parameters for stored procs (e.g. exec webrequest @uri='https://abc.com' )
NEW: Data Gateway - Give Export / Import Settings option
NEW: Data Gateway - Provide list of database to caller App
NEW: General - Use default log file name if only folder name is supplied
NEW: Salesforce Driver - Add Placeholder Engine Support

Bug fixes

FIX: All API Drivers - Query builders shows Password and Default Attributes on first time launch
FIX: All API Drivers - RetryInfo not included in Connectionstring or generated SQL
FIX: All API Drivers - URL JOIN may cause error for decimal values - Query execution error: Input string was not in a correct format.
FIX: All API Drivers - URL on general tab is wiped out when you use save HTTP Connection
FIX: All API Drivers - Field names are wrong StatucFieldxxxxxxx and StatucCheckxxxxxx rather than StatusCheckxxxxxx and StatusFieldxxxxxxx
FIX: CSV Driver - JOIN query fails in CSV driver with invalid format detected
FIX: Data Gateway - MS SQL Server - Support more than 2000 characters for SQL in OPENROWSET and EXEC - In old version you may get error - Data is invalid if text is longer than 2000 characters
FIX: Data Gateway - Query with Caching Option hangs
FIX: Data Gateway - Use of META in WITH clause prevents error in some cases
FIX: Data Gateway - You may get "The data is invalid" error when the query is too long
FIX: Data Gateway - You may get Data is invalid error for OAuth Authorization failure
FIX: Salesforce Driver - When you execute INSERT via Linked Server Query it Inserts row but fails with error at the end
FIX: Salesforce Driver - Load ConnectionString action throws Object reference not set to an instance of an object.
FIX: Salesforce Driver - Click on Generate SQL throws Object reference not set to an instance of an object
FIX: Salesforce Driver - Data is not returned in Excel when you use [From Microsoft Query] option
FIX: Salesforce Driver - DELETE statement not working
FIX: Salesforce Driver - Escape sequence not supported (e.g. WHERE name ='Sam\'s' )
FIX: Salesforce Driver - OPENQUERY / EXEC AT doesn't work with DELETE / UPDATE / INSERT
FIX: Salesforce Driver - SSIS Failed to Generate Metadata due to character encoding issue
FIX: Salesforce Driver - Using * in SELECT with WHERE is not working

Version 1.1.3.10621 [Jun 24, 2019]

New Features/Improvements

NEW: Add option to replace placeholders in File content if you use IsMultiPart = True
NEW: All API Drivers - Add option EnableBodyPlaceholderForMultiPart to support replacing placeholders in file content in IsMultiPart mode (E.g. replace <%access_token%> or [$token$] or [$alias.MyJoinColumn$] )
NEW: All API Drivers - Add option OutputAsRawDocumentSingleRow (Returns __DOCUMENT__ field with entire File / Response string in one field)
NEW: All API Drivers - Add Options to parse from any unstructured data - RawOutputExtractMode, RawOutputDataRowTemplate, RawOutputFilterExpr
NEW: All API Drivers - Add Status Check feature for all API drivers (Keep sending request until desired value found) - Options added EnableStatusCheck, StatucCheckMaxWaitSeconds, StatucCheckIterationWaitSeconds, StatusSuccessValue, StatusFailureValue
NEW: All API Drivers - Add support for ConnectionType in URL Join
NEW: All API Drivers - Add Support for HMAC Authentication
NEW: All ODBC Drivers - Add support for Parameters
NEW: Data Gateway - Add Code Generator UI for SQL / Java
NEW: Data Gateway - Allow to add firewall rule via UI
NEW: Data Gateway - Better logging about connected devices
NEW: Salesforce Driver - Add support for Select * FROM

Bug fixes

FIX: All API Drivers - joinXX_DataConnectionType Option not supported in JOIN URL
FIX: All API Drivers- Show meaningful error when same option used twice in WITH clause (Right now you see odd error - An item with the same key has already been added)
FIX: Apps - Informatica - Driver may output many extra empty rows in some cases
FIX: Apps - MS Access - Linked table throwing call fail error (due to missing support for parameters in current driver)
FIX: Data Gateway - Certain errors not reported correctly back to caller
FIX: Data Gateway - Enabling caching options may hang query in some case
FIX: Data Gateway - Generic ODBC Connection Type fails with error Connection is Busy
FIX: Data Gateway - When you use Meta option in WITH clause you may see empty rowset rather error in some cases
FIX: Salesforce Driver - Can not load table list in Excel / Power BI
FIX: Salesforce Driver - Failed to preview data in Power BI
FIX: Salesforce Driver - Load ConnectionString doesnt set Username
FIX: Salesforce Driver - Nested queries not supported - You may get syntax error
FIX: Salesforce Driver - SSIS ODBC destination showing bad Table names in list

Version 1.1.0.10423 [Apr 26, 2019]

New Features/Improvements

NEW: All API drivers - Support Zip File when reading from URL (Right now only Gzip supported for URL)
NEW: Amazon S3 driver for CSV - New driver to query CSV / TSV files stored on AWS S3 Service (Zip / GZip supported)
NEW: Amazon S3 driver for JSON - New driver to query JSON files stored on AWS S3 Service (Zip / GZip supported)
NEW: Amazon S3 driver for XML - New driver to query XML files stored on AWS S3 Service (Zip / GZip supported)
NEW: Azure Blob driver for CSV - New driver to query CSV / TSV files stored on Azure Blob Storage Service (Zip / GZip supported)
NEW: Azure Blob driver for JSON - New driver to query JSON files stored on Azure Blob Storage Service (Zip / GZip supported)
NEW: Azure Blob driver for XML - New driver to query XML files stored on Azure Blob Storage Service (Zip / GZip supported)
NEW: General - Shorten default Datasource name if its more than 32 characters long
NEW: Salesforce driver - New driver to read / write data on Salesforce.com CRM (SOQL Query and Table Mode)
NEW: SFTP driver for CSV - New driver to query CSV / TSV files stored on FTP Server using SFTP, FTPS, Classic FTP Protocols (Zip / GZip Compression supported)
NEW: SFTP driver for JSON - New driver to query JSON files stored on FTP Server using SFTP, FTPS, Classic FTP Protocols (Zip / GZip Compression supported)
NEW: SFTP driver for XML - New driver to query XML files stored on FTP Server using SFTP, FTPS, Classic FTP Protocols (Zip / GZip Compression supported)

Bug fixes

FIX: All - API Drivers - Pagination doesn't work if page number starts other than 1 in URL Parameter Mode
FIX: All API Drivers - Case Statement not working
FIX: JSON Driver, XML Driver - You may get OutOfMemory Exception with --FAST option in filter

Version 1.0.18.10215 [Feb 14, 2019]

New Features/Improvements

NEW: All API Drivers - Add support for schema in the column list (SELECT Clause) - Tools like SSRS Query builder generates 3 parts column names
NEW: All API Drivers - Provide an option to retain Cookies in HTTP Connection for Dynamic Token Approach (e.g. SAP Usecase)
NEW: All API Drivers - Show NULL values in different colors in Preview Grid (Currently Blank and NULL both shows empty cell)

Bug fixes

FIX: All API Drivers - You may get error when first column in SQL is static value - Error expected: number, string, x, NULL,
FIX: All API Drivers - Long string values not displayed in preview grid
FIX: All API Drivers - Pagination may not work correctly for URL Path Mode if StartPage is other than 1
FIX: All API Drivers - Pagination with Custom Increment not working
FIX: All API Drivers - Start Page Number is not saved when you close UI
FIX: XML Driver - When you use 2D Transform - You may get Newtonsoft.Json.Linq.JObject' to type 'System.IConvertible if self closing nodes encountered

Version 1.0.17.10125 [Feb 14, 2019]

Bug fixes

FIX: All API Drivers - You may get do you want to save message on cancel when path is file
FIX: Informatica - You may see junk characters in the output when blank data is encountered

Version 1.0.16.10117 [Jan 17, 2019]

New Features/Improvements

NEW: All API Drivers - Add support for SQLExtendedFetch for some applications which support older ODBC version
NEW: All API Drivers - Logging enhancements

Bug fixes

FIX: All API Drivers - You may get error - Reading data timed out Timeout for large files or server takes longer to reply
FIX: Data Gateway - If you click OK / Cancel without save you may lose your dataset settings
FIX: Data Gateway - Is Admin checkbox is not saved on Users tab
FIX: Data Gateway - Provide a valid error message when user has insufficient privileges to access datasource

Version 1.0.15.11226 [Jan 14, 2019]

New Features/Improvements

NEW: All API Drivers - Add Sleep SQL function (e.g. select sleep(3000) wait3Sec From $ )
NEW: Apps - Talend - Data Gateway does not work with MS SQL JDBC in talend open studio
NEW: JSON, XML Driver - Move Array Flattening Feature to Advanced Filter Options to avoid confusion with filter property
NEW: JSON, XML, CSV Driver - Add Support for Multi-Part Content
NEW: JSON, XML, CSV Driver - Add support to pass dynamic content to JOIN_DATA property (Usecase - Query XML CData / JSON stored as string)

Bug fixes

FIX: All API Drivers - JOIN Query may hang when full data cache is enabled
FIX: All API Drivers - JOIN Query Performance Improvement (parse metadata for only first URL rather than every URL in the group)
FIX: All API Drivers - Nested JOIN queries always use Parent Filter even though you do not set child URL Filter
FIX: All API Drivers - Query preview may throw error - Table xxxxxx already exists
FIX: All API Drivers - Save Metadata to File should use SaveAs dialog rather than File Open
FIX: All API Drivers - TTL for DataCache is not working
FIX: Apps - Informatica - Cloud version reads extra row from ODBC driver
FIX: Apps - Informatica - In some cases you may get error - Index was outside the bounds of the array
FIX: Apps - Informatica - Sometimes you may see many NULL rows and invalid column order (ExtendedFetch Improvements for ODBC v2)
FIX: Apps - MS Access - Some times you may get error (-7766) importing data
FIX: Apps - SSRS - Clicking execute in Query Builder may crash Visual Studio
FIX: Data Gateway - Boolean value may throw - Protocol error in TDS Stream
FIX: Data Gateway - Show meaningful error when Wrong catalog / credentials supplied
FIX: Data Gateway - Throw useful syntax errors rather than generic error TCP Provider: An existing connection was forcibly closed by the remote host.
FIX: Data Gateway - You may get Protocol error in TDS stream if duplicate column names found (e.g. Id, ID)
FIX: General - Pressing Escape closes Driver UI without saving changes
FIX: General - Sometimes you may get wrong datatypes after changing data caching mode (specially DateTime type)
FIX: JSON, XML Driver - Enable Array Flattening option may return NULL values for nested properties

Version 1.0.14.11107 [Nov 07, 2018]

Bug fixes

FIX: CSV Driver - You may get error - Option 'hascolumnheaderrow' is not supported
FIX: Data Gateway - Show meaningful error when Wrong catalog specified
FIX: Data Gateway - Some data causes error in MS SQL
FIX: Data Gateway - SQLNCLI11" for linked server "ZS_GATEWAY_AZ" supplied inconsistent metadata for a column. The name was changed at execution time
FIX: Data Gateway - ZsXml option throws error in Gateway - ZappySys.Odbc.Xml.dll' or one of its dependencies. An attempt was made to load a program with an incorrect format.
FIX: JSON, XML Driver - 2D Transform MultiColumnExpression Parser Error - Given Key was not present in dictionary
FIX: JSON, XML, CSV Driver - Enhance Regex function and examples (Add condition to search specific occurrence / group, ignore case)
FIX: JSON, XML, CSV Driver - HTTP Grid is disabled if HTTP Method is blank
FIX: JSON, XML, CSV Driver - HTTP Headers not saved (when more than one header entered in UI)
FIX: JSON, XML, CSV Driver - SQL Function with more than 4 parameters fails
FIX: JSON, XML, CSV Driver - Table list in not refresh in preview window after changes in grid

Version 1.0.0 [Dec 1, 2017] (Initial Release)

This is the first release of SSIS PowerPack which includes following tasks and components

NEW: JSON Driver - JSON driver can read data from local files or Web API (REST, OData). Using this driver you can write Query in familiar SQL language and query nested structure / output as flat table.
NEW: XML Driver - XML driver can read data from local files or Web API (REST, SOAP, OData). Using this driver you can write Query in familiar SQL language and query nested structure / output as flat table.
NEW: ZappySys Data Gateway - Using tight integration with Microsoft SQL Server you can easily query XML/JSON or API inside your T-SQL code.