Storage

Alibaba Object Storage Service (OSS)

Alibaba Cloud Object Storage Service (OSS) is an encrypted, secure, cost-effective, and easy-to-use object storage service that enables you to store, back up, and archive large amounts of data in the cloud.

Actions

• getBucket: List the information of all objects in a bucket

• deleteBucket: Delete a bucket

• getObject: Read an object

• deleteObject: Delete an object

• createBucket: Create a bucket

• getBucketInfo: Get the information of a bucket

• uploadObject: Upload objects

• listAllBuckets: List all buckets

Amazon Relational Database Service

Amazon Relational Database Service is a web service that allows you to set up, operate, and scale a relational database in AWS Cloud.

Actions

• deleteDBInstance: Delete a previously provisioned DB instance

• rebootDBInstance: Restart the database engine service

• describeDBSnapshots: Gives detailed information about DB snapshots

• createDBSnapshot: The source DBInstance must be in “available” state to create DBSnapshot

• modifyDBSnapshot: Updates a manual DBSnapshot with a new version of engine

• startDBCluster: Starts an Amazon Aurora DB cluster which was stopped using either AWS console,stop-db-cluster AWS CLI command, or the StopDBCluster action

• describeDBInstances: Gives detailed information about RDS

• deleteDBSnapshot: If the Snapshot is copied, the operation is deleted

• stopDBCluster: Stops an Amazon Aurora DB cluster

• copyDBSnapshot: The source DBSnapshot must be in the “available” state to copy the specified

• stopDBInstance: Stops the Output

• restoreDBInstanceFromDBSnapshot: Creates a new DBInstance from a DBSnapshot

• createDBInstance: Amazon RDS provides MySQL,PostgreSQL, Microsoft SQL Server and Oracle DB to create the DBInstance

• modifyDBInstance: Modifies settings for a DBInstance

• startDBInstance: Starts an Amazon RDS DBInstance which was stopped using either AWS console,stop-db-instance AWS CLI command, or the StopDBInstance action

• createDBInstanceReadReplica: Creates a DBInstance that acts as a read replica of a source DBInstance

Box

Box is an online file-sharing, storage, and collaboration service that caters to individual users as well as businesses. It lets you keep all your business files in one place for simple online collaboration. You can also share your files securely, and create, edit, and review documents with others in real-time from anywhere on any device.

Triggers

• File/Folder: The File/Folder operation event contains the following trigger events:

  • New File/Folder: Triggers when a new file or folder is created

  • File/Folder Copied: Triggers when a file/folder is copied to the specified file/folder

  • File/Folder Moved: Triggers when a file/folder is moved to the specified file/folder

  • File/Folder Deleted: Triggers when a specified file/folder is deleted

  • File/Folder Downloaded: Triggers when a specified file/folder is downloaded

  • File/Folder Shared: Triggers when a specified file/folder is shared

  • Comment On File: Triggers when a new comment is added to the specified file/folder

  • File/Folder Updated: Triggers when an existing file or folder is updated

  • File Previewed: Triggers when an existing file is previewed

  • Task Added: Triggers when a new task is added to the specified file/folder

  • Task Completed: Triggers when an existing task is completed in the specified file/folder

• Note Updated: Triggers when an existing note is updated

Actions

• Add Comment to File: Add a comment for the file

• Create Folder: Create a new folder at the specified location

• Create User: Create a new user

• Delete File: Delete an existing file

• Delete User: Delete the user

• Download File: Download the specified file

• Get Downloadable Link: Retrieve a downloadable link of the specified file

• Get File Details: Retrieve the details of the specified file

• Get Folder Details: Retrieve the details of the specified folder

• List Users: Retrieve the list of the users

• Move Owned Items: Move the owned items of one user account to another user account

• Search Files/Folders: Search and retrieve the files and folders that match the specified keyword

• Suspend User: Suspend an existing user

• Upload File: Upload the specified file

• Add Collaboration : Add a collaborator to a specific file or folder

• Create/Update Shared Link for File or Folder : Create or update a shared link for a specific file or folder

• Get Folder Items : Retrieve items of a specific folder

• Get File Comments : Retrieve comments of a specific file

• Move File or Folder : Move a specific file or folder to another location

Dropbox

Dropbox is a cloud storage provider (sometimes referred to as an online backup service) that is frequently used for storing and sharing files. It allows you to save, sync, and share your personal files, such as photos, videos, and docs. Dropbox lets you backup your files to the cloud, sync them between computers, and share them with your friends.

Triggers

• New File: Triggers when a new file is created.

• New Folder: Triggers when a new folder is created.

