Ultimo Developer
  • Welcome
  • Getting started
    • Introduction
    • Software editions
  • API guide
    • REST
      • Requesting data
      • Inserting data
      • Inserting data in batch
      • File uploads
      • Query options
      • Special characters
      • Testing REST
      • Additional security
      • Limits and Quotas
    • HTTP POST
      • Overview of a POST request
      • Requesting data
      • Inserting data
      • Testing HTTP POST
      • Additional security
    • SOAP
      • Overview of a POST request
      • Requesting data
      • Inserting data
      • Testing SOAP
      • Additional security
    • Third party integration
    • Error handling
  • CONNECTORS
    • BI Platform
      • Create database user
      • Connect to the database
      • Expiring passwords
    • Exchange Online
      • Email import
      • Custom SMTP
    • LDAP
      • LDAP connector
      • Cloud vs On Premises
    • SCIM
    • OCI
    • Universal Print
      • Prerequisites & limitations
      • How to setup
  • API key Templates
    • Introduction
    • Master data
      • Cost centers
      • Departments
      • Employees
      • Service contracts
      • Suppliers
    • Assets
      • Technical Service
      • Medical Assets
      • Fleet objects
      • Infra objects
      • IT Configuration-Items
    • Jobs
      • Technical Service jobs
      • Medical jobs
      • Fleet jobs
      • Infra jobs
      • IT-incidents
      • Attach or change images
    • Article
      • Create articles
      • Create article supplier
    • IoT
      • REST
      • HTTP POST
      • SOAP
    • Reservations
      • Create reservation
      • Update reservation
      • Cancel reservation
      • Get reservations
    • Track & Trace
  • Database
    • BI overview
      • BI functions
      • BI views
  • Azure documentation
    • Terms & Conditions
    • Azure migration
      • Export alternatives
      • Import alternatives
      • LDAP
    • Setup standard Single Sign On with MS Entra ID
    • Azure Authentication
    • Azure IP addresses
    • Azure AD SCIM provisioning
  • Have a question?
    • Ask on our Customer Portal
    • Contact Customer Support
Powered by GitBook
On this page
  • 1. Alternative for importing data from a network share using an import connector
  • 2. Alternative for importing data/files from a network share using a scheduled workflow
  1. Azure documentation
  2. Azure migration

Import alternatives

1. Alternative for importing data from a network share using an import connector

If data is imported from a network share, the alternative is to send the data to the existing import connector directly through a webservice call. You can either use your own middleware tooling to send data to the Ultimo import connector or use a cUrl command.

Actions:

  • Create a (powershell) script to send data to the import connector.

  • Execute the script immediately each time a file is added to the network share or add a scheduled task to run this script periodically, according to the current schedule on the import connector.

Note: make sure the IT infrastructure allows connection to the Ultimo webservices.

cUrl example:

curl --data-binary @[FileName] -H "Content-type: text/xml;charset=utf-8" "[Import connector Url]"
curl --data-binary @C:\temp\importdata.csv -H "Content-type: text/xml;charset=utf-8" "https://customer.ultimo.net/Webservices/Connector.ashx?username=US0000003&password=xxx&action=import&importName=_CSVIMPORT"

To use this cUrl command in a powershell script:

curl.exe '--data-binary', '@C:\temp\importdata.csv',
 '-H', 'Content-type: text/xml;charset=utf-8',
 'https://customer.ultimo.net/Webservices/Connector.ashx?username=US0000003&password=xxx&action=import&importName=_CSVIMPORT'

2. Alternative for importing data/files from a network share using a scheduled workflow

If files are imported from a network share periodically with the workflow scheduler, the alternative is to send these files to the Ultimo REST API instead. The REST API can save these files in the Ultimo directory that is imported by the workflow.

Actions:

  • Create a (powershell) script to send data to the REST API.

  • Execute the script immediately each time a file is added to the network share or add a scheduled task to run this script periodically

Note: make sure the IT infrastructure allows connection to the Ultimo webservices.

cUrl example:

curl -F "File=@[FileName]" -F "FileSystemPath=[FileServiceData directory to save files]" -H "Apikey: [API Key]" -H "Applicationelementid: [Workflow GUID]" "[REST API Url]"
curl -F "File=@C:\temp\Document.docx" -F "FileSystemPath=ImportDirectory" -H "Apikey: xxx" -H "Applicationelementid: E7870B3EFDD5416BD7BE2C8AA660DDB8" "https://customer.ultimo.net/api/v1/action/_REST_UploadFile"

To use this cUrl command in a powershell script:

curl.exe '-F', 'File=@C:\temp\Document.docx',
 '-F', 'FileSystemPath=ImportDirectory',
 '-H', 'Apikey: xxx',
 '-H', 'Applicationelementid: E7870B3EFDD5416BD7BE2C8AA660DDB8',
 'https://customer.ultimo.net/api/v1/action/_REST_UploadFile'
PreviousExport alternativesNextLDAP

Last updated 4 years ago