Importing from a Web Service

Owned by Juliane Wetzel
Last updated: May 17, 2022

INFO

Find all information and how-to import from web services here.

Supported Webservices

Datameer X allows to import from:

  • Atlassian Jira
  • Google Spreadsheet

Importing from a Webservice

Atlassian JIRA

To import data from Atlassian JIRA:

  1. Click the "+" button and choose "Import Job" or right-click in the file browser and select "Create New" → "Import Job". The 'New Import Job' tab appears in the menu bar.
    or 
  2. Click "Select Connection". The dialog 'Select Connection' opens.
     
  3. Click on the connection for JIRA and confirm with "Select". The connection is displayed.
     
  4. Confirm with "Next". The tab 'Data Details' opens.
     
  5. Enter the JQL query in the section 'Issue Filter'. 
     
  6. If needed, change the number of records used to auto-detect the type of a column and enter the column names to obfuscate and confirm with "Next". The tab 'Define Fields' opens.
      
  7. Mark all required columns.
     
  8. If needed, enter placeholder values and confirm with "Apply".
  9. Decide how to handle invalid data. 
     
  10. Decide whether you want partition data and confirm with "Next". The tab 'Schedule' opens.
    INFO: If you have checked 'Partition Data', enter a date expression and select the data format from the drop-down.
     
  11. Decide whether the import shall be triggered manually or on a schedule.
     
  12. Select the option for data retention.   
     
  13. If needed, enter advanced scheduling configuration like the amount of sample records or the maximum amount of errors to log and confirm with "Next". The tab 'Schedule' opens.
    INFO: Higher values lead to more precise preview results but can rapidly decrease the performance. 
     
  14. If needed, enter an import job description.
  15. Demark the checkbox if the import shall not start immediately after the saving. 
    INFO: The check-box is marked per default to start the import right after saving the import job. 
     
  16. If needed, enter the email address for several notifications and confirm with "Save". The 'Save Import Job' dialog opens.
     
  17. Select the path the data shall be imported to, enter a name and confirm with "Save". Data Import from JIRA is finished. 

Google Spreadsheet

To import data from Google Spreadsheet:

  1. Click the + (plus) button and select Import Job or right-click in the browser and select Create new > Import Job.
  2. Click Select Connector, choose the Google Spreadsheet connector, and click Next.
  3. Select the worksheets from the associated Google account. Specify where the header row is and then click Next.
     
  4. Review the defined fields and click Next.
  5. Review the schedule and advanced properties for the job and click Next.
  6. Create a description for the import job and click Save.