• Delete File: Triggers when an existing file is deleted.

• Delete Folder: Triggers when an existing folder is deleted.

• Update File: Triggers when an existing file is updated.

Actions

• Append Text: Add text to an existing file

• Copy File or Folder: Copy an existing file or folder to the specified location

• Create Folder: Create a new folder

• Delete File or Folder: Delete the specified file or folder

• Download File: Download the specified file

• Get Files and Folders Metadata: Retrieve the metadata of the specified file or folder

• Get Folder Details: Retrieve the details of the specified folder

• Move File or Folder: Move the specified file or folder to a new location

• Restore File to Specific Revision: Restore a file to the specified version

• Search file and folder metadata: Retrieve the metadata of the files and folders of which name contains the specified search string

• Upload File: Upload the specified file

Dropbox Business

Dropbox Business is an online storage platform where you can invite your team members and share data with them securely.

Actions

• Invite Members: Invite one or more members to your team.

• Remove Member: Remove a specified member from your team.

• Suspend Member: Suspend the specified member from the team.

• Unsuspend Member: Unsuspend the specified member.

Dropbox Paper

Dropbox Paper is an online collaborative editing service that lets you create and share documents. It also lets multiple users edit the same document at the same time.

Triggers

• New Document: Triggers when a new document is created

• New User in Document: Triggers when a new member is added to the document

Actions

• Add Member to Document: Add one or more members to document

• Archive Document: Archive the specified document

• Download Document: Download the specified document in the specified format

• Get Folder Details: Retrieve the details of the specified folder

Microsoft Excel Online

Microsoft Excel Online lets you create and modify workbooks and share them with other users so that multiple users can work on one workbook at the same time. This service works with paid Excel Online accounts only.

Triggers

• New Sheet: Triggers when a new sheet is created in the specified workbook of a specific folder.

• New Row: Triggers when a new row is added to the specified workbook.

• New Row In Table: Triggers when a new row is added to the specified table

Actions

• Create Sheet: Create a new sheet in the specified folder and workbook

• Create Workbook: Create a new workbook in the specified folder path

• Add Rows: Add rows to the specified workbook

• Add Rows to Table: Add rows to the specified table

• Get Rows: Retrieve rows from the specified workbook

• Get Table Rows: Retrieve the rows of the specified table

• Update Rows: Update the rows of the specified workbook

Firebase

Firebase is a scalable cloud-based NoSQL database that syncs and stores data, both client-side and server-side. It provides flexible development for mobile, web, and server environment using the cloud platform integration.

Actions

• Firestore Update Record: Update the record in the specified project.
  

Common Questions

How do I generate the private key and all the relevant input data?

1. To use Firebase in your workflow, you’ll first need to create a project in your Firebase account. Go to the Firebase console portal, where it automatically fetches your Google account credentials and creates an account for you. Click on the + Add project tab. A new window opens asking for the details of the project that you want to create.

   

2. Enter the project name, accept the terms, and click on the Create project button. You’ll be redirected to the Project Overview dashboard. Click on the settings icon on the left hand-side navigation panel. Go to Project settings and click Service accounts to manage the services.

   

3. On the Firebase Admin SDK window, click the Generate new private key button. You’ll see a file downloading in your system in JSON format. On opening the file, you can see the data values that you can use as an input for the action fields. Also, you can see the database URL on the same web page which you can use as an input to the Database URL field in the action.

   

4. Use these values as an input in the respective fields. Click on the TEST button to test the action. If you don’t want to test, click SKIP. Then click DONE, and run the workflow.

Google Cloud Storage

Google Cloud Storage is a RESTful online file storage web service that allows you to house and retrieve structured and unstructured data sets at any time.

Actions

• Compose Objects: Concatenates a list of existing objects into a new object in the same bucket

• Copy Objects: Copy a source object to a destination object. Optionally overrides metadata

• Delete Bucket Access Controls: Permanently delete the ACL entry for the specified entity on the specified bucket

• Delete Buckets: Permanently delete an empty bucket

• Delete Default Object Access Controls: Permanently delete the default object ACL entry for the specified entity on the specified bucket

• Delete Object Access Controls: Permanently deletes the ACL entry for the specified entity on the specified object

• Delete Objects: Delete an object and its metadata

• Get Bucket Access Controls: Returns the ACL entry for the specified entity on the specified bucket

• Get Buckets: Return metadata for the specified bucket

• Get Default Object Access Controls: Return the default object ACL entry for the specified entity on the specified bucket

• Get Object Access Controls: Return the ACL entry for the specified entity on the specified object

• Get Objects: Retrieve an object or its metadata

