Récupération des colonnes d'une liste

GET https://graph.microsoft.com/v1.0/sites/{site-id}/lists/{liste-id}/columns

HTTP/1.1 200 OK
Content-type: application/json

{
   "value":[
      {
         "description":"",
         "displayName":"Title",
         "hidden":false,
         "id":"99ddcf45-e2f7-4f17-82b0-6fba34445103",
         "indexed":false,
         "name":"Title",
         "readOnly":false,
         "required":false,
         "text":{
            "allowMultipleLines":false,
            "appendChangesToExistingText":false,
            "linesForEditing":0,
            "maxLength":255
         }
      },
      {
         "description":"",
         "displayName":"Address",
         "id":"11dfef35-e2f7-4f17-82b0-6fba34445103",
         "indexed":false,
         "name":"Address",
         "readOnly":false,
         "required":false,
         "text":{
            "allowMultipleLines":false,
            "appendChangesToExistingText":false,
            "linesForEditing":0,
            "maxLength":255
         }
      }
   ]
}

{
    "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#sites('85423125-6410-40ca-8869-7ee9f08a1ab4')/lists('11c4e5f7-da7d-49fb-bdb7-f30abbd2e451')/columns",
    "@microsoft.graph.tips": "Use $select to choose only the properties your app needs, as this can lead to performance improvements. For example: GET sites('<guid>')/lists('<guid>')/columns?$select=boolean,calculated",
    "value": [
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "Titre",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "fa564e0f-0c70-4ab9-b863-0177e6ddd247",
            "indexed": false,
            "name": "Title",
            "readOnly": false,
            "required": true,
            "text": {
                "allowMultipleLines": false,
                "appendChangesToExistingText": false,
                "linesForEditing": 0,
                "maxLength": 255
            }
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "Balise de couleur",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "76d13cd2-1bae-45a5-8b74-545b87b65037",
            "indexed": false,
            "name": "_ColorTag",
            "readOnly": true,
            "required": false,
            "text": {
                "allowMultipleLines": false,
                "appendChangesToExistingText": false,
                "linesForEditing": 0,
                "maxLength": 255
            }
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "ID de ressource de conformité",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "3a6b296c-3f50-445c-a13f-9c679ea9dda3",
            "indexed": false,
            "name": "ComplianceAssetId",
            "readOnly": true,
            "required": false,
            "text": {
                "allowMultipleLines": false,
                "appendChangesToExistingText": false,
                "linesForEditing": 0,
                "maxLength": 255
            }
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "Name",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "d456603c-8869-4e37-bd73-8109e9dd245e",
            "indexed": false,
            "name": "Name",
            "readOnly": false,
            "required": false,
            "text": {
                "allowMultipleLines": false,
                "appendChangesToExistingText": false,
                "linesForEditing": 0,
                "maxLength": 255
            }
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "Description",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "61ef173d-5524-4c1a-b0a4-e2577558e4b1",
            "indexed": false,
            "name": "Description",
            "readOnly": false,
            "required": false,
            "text": {
                "allowMultipleLines": true,
                "appendChangesToExistingText": false,
                "linesForEditing": 6,
                "textType": "plain"
            }
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "nbItems",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "9aa8f9ef-f95f-4361-8c19-c53cccf3ea55",
            "indexed": false,
            "name": "nbItems",
            "readOnly": false,
            "required": false,
            "number": {
                "decimalPlaces": "automatic",
                "displayAs": "number",
                "maximum": 1.7976931348623157e+308,
                "minimum": -1.7976931348623157e+308
            }
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "PublishedDate",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "309e759b-c69e-4cdd-b4dc-0e993270d818",
            "indexed": false,
            "name": "PublishedDate",
            "readOnly": false,
            "required": false,
            "dateTime": {
                "displayAs": "default",
                "format": "dateTime"
            }
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "PublishedDate2",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "2586d46d-74d2-4c25-b05e-75a7feaf0c1b",
            "indexed": false,
            "name": "PublishedDate2",
            "readOnly": false,
            "required": false,
            "dateTime": {
                "displayAs": "default",
                "format": "dateOnly"
            }
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "Status",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "4cb676b7-63cd-4d63-93be-5fff612932f8",
            "indexed": false,
            "name": "Status",
            "readOnly": false,
            "required": false,
            "choice": {
                "allowTextEntry": false,
                "choices": [
                    "Not Started",
                    "In Progress",
                    "Completed"
                ],
                "displayAs": "dropDownMenu"
            }
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "IsPublished",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "513e94f3-dde9-4b0b-84e6-730583056e3c",
            "indexed": false,
            "name": "IsPublished",
            "readOnly": false,
            "required": false,
            "boolean": {}
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "Price",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "db70faf8-688e-488d-b8f8-f5a610e58865",
            "indexed": false,
            "name": "Price",
            "readOnly": false,
            "required": false,
            "currency": {
                "locale": "en-US"
            }
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "AssignedTo",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "2ab7a900-6da3-4cbe-aaf5-341e031dd2bb",
            "indexed": false,
            "name": "AssignedTo",
            "readOnly": false,
            "required": false,
            "personOrGroup": {
                "allowMultipleSelection": false,
                "displayAs": "nameWithPresence",
                "chooseFromType": "peopleAndGroups"
            }
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "Website",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "1939b843-761f-435e-ae97-9748d66f1876",
            "indexed": false,
            "name": "link",
            "readOnly": false,
            "required": false
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "TestBenjaminId",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "55220b2a-7ab6-49ad-acb3-a3bc5f857f57",
            "indexed": false,
            "name": "TestBenjaminId",
            "readOnly": false,
            "required": false,
            "lookup": {
                "allowMultipleValues": false,
                "allowUnlimitedLength": false,
                "columnName": "ID",
                "listId": "293a40a3-302d-42b6-b3c1-9682dda82665"
            }
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "location",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "f99b1b0b-421a-4c42-952f-567f3d6ea045",
            "indexed": false,
            "name": "location",
            "readOnly": false,
            "required": false
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "location : Pays/région",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "c35a9ff8-64c7-4ad1-804a-ec0a0a218a34",
            "indexed": false,
            "name": "CountryOrRegion",
            "readOnly": true,
            "required": false,
            "text": {
                "allowMultipleLines": false,
                "appendChangesToExistingText": false,
                "linesForEditing": 0,
                "maxLength": 255
            }
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "location : État",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "8114a39e-4805-4c8a-9184-bdc5dfbca096",
            "indexed": false,
            "name": "State",
            "readOnly": true,
            "required": false,
            "text": {
                "allowMultipleLines": false,
                "appendChangesToExistingText": false,
                "linesForEditing": 0,
                "maxLength": 255
            }
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "location : Ville",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "9247f2f2-e4ad-41e9-821d-bb00c75c69c5",
            "indexed": false,
            "name": "City",
            "readOnly": true,
            "required": false,
            "text": {
                "allowMultipleLines": false,
                "appendChangesToExistingText": false,
                "linesForEditing": 0,
                "maxLength": 255
            }
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "location : Code postal",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "8034973f-93a5-422e-a060-07ae5b310d6b",
            "indexed": false,
            "name": "PostalCode",
            "readOnly": true,
            "required": false,
            "text": {
                "allowMultipleLines": false,
                "appendChangesToExistingText": false,
                "linesForEditing": 0,
                "maxLength": 255
            }
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "location : Rue",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "4efcea2f-085f-4ca8-b76c-fb09f7e17e66",
            "indexed": false,
            "name": "Street",
            "readOnly": true,
            "required": false,
            "text": {
                "allowMultipleLines": false,
                "appendChangesToExistingText": false,
                "linesForEditing": 0,
                "maxLength": 255
            }
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "location : Coordonnées",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "81101fa3-b18b-4af6-9e9c-6c5ca8ee74be",
            "indexed": false,
            "name": "GeoLoc",
            "readOnly": true,
            "required": false,
            "geolocation": {}
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "location : nom",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "2a0728f2-8c11-4535-8488-9ef6b8935fde",
            "indexed": false,
            "name": "DispName",
            "readOnly": true,
            "required": false,
            "text": {
                "allowMultipleLines": false,
                "appendChangesToExistingText": false,
                "linesForEditing": 0,
                "maxLength": 255
            }
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "Website2",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "4bd18c6e-ee83-4f92-a771-0a1bcd12cb34",
            "indexed": false,
            "name": "Website2",
            "readOnly": false,
            "required": false
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "imgColumn",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "7164dd32-d6a1-4a35-9227-44ca15cf14c7",
            "indexed": false,
            "name": "imgColumn",
            "readOnly": false,
            "required": false
        },
        {
            "columnGroup": "Commentaires sur le contenu",
            "description": "Valeur moyenne de toutes les évaluations envoyées",
            "displayName": "Évaluation (0-5)",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "5a14d1ab-1513-48c7-97b3-657a5ba6c742",
            "indexed": false,
            "name": "AverageRating",
            "readOnly": false,
            "required": false
        },
        {
            "columnGroup": "Commentaires sur le contenu",
            "description": "Nombre d’évaluations envoyées",
            "displayName": "Nombre d’évaluations",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "b1996002-9167-45e5-a4df-b2c41c6723c7",
            "indexed": false,
            "name": "RatingCount",
            "readOnly": false,
            "required": false
        },
        {
            "columnGroup": "Commentaires sur le contenu",
            "description": "",
            "displayName": "Nombre de « J'aime »",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "6e4d832b-f610-41a8-b3e0-239608efda41",
            "indexed": false,
            "name": "LikesCount",
            "readOnly": false,
            "required": false
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "ID",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "1d22ea11-1e32-424e-89ab-9fedbadb6ce1",
            "indexed": false,
            "name": "ID",
            "readOnly": true,
            "required": false
        },
        {
            "columnGroup": "_Hidden",
            "description": "",
            "displayName": "Type de contenu",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "c042a256-787d-4a6f-8a8a-cf6ab767f12d",
            "indexed": false,
            "name": "ContentType",
            "readOnly": false,
            "required": false
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "Modifié",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "28cf69c5-fa48-462a-b5cd-27b6f9d2bd5f",
            "indexed": false,
            "name": "Modified",
            "readOnly": true,
            "required": false,
            "dateTime": {
                "displayAs": "default",
                "format": "dateTime"
            }
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "Créé",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "8c06beca-0777-48f7-91c7-6da68bc07b69",
            "indexed": false,
            "name": "Created",
            "readOnly": true,
            "required": false,
            "dateTime": {
                "displayAs": "default",
                "format": "dateTime"
            }
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "Créé par",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "1df5e554-ec7e-46a6-901d-d85a3881cb18",
            "indexed": false,
            "name": "Author",
            "readOnly": true,
            "required": false,
            "personOrGroup": {
                "allowMultipleSelection": false,
                "displayAs": "nameWithPresence",
                "chooseFromType": "peopleAndGroups"
            }
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "Modifié par",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "d31655d1-1d5b-4511-95a1-7a09e9b75bf2",
            "indexed": false,
            "name": "Editor",
            "readOnly": true,
            "required": false,
            "personOrGroup": {
                "allowMultipleSelection": false,
                "displayAs": "nameWithPresence",
                "chooseFromType": "peopleAndGroups"
            }
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "Version",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "dce8262a-3ae9-45aa-aab4-83bd75fb738a",
            "indexed": false,
            "name": "_UIVersionString",
            "readOnly": true,
            "required": false,
            "text": {
                "allowMultipleLines": false,
                "appendChangesToExistingText": false,
                "linesForEditing": 0,
                "maxLength": 255
            }
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "Pièces jointes",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "67df98f4-9dec-48ff-a553-29bece9c5bf4",
            "indexed": false,
            "name": "Attachments",
            "readOnly": false,
            "required": false
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "Modifier",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "503f1caa-358e-4918-9094-4a2cdc4bc034",
            "indexed": false,
            "name": "Edit",
            "readOnly": true,
            "required": false
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "Titre",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "bc91a437-52e7-49e1-8c4e-4698904b2b6d",
            "indexed": false,
            "name": "LinkTitleNoMenu",
            "readOnly": true,
            "required": false
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "Titre",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "82642ec8-ef9b-478f-acf9-31f7d45fbc31",
            "indexed": false,
            "name": "LinkTitle",
            "readOnly": true,
            "required": false
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "Type",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "081c6e4c-5c14-4f20-b23e-1a71ceb6a67c",
            "indexed": false,
            "name": "DocIcon",
            "readOnly": true,
            "required": false
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "Nombre d'éléments enfants",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "b824e17e-a1b3-426e-aecf-f0184d900485",
            "indexed": false,
            "name": "ItemChildCount",
            "readOnly": true,
            "required": false,
            "lookup": {
                "allowMultipleValues": false,
                "allowUnlimitedLength": false,
                "columnName": "ItemChildCount",
                "listId": "",
                "primaryLookupColumnId": "ID"
            }
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "Nombre d’enfants du dossier",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "960ff01f-2b6d-4f1b-9c3f-e19ad8927341",
            "indexed": false,
            "name": "FolderChildCount",
            "readOnly": true,
            "required": false,
            "lookup": {
                "allowMultipleValues": false,
                "allowUnlimitedLength": false,
                "columnName": "FolderChildCount",
                "listId": "",
                "primaryLookupColumnId": "ID"
            }
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "Paramètres de l’étiquette",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "ccc1037f-f65e-434a-868e-8c98af31fe29",
            "indexed": false,
            "name": "_ComplianceFlags",
            "readOnly": true,
            "required": false,
            "lookup": {
                "allowMultipleValues": false,
                "allowUnlimitedLength": false,
                "columnName": "ComplianceFlags",
                "listId": "",
                "primaryLookupColumnId": "ID"
            }
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "Étiquette de rétention",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "d4b6480a-4bed-4094-9a52-30181ea38f1d",
            "indexed": false,
            "name": "_ComplianceTag",
            "readOnly": true,
            "required": false,
            "lookup": {
                "allowMultipleValues": false,
                "allowUnlimitedLength": false,
                "columnName": "ComplianceTag",
                "listId": "",
                "primaryLookupColumnId": "ID"
            }
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "Étiquette de rétention appliquée",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "92be610e-ddbb-49f4-b3b1-5c2bc768df8f",
            "indexed": false,
            "name": "_ComplianceTagWrittenTime",
            "readOnly": true,
            "required": false,
            "lookup": {
                "allowMultipleValues": false,
                "allowUnlimitedLength": false,
                "columnName": "ComplianceTagWrittenTime",
                "listId": "",
                "primaryLookupColumnId": "ID"
            }
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "Étiquette appliquée par",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "418d7676-2d6f-42cf-a16a-e43d2971252a",
            "indexed": false,
            "name": "_ComplianceTagUserId",
            "readOnly": true,
            "required": false,
            "lookup": {
                "allowMultipleValues": false,
                "allowUnlimitedLength": false,
                "columnName": "ComplianceTagUserId",
                "listId": "",
                "primaryLookupColumnId": "ID"
            }
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "L’élément est un enregistrement",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "8382d247-72a9-44b1-9794-7b177edc89f3",
            "indexed": false,
            "name": "_IsRecord",
            "readOnly": true,
            "required": false
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "Application créée par",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "6bfaba20-36bf-44b5-a1b2-eb6346d49716",
            "indexed": false,
            "name": "AppAuthor",
            "readOnly": true,
            "required": false,
            "lookup": {
                "allowMultipleValues": false,
                "allowUnlimitedLength": false,
                "columnName": "Title",
                "listId": "AppPrincipals"
            }
        },
        {
            "columnGroup": "Colonnes personnalisées",
            "description": "",
            "displayName": "Application modifiée par",
            "enforceUniqueValues": false,
            "hidden": false,
            "id": "e08400f3-c779-4ed2-a18c-ab7f34caa318",
            "indexed": false,
            "name": "AppEditor",
            "readOnly": true,
            "required": false,
            "lookup": {
                "allowMultipleValues": false,
                "allowUnlimitedLength": false,
                "columnName": "Title",
                "listId": "AppPrincipals"
            }
        }
    ]
}