In the past weeks, we've been focusing on improving workflows. Alongside introducing the ability to add URL parameters to Data schemas and authenticating with an SSH key in SFTP connectors, we also simplified working with Dataset options and building outputs by enabling the use of referenced values in Variables.



Overview

New features:

 

  • [Accutics Standardize] Managing dataset options within dependency variants
  • [Accutics Standardize] Adding URL parameters to Data schemas
  • [Accutics Standardize] SSH key authentication for SFTP connectors
  • [Accutics Standardize] Using values from a Reference in Variables


Others: 


  • [Accutics Standardize] Bulk table performance - Improved






Accutics Standardize

New

Managing dataset options within dependency variants

You can now create, edit, and delete options directly from the dependency variants tabs. This streamlines the process, eliminating the need to first create dataset options and then update dependencies. 



When adding allowed options for different dependency combinations:


Create a new dataset option

Click 'Add option' > 'Create new option' > Enter a value (and an abbreviation) > Enter


Edit an existing option

Simply click on a value > Edit it as needed > Enter


Delete an existing option

Click the more menu (...) next to the option > 'Delete'


Note: Deleting an option (trash icon) permanently removes it from the dataset. This affects all fields and dependencies where the dataset option was in use. 

Removing an option means removing it from 'Allowed options' in dependencies and it only affects that particular combination. 




Adding URL parameters to Data schemas

You can now enhance the granularity of the data you extract from Accutics by adding URL parameters as column values in Data schemas. Each parameter you add will have its own column in the export file.



Hence, from a Data schema:


  1. Choose a parameter column value

'Add column' > 'Choose value' > 'Parameter'


  1. Select the URL output containing the parameter

Only URL-type outputs will be listed. 


  1. Select the parameter

Upon selection of an output, all parameters used in a Build URL function will be displayed. Choose the one you want to include in the exports. 


Note: In case of duplicate parameters, the first instance is extracted or the one that fulfills the conditions that apply to the specific record.


Nested parameters

Only top-level parameters are listed. If more parameters are nested within another Build URL, they will not be displayed.


If the parameter you are looking for is indeed nested and hence, not listed, you can use the lookup function. 


Select 'Parameter lookup' > Enter the exact parameter name




SSH key authentication for SFTP connectors

You can now authenticate SFTP connectors using an SSH key. This means you can establish a secure connection for exporting data from Accutics without relying on individual users to have direct access to the server.

 


Here's how it works:


  1. Enable the use of SSH key when setting up an SFTP connector.

Simply check the 'Use SSH key instead of password' checkbox


  1. Download the public key

Upon enabling, a public key will be created. You need to import this to your SFTP server. 


  1. Validate connection in Accutics

Ensure the key works by filling in the remaining fields in the Connection section and clicking 'Validate'.


Note: 'Is this a secure file transfer protocol (SFTP)?' must be checked.




Using values from a Reference in Variables

You can now use referenced values within Variables when building Outputs. This allows for more flexibility and efficiency, as you can leverage the benefits of both Variables and Reference fields together.





Improved

Bulk table performance

We made performance improvements to the Bulk Create table. It's now significantly faster and smoother to work with, making it more efficient to create multiple records at a time.