PowerShell 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

[Reflection.Assembly]::LoadFile("C:\myAssemblies\ChilkatDotNet2.dll")

$rest = New-Object Chilkat.Rest

#   Provide a previously obtained OAuth2 access token.
$oauth2 = New-Object Chilkat.OAuth2
$oauth2.AccessToken = "OAUTH2_ACCESS_TOKEN"
$rest.SetAuthOAuth2($oauth2)

$success = $rest.Connect("www.googleapis.com",443,$true,$true)
if ($success -ne $true) {
    $($rest.LastErrorText)
    exit
}

$rest.AddQueryParam("fields","importFormats,exportFormats")

$sbJson = New-Object Chilkat.StringBuilder
$success = $rest.FullRequestNoBodySb("GET","/drive/v3/about",$sbJson)
if ($success -ne $true) {
    $($rest.LastErrorText)
    exit
}

if ($rest.ResponseStatusCode -ne 200) {
    $("Received error response code: " + $rest.ResponseStatusCode)
    $("Response body:")
    $($sbJson.GetAsString())
    exit
}

$json = New-Object Chilkat.JsonObject
$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 -lt $count_i) {
    $json.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 -lt $count_i) {
    $json.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 -lt $count_i) {
    $json.I = $i
    $strVal = $json.StringOf("importFormats.image/jpeg[i]")
    $i = $i + 1
}

$i = 0
$count_i = $json.SizeOfArray("importFormats.image/bmp")
while ($i -lt $count_i) {
    $json.I = $i
    $strVal = $json.StringOf("importFormats.image/bmp[i]")
    $i = $i + 1
}

$i = 0
$count_i = $json.SizeOfArray("importFormats.image/gif")
while ($i -lt $count_i) {
    $json.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 -lt $count_i) {
    $json.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 -lt $count_i) {
    $json.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 -lt $count_i) {
    $json.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 -lt $count_i) {
    $json.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 -lt $count_i) {
    $json.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 -lt $count_i) {
    $json.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 -lt $count_i) {
    $json.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 -lt $count_i) {
    $json.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 -lt $count_i) {
    $json.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 -lt $count_i) {
    $json.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 -lt $count_i) {
    $json.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 -lt $count_i) {
    $json.I = $i
    $strVal = $json.StringOf("importFormats.text/rtf[i]")
    $i = $i + 1
}

$i = 0
$count_i = $json.SizeOfArray("importFormats.text/plain")
while ($i -lt $count_i) {
    $json.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 -lt $count_i) {
    $json.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 -lt $count_i) {
    $json.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 -lt $count_i) {
    $json.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 -lt $count_i) {
    $json.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 -lt $count_i) {
    $json.I = $i
    $strVal = $json.StringOf("importFormats.application/msword[i]")
    $i = $i + 1
}

$i = 0
$count_i = $json.SizeOfArray("importFormats.application/pdf")
while ($i -lt $count_i) {
    $json.I = $i
    $strVal = $json.StringOf("importFormats.application/pdf[i]")
    $i = $i + 1
}

$i = 0
$count_i = $json.SizeOfArray("importFormats.application/json")
while ($i -lt $count_i) {
    $json.I = $i
    $strVal = $json.StringOf("importFormats.application/json[i]")
    $i = $i + 1
}

$i = 0
$count_i = $json.SizeOfArray("importFormats.application/x-msmetafile")
while ($i -lt $count_i) {
    $json.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 -lt $count_i) {
    $json.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 -lt $count_i) {
    $json.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 -lt $count_i) {
    $json.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 -lt $count_i) {
    $json.I = $i
    $strVal = $json.StringOf("importFormats.image/x-bmp[i]")
    $i = $i + 1
}

$i = 0
$count_i = $json.SizeOfArray("importFormats.application/rtf")
while ($i -lt $count_i) {
    $json.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 -lt $count_i) {
    $json.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 -lt $count_i) {
    $json.I = $i
    $strVal = $json.StringOf("importFormats.image/x-png[i]")
    $i = $i + 1
}

$i = 0
$count_i = $json.SizeOfArray("importFormats.text/html")
while ($i -lt $count_i) {
    $json.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 -lt $count_i) {
    $json.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 -lt $count_i) {
    $json.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 -lt $count_i) {
    $json.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 -lt $count_i) {
    $json.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 -lt $count_i) {
    $json.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 -lt $count_i) {
    $json.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 -lt $count_i) {
    $json.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 -lt $count_i) {
    $json.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 -lt $count_i) {
    $json.I = $i
    $strVal = $json.StringOf("importFormats.image/jpg[i]")
    $i = $i + 1
}

$i = 0
$count_i = $json.SizeOfArray("importFormats.text/richtext")
while ($i -lt $count_i) {
    $json.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 -lt $count_i) {
    $json.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 -lt $count_i) {
    $json.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 -lt $count_i) {
    $json.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 -lt $count_i) {
    $json.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 -lt $count_i) {
    $json.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 -lt $count_i) {
    $json.I = $i
    $strVal = $json.StringOf("exportFormats.`"application/vnd.google-apps.presentation`"[i]")
    $i = $i + 1
}

$("Example Completed.")

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"
    ]
  }
}