DataSource File from AWS S3 bucket
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-11-2019 12:44 PM
Hello,
I am attempting to pull an excel file i have stored on an AWS S3 bucket as a scheduled data import. I have set up the scheduled import, and am attempting to configure a datasource for the file, however i have been unable to make an API call to S3 in order to get the file for my dataload/Transform etc.
Has anyone ever pulled a file from S3 before. I know ITOM has an S3 integration, however we are not paying for the ITOM module and would like to implement a custom configuration.
Any help would be appreciated.
-Drew
- Labels:
-
Integrations
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-11-2019 03:39 PM
It appears that there is a REST API for AWS S3. Your best option is likely to make use of that using ServiceNow's Outbound REST Message functionality and use the S3 as an endpoint.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-21-2019 07:56 AM
Any solution on this? Did it worked with REST API or any other method?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-21-2019 08:11 AM
Yes i found a solution. I had to create a custom application that created a custom Authentication string for the REST call. the application leverages a crypto.js library to encode string via an HMAC-SHA256 function.
the Authentication string is derived using the follow documentation from amazon.
https://docs.aws.amazon.com/AmazonS3/latest/API/sig-v4-authenticating-requests.html
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-20-2020 07:25 AM
Were you able to implement a schedule import for pulling the data from AWS S3 bucket into Servicenow?