• Get Resumable Session: Return resumable session URI

• Insert Bucket Access Controls: Create a new ACL entry on the specified bucket

• Insert Buckets: Create a new bucket

• Insert Default Object Access Controls: Create a new default object ACL entry on the specified bucket

• Insert Object Access Controls: Create a new ACL entry on the specified object

• List Bucket Access Controls: Retrieve ACL entries on a specified bucket

• List Buckets: Retrieve a list of buckets for a given project

• List Default Object Access Controls: Retrieve default object ACL entries on the specified bucket

• List Object Access Controls: Retrieve ACL entries on the specified object

• List Objects: Retrieve a list of objects matching the criteria

• Patch Bucket Access Controls: Update an ACL entry on the specified bucket. This method supports patch semantics

• Patch Buckets: Update a bucket. This method supports patch semantics

• Patch Default Object Access Controls: Update a default object ACL entry on the specified bucket. This method supports patch semantics

• Patch Objects: Update a data blob’s associated metadata. This method supports patch semantics.

• Resumable Upload Objects: Allows you to do a Resumable upload to Google Cloud Storage

• Rewrite Objects: Rewrite a source object to a destination object. Optionally overrides metadata.

• Simple Upload Objects: Upload to Google Cloud Storage

• Update Bucket Access Controls: Update an ACL entry on the specified bucket

• Update Buckets: Update an object’s bucket

• Update Default Object Access Controls: Update a default object ACL entry on the specified bucket

• Update Object Access Controls: Updates an ACL entry on the specified object

• Update Objects: Update an object’s metadata

Google Drive

Google Drive is a cloud-based storage platform that stores all your files and shares them across your colleagues. It syncs all your data and is accessible from all devices.

Actions

• generateFileIDs: Generates a set of file IDs which can be provided in create requests

• getCommentByID: Get a comment by ID

• getFileByID: Returns file’s metadata or content specified by ID

• getPermissionByID: Get permission by ID

• getReplyByID: Get a reply by ID

• getResumableSession: Returns resumable session URl

• getRevisionByID: Gets a revision’s metadata or content by ID

• getStartPageToken: Gets the starting pageToken for listing future changes

• getUserInformation: Get information about the user, the user’s Drive, and system capabilities

• getdrive: Retrieves shared drive Metadata by ID

• listChanges: List changes for a user

• listComments: List a file’s comments

• listFiles: Lists or searches files

• listPermissions: List permissions by ID

• listReplies: List a comment’s replies

• listRevisions: List a file’s revisions

• listDrive: Lists the User’s shared drive

• simpleUploadFile: Allows you to do a Simple upload to Google Drive

• updateComment: Return file’s metadata or content by ID

• updateMetadataForFile: Updates metadata for file

• updatePermission: Update a permission for a file

• updateReply: Update a reply with patch semantics

• updateRevision: Updates file’s revisions

• uploadFile: Allows you to do a resumable upload to Google Drive

• updatemediaforfile: A file content is updated

• hidedrive: Hides a shared drive from the default view

• subsribechanges: Subscribes to changes for a user

• watchfile: Subscribes to changes to a file

• updatedrive: Updates the Metadata for a shared drive

• stopchannel: Stops watching resources through this channel

• unhidedrive: Restores a shared drive to the default view

• multipartupload: Uploads a file as multipartupload

• deletedrive: Deletes a shared drive for which the user is an organizer

• deletecommentbyID: Delete a comment by passing a ID

• deletefilebyID: Permanently delete a file by ID ownedby the user without moving it to the trash

• deletepermissionbyID: Delete a permission by ID

• deletereplybyID: Delete a reply by ID

• deleterevisionbyID: Delete a file revision by ID

• downloadfilebyID: Download file by ID that are stored in Google drive

• createmetadataforfile: Create a file metadata

• createdrive: create a new shared drive

• copyfile: Create a copy of a file and applies any requested updates with patch semantics

• createcomment: Create a new comment on a file

• createpermission: Create a permission for a file

• createmetadataforfile: Create a file metadata

• createreply: Create a new reply to a comment

• exportfile: Exports a google doc to the requested MIME type and returns the exported content

• emptytrash: Permanently deletes a file owned by the user without moving it to the trash

Google Drive (Deprecated)

Google Drive is a cloud-based storage platform that stores all your files and shares them with your colleagues. It syncs all your data and is accessible from all devices.

Actions

• Delete File: Delete a specific file

• Download File: Download a specific file

• Export File: Export a specific file

• Get Resource Metadata: Retrieve the metadata of a specific file

• Upload File: Upload a specific file

• Copy File: Create a copy of a file and applies any requested updates with patch semantics

