This blog details about using CLEO REST API to transfer file(s) between SFTP.
- Normally, people utilize SFTP/ FTP protocol to connect to server.
- But, if server is integrated with CLEO Portal then one can make use of CLEO HTTP(s) Rest API to transfer file as following -
- GENERATE AUTHORIZATION TOKEN USING USERNAME & PASSWORD
curl -X POST https://YOURTENANT.cleointegration.com/api/authentication -H 'content-type: application/x-www-form-urlencoded' -d 'grant_type=password&username=USERNAME&password=PASSWORD&totp_code=undefined'
Above Curl invocation will return a JSON Message with access Token that should be passed as header Authorization : Bearer * for future invocation to API.
{
"token_type":"bearer",
"access_token":"eyJhbGciOiJIUzI1NiJ9.eyJzdWIiOiJrdXFiMDNXTlEtYVZra1lRWGlSa1RBIiwiY3ljbGVJZCI6IkYiLCJpc3MiOiJodHRwOlwvXC93d3cuY2xlby5jb20iLCJvbW5pSWQiOiJrdXFiMDNXTlEtYVZra1lRWGlSa1RBIiwiZXhwIjoxNjc0MDkwNTU5LCJpYXQiOjE2NzQwODY5NTksIkFjY2Vzc1R5cGUiOiJERUZBVUxUIn0.QEpb27LZOj71vocJdYJPN7zxgF_LcwfUbQY7sDB6rwE",
"user_id":"kuqb03WNQ-aVkkYQXiRkTA"
}
- TO LIST HOME FOLDER USE BELOW CURL COMMAND -
curl -X GET -H 'Authorization: Bearer eyJhbGciOiJIUzI1NiJ9.eyJzdWIiOiJrdXFiMDNXTlEtYVZra1lRWGlSa1RBIiwiY3ljbGVJZCI6IkYiLCJpc3MiOiJodHRwOlwvXC93d3cuY2xlby5jb20iLCJvbW5pSWQiOiJrdXFiMDNXTlEtYVZra1lRWGlSa1RBIiwiZXhwIjoxNjc0MDkwNTU5LCJpYXQiOjE2NzQwODY5NTksIkFjY2Vzc1R5cGUiOiJERUZBVUxUIn0.QEpb27LZOj71vocJdYJPN7zxgF_LcwfUbQY7sDB6rwE' https://YOURTENANT.cleointegration.com/api/folders
This will return JSON message describing home folder id and permissions -
{"totalResults":1,"startIndex":0,"count":1,"resources":[{"type":"folder","space":"home","id":"OGI5N2IyMjA4ODU2MmI0NzFmODcxNWViNjVhMTFiNDlhYTk5M2QyMmU0ZjE3MWY2NTEyYmQzNzlmYTQyMDE3MA","name":"USERNAME","permissions":["subdirs","download","upload"],"systemProtected":{"delete":true,"rename":true},"_links":{"self":{"href":"/api/folders/OGI5N2IyMjA4ODU2MmI0NzFmODcxNWViNjVhMTFiNDlhYTk5M2QyMmU0ZjE3MWY2NTEyYmQzNzlmYTQyMDE3MA"}},"meta":{"lastModified":"2023-01-18T23:32:38.421Z"}}]}
- USE BELOW CURL COMMAND TO LIST CHILDREN'S UNDER HOME FOLDER -
curl -X GET -H 'Authorization: Bearer eyJhbGciOiJIUzI1NiJ9.eyJzdWIiOiJrdXFiMDNXTlEtYVZra1lRWGlSa1RBIiwiY3ljbGVJZCI6IkYiLCJpc3MiOiJodHRwOlwvXC93d3cuY2xlby5jb20iLCJvbW5pSWQiOiJrdXFiMDNXTlEtYVZra1lRWGlSa1RBIiwiZXhwIjoxNjc0MDkwNTU5LCJpYXQiOjE2NzQwODY5NTksIkFjY2Vzc1R5cGUiOiJERUZBVUxUIn0.QEpb27LZOj71vocJdYJPN7zxgF_LcwfUbQY7sDB6rwE' https://YOURTENANT.cleointegration.com/api/folders/OGI5N2IyMjA4ODU2MmI0NzFmODcxNWViNjVhMTFiNDlhYTk5M2QyMmU0ZjE3MWY2NTEyYmQzNzlmYTQyMDE3MA/children
This will return child folders and files under home
{"totalResults":5,"startIndex":0,"count":5,"resources":[{"type":"folder","space":"home","id":"OGI5N2IyMjA4ODU2MmI0NzFmODcxNWViNjVhMTFiNDlhNDAzZjgwN2E1N2JlNDU5NTA1NTY2NmM4Yzg5MmYxOGUyOTVhMDU3Zjk5ZjRlYTY1MTU1OTNjNDEyZTkyODE0","name":"inprogress","permissions":["subdirs","download","upload","delete"],"systemProtected":{"delete":false,"rename":false},"_links":{"self":{"href":"/api/folders/OGI5N2IyMjA4ODU2MmI0NzFmODcxNWViNjVhMTFiNDlhNDAzZjgwN2E1N2JlNDU5NTA1NTY2NmM4Yzg5MmYxOGUyOTVhMDU3Zjk5ZjRlYTY1MTU1OTNjNDEyZTkyODE0"}},"meta":{"lastModified":"2023-01-17T19:34:19.947Z"}},{"type":"folder","space":"home","id":"OGI5N2IyMjA4ODU2MmI0NzFmODcxNWViNjVhMTFiNDk1MmFmYWVhNDMxOGY2MzE3MGJlYTdhYmUxOGJkNjhlOGFhNTJlYjE4MWU5ZWFhMjI5MGU4ZDc5M2RlZTVhMjQ3","name":"processed","permissions":["subdirs","download","upload","delete"],"systemProtected":{"delete":false,"rename":false},"_links":{"self":{"href":"/api/folders/OGI5N2IyMjA4ODU2MmI0NzFmODcxNWViNjVhMTFiNDk1MmFmYWVhNDMxOGY2MzE3MGJlYTdhYmUxOGJkNjhlOGFhNTJlYjE4MWU5ZWFhMjI5MGU4ZDc5M2RlZTVhMjQ3"}},"meta":{"lastModified":"2023-01-17T19:34:54.402Z"}},{"type":"folder","space":"home","id":"OGI5N2IyMjA4ODU2MmI0NzFmODcxNWViNjVhMTFiNDk5NDc5MGMzMjI0ZDQwODFlYzE3OGY0MGM1NWQ3ZjM3NmM1NjdjYjU0N2RiMzBjMzhlNzQ3MjQ1YzFmZTU0MzBi","name":"SPS_daily_transaction","permissions":["subdirs","download","upload","delete"],"systemProtected":{"delete":true,"rename":true},"_links":{"self":{"href":"/api/folders/OGI5N2IyMjA4ODU2MmI0NzFmODcxNWViNjVhMTFiNDk5NDc5MGMzMjI0ZDQwODFlYzE3OGY0MGM1NWQ3ZjM3NmM1NjdjYjU0N2RiMzBjMzhlNzQ3MjQ1YzFmZTU0MzBi"}},"meta":{"lastModified":"2023-01-12T19:53:57.659Z"}},{"type":"folder","space":"home","id":"OGI5N2IyMjA4ODU2MmI0NzFmODcxNWViNjVhMTFiNDk1ZjNiYjhhMGYyYjkyMDBmOGQ5NTZkOTEwNGQzNmJkYTVlNGFmNDVhODk2YTNjMTgxMDZkM2EzMTVkYTgwMjk5","name":"SPS_recurring_payment","permissions":["subdirs","download","upload","delete"],"systemProtected":{"delete":true,"rename":true},"_links":{"self":{"href":"/api/folders/OGI5N2IyMjA4ODU2MmI0NzFmODcxNWViNjVhMTFiNDk1ZjNiYjhhMGYyYjkyMDBmOGQ5NTZkOTEwNGQzNmJkYTVlNGFmNDVhODk2YTNjMTgxMDZkM2EzMTVkYTgwMjk5"}},"meta":{"lastModified":"2023-01-12T19:53:57.669Z"}},{"type":"file","space":"home","id":"OGI5N2IyMjA4ODU2MmI0NzFmODcxNWViNjVhMTFiNDk4ZGNjZDBkNGY0NzMzMzVmMTZkNWRlMmFjMmIwOWM0MDc5NDYwZWY1YzRjYzM3ZTdmYjQ5NDBjMmM2NTBkMDBm","name":"test.py","length":741,"permissions":["download","delete","overwrite"],"systemProtected":{"delete":false,"rename":false},"_links":{"self":{"href":"/api/files/OGI5N2IyMjA4ODU2MmI0NzFmODcxNWViNjVhMTFiNDk4ZGNjZDBkNGY0NzMzMzVmMTZkNWRlMmFjMmIwOWM0MDc5NDYwZWY1YzRjYzM3ZTdmYjQ5NDBjMmM2NTBkMDBm"}},"meta":{"lastModified":"2023-01-18T23:32:38.426Z"}}]}
- USE FOLLOWING CURL COMMAND TO DOWNLOAD FILE "TEST.PY" -
curl -o test.py -X GET -d'access_token=eyJhbGciOiJIUzI1NiJ9.eyJzdWIiOiJrdXFiMDNXTlEtYVZra1lRWGlSa1RBIiwiY3ljbGVJZCI6IkYiLCJpc3MiOiJodHRwOlwvXC93d3cuY2xlby5jb20iLCJvbW5pSWQiOiJrdXFiMDNXTlEtYVZra1lRWGlSa1RBIiwiZXhwIjoxNjc0MDkwNTU5LCJpYXQiOjE2NzQwODY5NTksIkFjY2Vzc1R5cGUiOiJERUZBVUxUIn0.QEpb27LZOj71vocJdYJPN7zxgF_LcwfUbQY7sDB6rwE' https://YOURTENANT.cleointegration.com/api/files/OGI5N2IyMjA4ODU2MmI0NzFmODcxNWViNjVhMTFiNDk4ZGNjZDBkNGY0NzMzMzVmMTZkNWRlMmFjMmIwOWM0MDc5NDYwZWY1YzRjYzM3ZTdmYjQ5NDBjMmM2NTBkMDBm
Refer following URL for Upload file instructions - https://www.cleo.com/blog/sending-data-to-cleo-integration-cloud
Comments
Post a Comment