install
curl https://rclone.org/install.sh | sudo bash
configure
rclone config
Collection of best software to use in your windows machine
Choose REST APIs if you need features such as API keys, per-client throttling, request validation, AWS WAF integration, or private API endpoints. Choose HTTP APIs if you don't need the features included with REST APIs
{proxy+} as pathhttps://yourapi.example.com/path/{proxy} note that you cannot use root path here /, it has to be some subpath| DELIMITER $$ | |
| DROP function if exists json_extract_c$$ | |
| CREATE FUNCTION json_extract_c( | |
| details TEXT, | |
| required_field VARCHAR (255) | |
| ) RETURNS TEXT CHARSET utf8mb4 | |
| DETERMINISTIC | |
| NO SQL | |
| BEGIN | |
| DECLARE search_term, val TEXT; |
| { | |
| "_embedded": [ | |
| { | |
| "id": "RPT200090", | |
| "created": "2020-07-22T14:45:37Z", | |
| "modified": "2020-07-22T15:53:04Z", | |
| "startDate": "2020-07-31", | |
| "endDate": "2020-08-30", | |
| "status": "arranging", | |
| "agentRole": "managed", |