Skip to main content
Solved

Question - Remote Upload to ETM Channel from external source system


Forum|alt.badge.img+7

Hi Everyone,

 

Most of file transfers from external sources for employee data is done via SFTP currently. We download the source file from an SFTP folder to the integration server and then perform a remote upload command. A bit archaic I know but didn’t have much time during our on-prem to SaaS migration to change this so we kept with it.

 

A external system that generates one of our source files is going though a revamp and we are looking to get rid of the SFTP servers to transfer the file.

 

We are thinking of having them directly upload their file to our ETM channel.

 

Has anyone done this before? If so, a couple of questions:

  • Do you have an example of the remote POST command? I do know the examples provided within ETM (powershell and bash) but would like other examples. 
  • What tools/programming language to you use to automate the upload?
  • Did you create a new ETM user for that specific interface?
  • Can we restrict the new ETM user to only upload for a certain channel? Or will they have access to upload to any other channel?

 

Thank you!

Martin Provost

 

 

Best answer by Paul McCulloch

A good way to get examples of how to submit a remote upload is via Postman. I’ve attached an example Postman ‘collection’ which shows how to submit a CSV to a channel (also included). If you click the Code “</>” button then Postman will show you how to make that request in a number of languages.

You can use any language that has a decent http library - so use whatever is familiar

You can use the User Role option in the channel configuration to limit access to users with that role. If you grant only that role to a user then they will only be able to access that channel (this will also prevent that user from accessing the ETM UI).

 

View original
Did this topic help you find an answer to your question?

2 replies

Forum|alt.badge.img+10
  • Hero (Employee)
  • 69 replies
  • Answer
  • March 6, 2023

A good way to get examples of how to submit a remote upload is via Postman. I’ve attached an example Postman ‘collection’ which shows how to submit a CSV to a channel (also included). If you click the Code “</>” button then Postman will show you how to make that request in a number of languages.

You can use any language that has a decent http library - so use whatever is familiar

You can use the User Role option in the channel configuration to limit access to users with that role. If you grant only that role to a user then they will only be able to access that channel (this will also prevent that user from accessing the ETM UI).

 


Forum|alt.badge.img+7
  • Author
  • Sidekick (Customer)
  • 11 replies
  • March 7, 2023

Thank you so much Paul - this is really helpful.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings