Perl Google Drive: About: Get Import and Export Formats

Back to Index

Gets information about Google Drive import formats and export formats.

Documentation: https://developers.google.com/drive/v3/reference/about/get

use chilkat();

$rest = chilkat::CkRest->new();

#   Provide a previously obtained OAuth2 access token.
$oauth2 = chilkat::CkOAuth2->new();
$oauth2->put_AccessToken("OAUTH2_ACCESS_TOKEN");
$rest->SetAuthOAuth2($oauth2);

$success = $rest->Connect("www.googleapis.com",443,1,1);
if ($success != 1) {
    print $rest->lastErrorText() . "\r\n";
    exit;
}

$rest->AddQueryParam("fields","importFormats,exportFormats");

$sbJson = chilkat::CkStringBuilder->new();
$success = $rest->FullRequestNoBodySb("GET","/drive/v3/about",$sbJson);
if ($success != 1) {
    print $rest->lastErrorText() . "\r\n";
    exit;
}

if ($rest->get_ResponseStatusCode() != 200) {
    print "Received error response code: " . $rest->get_ResponseStatusCode() . "\r\n";
    print "Response body:" . "\r\n";
    print $sbJson->getAsString() . "\r\n";
    exit;
}

$json = chilkat::CkJsonObject->new();
$json->LoadSb($sbJson);

#  The following code parses the JSON response.
#  A sample JSON response is shown below the sample code.

$i = 0;
$count_i = $json->SizeOfArray("importFormats.text/tab-separated-values");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.text/tab-separated-values[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.\"application/x-vnd.oasis.opendocument.presentation\"");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.\"application/x-vnd.oasis.opendocument.presentation\"[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.image/jpeg");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.image/jpeg[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.image/bmp");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.image/bmp[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.image/gif");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.image/gif[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.\"application/vnd.ms-excel.sheet.macroenabled.12\"");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.\"application/vnd.ms-excel.sheet.macroenabled.12\"[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.\"application/vnd.openxmlformats-officedocument.wordprocessingml.template\"");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.\"application/vnd.openxmlformats-officedocument.wordprocessingml.template\"[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.\"application/vnd.ms-powerpoint.presentation.macroenabled.12\"");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.\"application/vnd.ms-powerpoint.presentation.macroenabled.12\"[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.\"application/vnd.ms-word.template.macroenabled.12\"");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.\"application/vnd.ms-word.template.macroenabled.12\"[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.\"application/vnd.openxmlformats-officedocument.wordprocessingml.document\"");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.\"application/vnd.openxmlformats-officedocument.wordprocessingml.document\"[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.image/pjpeg");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.image/pjpeg[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.\"application/vnd.google-apps.script+text/plain\"");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.\"application/vnd.google-apps.script+text/plain\"[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.\"application/vnd.ms-excel\"");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.\"application/vnd.ms-excel\"[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.\"application/vnd.sun.xml.writer\"");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.\"application/vnd.sun.xml.writer\"[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.\"application/vnd.ms-word.document.macroenabled.12\"");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.\"application/vnd.ms-word.document.macroenabled.12\"[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.\"application/vnd.ms-powerpoint.slideshow.macroenabled.12\"");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.\"application/vnd.ms-powerpoint.slideshow.macroenabled.12\"[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.text/rtf");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.text/rtf[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.text/plain");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.text/plain[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.\"application/vnd.oasis.opendocument.spreadsheet\"");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.\"application/vnd.oasis.opendocument.spreadsheet\"[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.\"application/x-vnd.oasis.opendocument.spreadsheet\"");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.\"application/x-vnd.oasis.opendocument.spreadsheet\"[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.image/png");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.image/png[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.\"application/x-vnd.oasis.opendocument.text\"");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.\"application/x-vnd.oasis.opendocument.text\"[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.application/msword");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.application/msword[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.application/pdf");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.application/pdf[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.application/json");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.application/json[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.application/x-msmetafile");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.application/x-msmetafile[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.\"application/vnd.openxmlformats-officedocument.spreadsheetml.template\"");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.\"application/vnd.openxmlformats-officedocument.spreadsheetml.template\"[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.\"application/vnd.ms-powerpoint\"");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.\"application/vnd.ms-powerpoint\"[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.\"application/vnd.ms-excel.template.macroenabled.12\"");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.\"application/vnd.ms-excel.template.macroenabled.12\"[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.image/x-bmp");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.image/x-bmp[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.application/rtf");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.application/rtf[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.\"application/vnd.openxmlformats-officedocument.presentationml.template\"");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.\"application/vnd.openxmlformats-officedocument.presentationml.template\"[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.image/x-png");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.image/x-png[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.text/html");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.text/html[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.\"application/vnd.oasis.opendocument.text\"");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.\"application/vnd.oasis.opendocument.text\"[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.\"application/vnd.openxmlformats-officedocument.presentationml.presentation\"");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.\"application/vnd.openxmlformats-officedocument.presentationml.presentation\"[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.\"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet\"");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.\"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet\"[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.\"application/vnd.google-apps.script+json\"");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.\"application/vnd.google-apps.script+json\"[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.\"application/vnd.openxmlformats-officedocument.presentationml.slideshow\"");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.\"application/vnd.openxmlformats-officedocument.presentationml.slideshow\"[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.\"application/vnd.ms-powerpoint.template.macroenabled.12\"");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.\"application/vnd.ms-powerpoint.template.macroenabled.12\"[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.text/csv");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.text/csv[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.\"application/vnd.oasis.opendocument.presentation\"");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.\"application/vnd.oasis.opendocument.presentation\"[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.image/jpg");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.image/jpg[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("importFormats.text/richtext");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("importFormats.text/richtext[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("exportFormats.\"application/vnd.google-apps.form\"");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("exportFormats.\"application/vnd.google-apps.form\"[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("exportFormats.\"application/vnd.google-apps.document\"");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("exportFormats.\"application/vnd.google-apps.document\"[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("exportFormats.\"application/vnd.google-apps.drawing\"");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("exportFormats.\"application/vnd.google-apps.drawing\"[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("exportFormats.\"application/vnd.google-apps.spreadsheet\"");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("exportFormats.\"application/vnd.google-apps.spreadsheet\"[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("exportFormats.\"application/vnd.google-apps.script\"");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("exportFormats.\"application/vnd.google-apps.script\"[i]");
    $i = $i + 1;
}