Microsoft OneDrive

Microsoft OneDrive is a file sharing platform that enables you to share, store, and edit files in a web environment.

Triggers

• Create File or Folder: Triggers when a new file or folder is created

• Update File or Folder: Triggers when an existing file or folder is updated

• Delete File or Folder: Triggers when an existing file or folder is deleted

• Copy File or Folder: Triggers when an existing file or folder is copied to another folder

Actions

• Append Text File: Append text to the specified file

• Create Folder: Create a new folder

• Create Text File: Create a new text file

• Delete File or Folder: Delete the specified file or folder

• Download File: Download the specified file

• Get File or Folder: Get the specified file or folder

• Move File or Folder: Move the specified file or folder

• Upload File: Upload the specified file

Microsoft OneDrive for Business

Microsoft OneDrive for Business is a personal cloud storage space that you can use to create, edit, share and store files.

Triggers

• Create File or Folder: Triggers when a new file or folder is created

• Update File or Folder: Triggers when an existing file or folder is updated

• Delete File or Folder: Triggers when an existing file or folder is deleted

Actions

• Append Text File: Append content to a specific text file

• Create Folder: Create a new folder

• Create Text File: Create a text file

• Delete File or Folder: Delete a specific file or folder

• Download File: Download a specific file

• Get File or Folder: Get a specific file or folder

• Move File or Folder: Move a specific file or folder

• Upload File: Upload a specific file

Microsoft SharePoint Online

Microsoft SharePoint Online is a web-based collaboration tool that allows you to create, upload, update, and delete files and folders. You can also share them with your colleagues to keep everyone on the same page.

Actions

• Create Folder: Create a new folder

• Download File: Download the specified file from the folder

• Upload File (upto 4 MB): Upload the specified file to the folder

  Note

  The maximum upload file size is 4 MB.

• Upload File (upto 60 MB): Upload the specified file to the folder

  Note

  The maximum upload file size is 60 MB.

• Check Out File: Check out the specified file

• Check In File: Check in the specified file

• Get All Site Lists and Libraries: Retrieve the lists and libraries from the specified site

• Get Site: Retrieve the details of the specified site

• List Files/Folders: Retrieve list of files and folders

• List Sites: Retrieve list of sites

• Get File Version: Retrieve the version of the specified file

• Get File/Folder Details: Retrieve the details of the specified file/folder

• Rename File/Folder: Rename the specified file/folder

• Copy File/Folder: Copy the specified file/folder to another location

• Move File/Folder: Move the specified file/folder to another location

• Delete File/Folder: Delete the specified file/folder

ShowGizmo

ShowGizmo is an event management application that not just lets you create and manage events, but also allows you to collaborate with speakers and attendees effectively.

Actions

• Create Session: Create a new session

• Create Event: Create a new event

• Create User: Create a new user

• Destroy Registration: Delete the specified registration

• Destroy Session: Destroy the specified session

• Get Registrations: Retrieve some or all registrations

• Get Session: Retrieve the specified registration

• Get Sessions: Retrieve some or all sessions

• Get Users: Retrieve some or all users

• Update Session: Update the specified session

SpreadSheet

Actions

• SpreadSheet Writer: Save an existing file at a new location on the IBM webMethods Integration engine local storage

• SpreadSheet Reader: Read a Spreadsheet (.xlsx file) that is saved on the IBM webMethods Integration engine local storage

• SpreadSheet to Formulae: Retrieve the formulae from the specified spreadsheet stored on the IBM webMethods Integration engine local store

• SpreadSheet to CSV: Convert the spreadsheet data into CSV format

• SpreadSheet to JSON: Convert the spreadsheet data into JSON format

SurveyMonkey

SurveyMonkey is a cloud-based survey form development platform that enables you to create and customize surveys. You can share these forms through email and on social media sites with your customers, and know the statistics of your customer behavior.

Triggers

• New Survey: Triggers when a new survey is created

• New Collector: Triggers when a new collector is created for the specified survey

• New Response: Triggers when a new response is received for the specified survey

Actions

• Create Collector: Create an email or weblink collector

• Get Categories: Retrieve some or all categories

• Get Collector Responses: Retrieve the responses from the specified collector

• Get List of Respondents: Retrieve the list of respondents for the specified survey

• Get Survey Collector: Retrieve the list of collectors associated with the specified survey

• Get Survey Details: Retrieve the details of the specified survey

• Get Survey List: Retrieve the list of all surveys

• Get Survey Response: Retrieve a specific response from the survey

• Get Templates List: Retrieve some or all templates

• Get User Details: Retrieve the details of the logged-in user