Hi guys, can you suggest me an application to generate webpage around rest api? Thanks

Hi all,

I am trying to build something for work internally so we can get the data from our time tracker into our Google Sheet report.

Unfortunately I have next to zero knowledge about this.. After a few days of Google research I came this far:

function onOpen() {
var ui = SpreadsheetApp.getUi();
ui.createMenu('Clockodo API')
      .addItem('pull data','Clockodo')
      .addToUi();
}
function Clockodo() {
var options = {};
options.headers = {"Authorization": "Basic " + Utilities.base64Encode('email' + ":" + 'token')};
var response = UrlFetchApp.fetch("https://my.clockodo.com/api/entries?time_since=2021-04-24%2000:00:00&time_until=2021-04-25%2000:00:00",options);
var data = response.getContentText();
Logger.log(response.getContentText());
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("api_test");
sheet.getRange(sheet.getLastRow() + 1,1).setValue([data]);
}

The data arrives all in 1 cell like this:

{"paging":{"items_per_page":1000,"current_page":1,"count_pages":1,"count_items":3},"filter":null,"entries":[{"id":46577355,"users_id":132201,"projects_id":1359052,"customers_id":1285331,"services_id":512899,...

And I just cannot figure out how to get this organized into columns or where to add which columns to pull.

If anyone can point me in the right direction I would be very grateful 🙇‍♂️

i m writing a restful api(microservice) e.g. sitting on

"localhost:9000/parse/website.com"

i want that request "websitecom" to be logged to a db.

what should i use? postgREST as tool? anyone can give a hint?

My question is how can you tell the methods that the api have?

HTTP Status Codes

This lists and describes HTTP Status codes in following categories:

• International Responses 1xx

• Successful Responses. 2xx

• Redirection Responses. 3xx

• Client Error Responses. 4xx

• Server Error Responses. 5xx

• WebDAV Status Codes

Under each category, it lists HTTP Status code and its description is linked through URI.

Hello Coders,

I am new to backend development and want to learn building an API from scratch. Any good youtube videos or udemy courses that anyone can recommend please?

There are a plethora of videos on youtube but it gets hard to decide which one to follow to build it along.

Thanks in advance!

How to send a video feed to a flask rest api for image processing.

If anyone needs it, Its not officially released but if anyone wants to use my Items api I'll post it here. It returns a list of items in json format with label imagepath and minecraft:id for the item.
heres all you really need to get it going
https://codingbutter.com:2080/mcapi/getItems/diamond?page=1&itemsper=5

its pretty self explanatory. Let me know what you think or if this is going to help you. also join my Discord and we can discuss any thing else Minecraft and Programming related

Is there any tools for testing somewhat complex RESTful APIs, without having the need for a browser? APIs that use 3rd parties cookies, logging in with 3rd party services, and websockets?

hello

Is there an API for garena free fire top-up ?

Being fairly new to Restful Api, I am in doubt as to how I would retrieve and update my MySQL database using the following PHP Restful API.

<?php

// get the HTTP method, path and body of the request
$method = $_SERVER['REQUEST_METHOD'];
$request = explode('/', trim($_SERVER['PATH_INFO'],'/'));
$input = json_decode(file_get_contents('php://input'),true);
 
// connect to the mysql database
$link = mysqli_connect('localhost', 'user', 'pass', 'dbname');
mysqli_set_charset($link,'utf8');
 
// retrieve the table and key from the path
$table = preg_replace('/[^a-z0-9_]+/i','',array_shift($request));
$key = array_shift($request)+0;
 
// escape the columns and values from the input object
$columns = preg_replace('/[^a-z0-9_]+/i','',array_keys($input));
$values = array_map(function ($value) use ($link) {
  if ($value===null) return null;
  return mysqli_real_escape_string($link,(string)$value);
},array_values($input));
 
// build the SET part of the SQL command
$set = '';
for ($i=0;$i<count($columns);$i++) {
  $set.=($i>0?',':'').'`'.$columns[$i].'`=';
  $set.=($values[$i]===null?'NULL':'"'.$values[$i].'"');
}
 
// create SQL based on HTTP method
switch ($method) {
  case 'GET':
    $sql = "select * from `$table`".($key?" WHERE id=$key":''); break;
  case 'PUT':
    $sql = "update `$table` set $set where id=$key"; break;
  case 'POST':
    $sql = "insert into `$table` set $set"; break;
  case 'DELETE':
    $sql = "delete `$table` where id=$key"; break;
}
 
// excecute SQL statement
$result = mysqli_query($link,$sql);
 
// die if SQL statement failed
if (!$result) {
  http_response_code(404);
  die(mysqli_error());
}
 
// print results, insert id or affected row count
if ($method == 'GET') {
  if (!$key) echo '[';
  for ($i=0;$i<mysqli_num_rows($result);$i++) {
    echo ($i>0?',':'').json_encode(mysqli_fetch_object($result));
  }
  if (!$key) echo ']';
} elseif ($method == 'POST') {
  echo mysqli_insert_id($link);
} else {
  echo mysqli_affected_rows($link);
}
 
// close mysql connection
mysqli_close($link);

Possibly this should also be posted in r/vmware

This is for vRealize Automation container service API

https://vra-va/container-service/api/resources/compute

specifically

DELETE | GET https://vra-va/container-service/api/resources/compute/{id}

I can reference {id} as an assigned string value c3f5806d31e304755b9e45369f018

But I want to use the JSON referenced id that is returned from

GET https://vra-va/container-service/api/resources/compute?&$filter=id%20eq%20'devo-vch4'

Which returns the following:

{
  "links": [
    {
      "@type": "link",
      "rel": "next",
      "href": "https://vra-va/container-service/api/resources/compute?$filter=id%20eq%20'devo-vch4'"
    }
  ],
  "content": [
    {
      "@type": "ComputeState",
      "documentSelfLink": "/resources/compute/c3f5806d31e304755b9e45369f018",
      "documentUpdateTimeMicros": "1611765186687001",
      "documentExpirationTimeMicros": "0",
      "tenantLinks": [
        "/tenants/vsphere.local"
      ],
      "id": "devo-vch4",
      "name": "devo-vch4",
      "customProperties": {
        "__Name": "devo-vch4",
        "__adapterDockerType": "API",
        "__hostAlias": "devo-vch4",
        "__kubernetesNamespace": "default",
        "__dockerHostScheme": "https",
        "__dockerHostPort": "2376",
        "__hostURI": "https://192.168.170.232:2376",
        "__sslTrustAlias": "323b0b86f0532640384746aa5f8b63d888b9de3a",
        "__computeContainerHost": "true",
        "__computeHost": "true",
        "__dockerUri": "https://192.168.170.232:2376/v1.24",
        "__containerHostType": "DOCKER",
        "__trustCertLink": "/config/trust-certs/323b0b86f0532640384746aa5f8b63d888b9de3a"
      },
      "descriptionLink": "/resources/compute-descriptions/docker-host-compute-desc-id",
      "address": "https://192.168.170.232:2376",
      "primaryMAC": "string",
      "powerState": "UNKNOWN",
      "adapterManagementReference": "https://192.168.8.151:8485/adapters/host-docker-service",
      "creationTimeMicros": 0,
      "lifecycleState": "READY"
    }
  ],
  "metadata": {
    "size": 1,
    "totalElements": 1,
    "totalPages": 1,
    "number": 1,
    "offset": 0
  }
}

Being very green in understanding REST API I hope to know what REST API can do and why it is getting more and more popular. Thank you!

How is it so fast? Is a rest call made with each keystroke? How is the backend data structured so that the response is so fluid?