$i = 0;
$count_i = $json->SizeOfArray("exportFormats.\"application/vnd.google-apps.presentation\"");
while ($i < $count_i) {
    $json->put_I($i);
    $strVal = $json->stringOf("exportFormats.\"application/vnd.google-apps.presentation\"[i]");
    $i = $i + 1;
}

print "Example Completed." . "\r\n";

Sample JSON Response Body

{
  "importFormats": {
    "text/tab-separated-values": [
      "application/vnd.google-apps.spreadsheet"
    ],
    "application/x-vnd.oasis.opendocument.presentation": [
      "application/vnd.google-apps.presentation"
    ],
    "image/jpeg": [
      "application/vnd.google-apps.document"
    ],
    "image/bmp": [
      "application/vnd.google-apps.document"
    ],
    "image/gif": [
      "application/vnd.google-apps.document"
    ],
    "application/vnd.ms-excel.sheet.macroenabled.12": [
      "application/vnd.google-apps.spreadsheet"
    ],
    "application/vnd.openxmlformats-officedocument.wordprocessingml.template": [
      "application/vnd.google-apps.document"
    ],
    "application/vnd.ms-powerpoint.presentation.macroenabled.12": [
      "application/vnd.google-apps.presentation"
    ],
    "application/vnd.ms-word.template.macroenabled.12": [
      "application/vnd.google-apps.document"
    ],
    "application/vnd.openxmlformats-officedocument.wordprocessingml.document": [
      "application/vnd.google-apps.document"
    ],
    "image/pjpeg": [
      "application/vnd.google-apps.document"
    ],
    "application/vnd.google-apps.script+text/plain": [
      "application/vnd.google-apps.script"
    ],
    "application/vnd.ms-excel": [
      "application/vnd.google-apps.spreadsheet"
    ],
    "application/vnd.sun.xml.writer": [
      "application/vnd.google-apps.document"
    ],
    "application/vnd.ms-word.document.macroenabled.12": [
      "application/vnd.google-apps.document"
    ],
    "application/vnd.ms-powerpoint.slideshow.macroenabled.12": [
      "application/vnd.google-apps.presentation"
    ],
    "text/rtf": [
      "application/vnd.google-apps.document"
    ],
    "text/plain": [
      "application/vnd.google-apps.document"
    ],
    "application/vnd.oasis.opendocument.spreadsheet": [
      "application/vnd.google-apps.spreadsheet"
    ],
    "application/x-vnd.oasis.opendocument.spreadsheet": [
      "application/vnd.google-apps.spreadsheet"
    ],
    "image/png": [
      "application/vnd.google-apps.document"
    ],
    "application/x-vnd.oasis.opendocument.text": [
      "application/vnd.google-apps.document"
    ],
    "application/msword": [
      "application/vnd.google-apps.document"
    ],
    "application/pdf": [
      "application/vnd.google-apps.document"
    ],
    "application/json": [
      "application/vnd.google-apps.script"
    ],
    "application/x-msmetafile": [
      "application/vnd.google-apps.drawing"
    ],
    "application/vnd.openxmlformats-officedocument.spreadsheetml.template": [
      "application/vnd.google-apps.spreadsheet"
    ],
    "application/vnd.ms-powerpoint": [
      "application/vnd.google-apps.presentation"
    ],
    "application/vnd.ms-excel.template.macroenabled.12": [
      "application/vnd.google-apps.spreadsheet"
    ],
    "image/x-bmp": [
      "application/vnd.google-apps.document"
    ],
    "application/rtf": [
      "application/vnd.google-apps.document"
    ],
    "application/vnd.openxmlformats-officedocument.presentationml.template": [
      "application/vnd.google-apps.presentation"
    ],
    "image/x-png": [
      "application/vnd.google-apps.document"
    ],
    "text/html": [
      "application/vnd.google-apps.document"
    ],
    "application/vnd.oasis.opendocument.text": [
      "application/vnd.google-apps.document"
    ],
    "application/vnd.openxmlformats-officedocument.presentationml.presentation": [
      "application/vnd.google-apps.presentation"
    ],
    "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet": [
      "application/vnd.google-apps.spreadsheet"
    ],
    "application/vnd.google-apps.script+json": [
      "application/vnd.google-apps.script"
    ],
    "application/vnd.openxmlformats-officedocument.presentationml.slideshow": [
      "application/vnd.google-apps.presentation"
    ],
    "application/vnd.ms-powerpoint.template.macroenabled.12": [
      "application/vnd.google-apps.presentation"
    ],
    "text/csv": [
      "application/vnd.google-apps.spreadsheet"
    ],
    "application/vnd.oasis.opendocument.presentation": [
      "application/vnd.google-apps.presentation"
    ],
    "image/jpg": [
      "application/vnd.google-apps.document"
    ],
    "text/richtext": [
      "application/vnd.google-apps.document"
    ]
  },
  "exportFormats": {
    "application/vnd.google-apps.form": [
      "application/zip"
    ],
    "application/vnd.google-apps.document": [
      "application/rtf",
      "application/vnd.oasis.opendocument.text",
      "text/html",
      "application/pdf",
      "application/epub+zip",
      "application/zip",
      "application/vnd.openxmlformats-officedocument.wordprocessingml.document",
      "text/plain"
    ],
    "application/vnd.google-apps.drawing": [
      "image/svg+xml",
      "image/png",
      "application/pdf",
      "image/jpeg"
    ],
    "application/vnd.google-apps.spreadsheet": [
      "application/x-vnd.oasis.opendocument.spreadsheet",
      "text/tab-separated-values",
      "application/pdf",
      "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
      "text/csv",
      "application/zip",
      "application/vnd.oasis.opendocument.spreadsheet"
    ],
    "application/vnd.google-apps.script": [
      "application/vnd.google-apps.script+json"
    ],
    "application/vnd.google-apps.presentation": [
      "application/vnd.oasis.opendocument.presentation",
      "application/pdf",
      "application/vnd.openxmlformats-officedocument.presentationml.presentation",
      "text/plain"
    ]
  }
}