NEW: All Components - Improve loading speed for columns tab
NEW: API Connector - Asana - Added new tables / endpoints: SubTasks, WorkspaceTasks, get_subtasks, get_workspace_tasks and search_tasks endpoints (Advanced Serverside Filter)
NEW: API Connector - Asana - Enabled pagination for all endpoints to avoid error: The result is too large. You should use pagination
NEW: API Connector - Google Ads - Read / Write Google Ads Account data (e.g. Campaigns, Keywords, Performance Metrics using GAQL)
NEW: API Connector - Google BigQuery - Added support for JSON Key file in Service Account authentication
NEW: API Connector - Google BigQuery - Expose timestamp column as DateTime (Alternate way to insert data in TIMESTAMP column)
NEW: API Connector - Google Calender - Added support for JSON Key file in Service Account authentication
NEW: API Connector - Google Drive - Added list_parent_items endpoint to search under a specific folder or do recursive scan for a specific file types
NEW: API Connector - Google Drive - Added support for JSON Key file in Service Account authentication
NEW: API Connector - Google Drive - Added upload_file_overwrite endpoint with option to overwrite / fail file if exists
NEW: API Connector - Google Sheets - Added support for JSON Key file in Service Account authentication
NEW: API Connector Framework - Add new option SkipBlankHeader (By default blank value is passed to header)
NEW: API Connector Framework - Allow parent row values in child endpoint parameter value attribute and in Body attribute if Param is set with PushToChildEndPoint=true (e.g. <Param Value="[$parent.somecolumn$]" .... or Body="[$parent.somecolumn$]" )
NEW: General - Add new function FUN_CALC (e.g. <<1|~|Add|~|5,FUN_CALC>> )
NEW: General - Add Q, QQ, QQQ, QQQQ (Quarter 4, 04, Q4, 2015-Q4) and WK (Week Number) format specifiers for TO_DATE and TO_DATETIME functions
NEW: General - FUN_SEQUENCE - Allow to set sequence name and also allow to reset sequence
NEW: General - New Placeholder function FUN_THROW_IF (Throw error if condition match)
NEW: General - New placeholder functions FUN_PROPERCASE (e.g. [my name] to [My Name])
NEW: Google Analytics Source - Add support for JSON Key file format for private key in service account access mode
NEW: OAuth Connection Manager - Add support for JSON Key file in Google Service Account Option (*.json / *.p12 file extensions now supported)
NEW: REST API Task - Check Status Tab - UI Issue - Notes text is getting cut off
NEW: Secure FTP, Advanced File Storage, Amazon Storage (S3), Azure Storage Task - Add support for placeholder function to make WhereClause dynamic (e.g. LastModifiedDate > #{{User:varMyDate}}# )
NEW: Secure FTP, Advanced File Storage, Amazon Storage (S3), Azure Storage Task - Correct date format in advanced filter examples to use standard date format rather than localized format (e.g. use #yyyy-MM-dd# or #yyyy-MM-dd HH:mm:ss# insted of #mm/dd/yyyy# )
NEW: Upsert Destination - Show warning about unused Auditing Outputs
Bug fixes
FIX: All Connection Managers - Scaling Issue (Test button, OK / Cancel buttons not visible)
FIX: All Source Components - Crash happens when editing Length on Columns Tab when Display Scaling is enabled at OS level (i.e. set other than 100% )
FIX: API Connection Manager - Changing OAuth Profile to Service Account Key cause error on UI when you hit Test Connection (Google Provider Use Case)
FIX: API Connector Framework - Direct placeholders are invoked before replacing parent row placeholders in Body (e.g. <<[$parent.some_col$],FUN_BASE64ENC>> )
FIX: API Connector Framework - ValueTemplate is not working when MultiSelect = True and Param Type is Default or Query
FIX: Google Analytics Source - Scaling Issue with Connection UI (Path cropped)
FIX: JSON / XML / CSV Source, REST API Task, Web API Destination - Passing blank value for If-Modified-Since header throw Object reference not set error
FIX: Salesforce Source - Bool, Integer, Numeric fields showing null when Bulk API Mode is turned on