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 - 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 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 - 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 - 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 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