HRIS Integration

hris integration teleskope platform has the capability of connecting with various hris systems to keep the data in sync teleskope supports hris integration by using a flat file processing mechanism benefits of using the hris integration existing user records in teleskope platform can be updated with new hris data new users can be added terminated users can be marked for deletion supported file types the file can be in csv or tsv (tab separated) format, with one row for each employee file transfer mechanisms supported by teleskope use teleskope uploader http post api to send the file stage the file on your sftp server and provide sftp credentials to teleskope key considerations separate files can be sent for active users and terminated users if a separate terminated user file is not sent, then users who are not found in active user file are marked as inactive and they will be deleted from the system after 30 days of inactivity one of the fields in the file should be unique employee identifier that is immutable, e g employee id or network id or email and it should match the unique identifier sent in sso saml nameid note any number of fields can sent teleskope can map the fields to extended attributes one of the field should be a unique immutable identifier (and should match sso saml nameid) file format specifications csv in order to process hris data contained in csv file, the file should follow the following specifications file name file name should not contain spaces and it should end with csv (case sensitive), e g activeusersforteleskope csv if file is pgp encoded then the file name should have pgp suffix, e g activeusersforteleskope csv pgp file encoding utf 8 file contents a header row is required to help teleskope system understand the field mappings each row should represent a user, and columns should represent values columns should be separated by commas in case the value contains a comma then the value should be enclosed in double quotes in case the value contains a double quote, then the contained double quote should be escaped by \ rows should be terminated with a newline empty values should be left empty example of the format given below &#x9; firstname,lastname,email,job title john,doe,john doe\@email com,sr manager jane,doe,jane doe\@email com,"sr director, operations" tsv in order to process hris data contained in tsv file, the file should follow the following specifications file name file name should not contain spaces and it should end with tsv (case sensitive), e g activeusersforteleskope tsv if file is pgp encoded then the file name should have pgp suffix, e g activeusersforteleskope tsv pgp file encoding utf 8 file contents a header row is required to help teleskope system understand the field mappings each row should represent a user, and columns should represent values columns should be separated by \<tab> in case the value contains a \<tab> then the value should be enclosed in double quotes, or escaped using \\ in case the value contains a double quote, then the contained double quote should be escaped by \ rows should be terminated with a newline empty values should be left empty example of the format given below &#x9; firstname lastname email job title john doe john doe\@email com sr manager jane doe jane doe\@email com sr director, operations file encryption customer can encrypt the file using teleskope's public pgp key encrypting the file adds another layer of security as it ensures the file can only be opened by teleskope teleskope's public pgp key can be downloaded from the link below https //archbee doc uploads s3 amazonaws com/sqf2vrgixvtfxjypqplfy wfsjg3crwfesxkykycish 20250625 130302 asc file transport teleskope uploader api this is the preferred transport mechanism as it provides the most secure and highly available mechanism in order to use this mechanism, get your uploader account url, username and api key from teleskope example to send a pgp encrypted active user file in csv format url https //subdomain teleskope io/1/eai/uploader?op=user data sync\&format=csv\&version=v3\&encryption=pgp username contact teleskope representative for username api key … a very long string… only http post mechanism is supported for enhanced security http get, put, and other operations are not supported on this system the api call is authenticated using http basic auth with api key passed as password customer provided sftp account the hris files can be staged it in your sftp server teleskope does not provide sftp server accounts, but we can pick up files from customer provided sftp server teleskope file pickup service will delete the file from sftp server on successful get additional consideration when sending files over sftp, the filename must be static and should not contain any variables, such as timestamps the file extension should match the contents, e g csv for csv formatted file, tsv for tsv formatted file if the file is pgp encrypted, then it should have pgp extension e g if the customer is sending full set of users daily in csv format from production environment and the file is pgp encrypted then a good filename is all employees production csv pgp in some cases teleskope can provide a sftp account but we prefer to use customer provided sftp accounts attributes/fields to be included in the hris file employee id firstname or preferred lastname email job title department office location city state country hire date management level above list of attributes is recommended by teleskope to get the best user experience on the platform, however we can discuss these during the hris kick off call in addition to the above we support mapping of any number of additional attributes as required