AWS RDS DataService
RDS Data API Amazon RDS provides an HTTP endpoint to run SQL statements on an Amazon Aurora DB cluster. To run these statements, you use the RDS Data API…
Data & analytics#openapi#cloud
Fork copies the collection into your workspace, without the publisher's secrets, so you can add your own key and send requests. Star saves it to your starred APIs (Account › Marketplace) and helps others find it.
Overview
RDS Data API Amazon RDS provides an HTTP endpoint to run SQL statements on an Amazon Aurora DB cluster. To run these statements, you use the RDS Data API (Data API). Data API is available with the following types of Aurora databases: Aurora PostgreSQL - Serverless and provisioned Aurora MySQL - Serverless and provisioned For more information about the Data API, see Using RDS Data API in the Amazon Aurora User Guide .
Endpoints 6
- POSTBatch execute statement
/BatchExecuteRuns a batch SQL statement over an array of data. You can run bulk update and insert operations for multiple records using a DML statement with different… - POSTBegin transaction
/BeginTransactionStarts a SQL transaction. A transaction can run for a maximum of 24 hours. A transaction is terminated and rolled back automatically after 24 hours. A… - POSTCommit transaction
/CommitTransactionEnds a SQL transaction started with the BeginTransaction operation and commits the changes. - POSTExecute sql
/ExecuteSqlDeprecated. Runs one or more SQL statements. This operation is deprecated. Please use the BatchExecuteStatement or ExecuteStatement operation. - POSTExecute statement
/ExecuteRuns a SQL statement against a database. If a call isn't part of a transaction because it doesn't include the transactionID parameter, changes that result… - POSTRollback transaction
/RollbackTransactionPerforms a rollback of a transaction. Rolling back a transaction cancels its changes.
API details
- Base URL
https://rds-data.{region}.amazonaws.com- Authentication
- AWS Signature Version 4 (requests signed with your AWS access key)
- Operations
- 6 operations on 6 pathsPOST 6
1 marked deprecated - Description format
- AWS Smithy model, API version
2018-08-01 - Links
- Documentation · OpenAPI document
- Listed from
- AWS Smithy API model (aws/api-models-aws) (Apache-2.0)
How to test the AWS RDS DataService in Swastik Codes
- Open the APISelect “Fork & run in Swastik Codes” on this page. Sign in or create a free account if asked.
- Fork it into your workspaceChoose a workspace. You get your own copy of the AWS RDS DataService collection, without the publisher's secrets.
- Add your credentialsThis API uses AWS Signature Version 4 (requests signed with your AWS access key). Add yours in the collection's variables or an environment; the requests already reference it.
- Send a requestPick an endpoint, for example “Batch execute statement” (POST /BatchExecute), and press Send. Check the response, add tests and run the whole collection with the runner.
Frequently asked questions
What is the AWS RDS DataService?
RDS Data API Amazon RDS provides an HTTP endpoint to run SQL statements on an Amazon Aurora DB cluster. To run these statements, you use the RDS Data API… It is listed under Data & analytics and has 6 endpoints.
Who publishes the AWS RDS DataService?
It is listed from Amazon Web Services, Inc.'s public API description (an OpenAPI document), not published by Amazon Web Services, Inc. on Swastik Codes. Anyone who controls amazonaws.com can claim the profile by adding a DNS TXT record.
What is the base URL of the AWS RDS DataService?
Requests go to https://rds-data.{region}.amazonaws.com. Endpoint paths are added to this base URL.
How do I authenticate with the AWS RDS DataService?
With AWS Signature Version 4 (requests signed with your AWS access key).
How many endpoints does the AWS RDS DataService have?
6 operations on 6 paths (6 POST).
Is forking the AWS RDS DataService free?
Yes. Forking copies the collection into your workspace for free. It has been starred 0 times and forked 0 times.