locked
extract data from json RRS feed

  • Question

  • hi team,

    I have the data in the following format how do i extract the particular field

    {
      "@odata.context": "https://mind078-my.sharepoint.com/_api/v1.0/$metadata#files",
      "value": [
        {
          "@odata.type": "#Microsoft.FileServices.Folder",
          "@odata.id": "https://mind078-my.sharepoint.com/_api/v1.0/me/files/01V5SLMC7V4GCMGSQPG5EZTLTCAH7I7SM6",
          "@odata.etag": "\"{C384E1F5-0F4A-4937-99AE-6201FE8FC99E},1\"",
          "@odata.editLink": "me/files/01V5SLMC7V4GCMGSQPG5EZTLTCAH7I7SM6",
          "createdBy": {
            "application": null,
            "user": {
              "id": "13acbba1-fca7-4672-953c-742621ebb9c5",
              "displayName": "raksha murthy"
            }
          },
          "eTag": "\"{C384E1F5-0F4A-4937-99AE-6201FE8FC99E},1\"",
          "id": "01V5SLMC7V4GCMGSQPG5EZTLTCAH7I7SM6",
          "lastModifiedBy": {
            "application": null,
            "user": {
              "id": "13acbba1-fca7-4672-953c-742621ebb9c5",
              "displayName": "raksha murthy"
            }
          },
          "name": "test123",
          "parentReference": {
            "driveId": "01P4GENUIWIIIXTKTJWJB2CNHDQFG3DW4U",
            "id": "01V5SLMC56Y2GOVW7725BZO354PWSELRRZ",
            "path": "/"
          },
          "size": 0,
          "dateTimeCreated": "2015-11-02T07:09:18Z",
          "dateTimeLastModified": "2015-11-02T10:36:35Z",
          "type": "Folder",
          "webUrl": "https://mind078-my.sharepoint.com/personal/raksha_mind078_onmicrosoft_com/Documents/test123",
          "childCount": 1
        },
        {
          "@odata.type": "#Microsoft.FileServices.File",
          "@odata.id": "https://mind078-my.sharepoint.com/_api/v1.0/me/files/01V5SLMC5W7KW5KDKIUZG23DUXOLMI2HHT",
          "@odata.etag": "\"{D5ADFAB6-480D-4DA6-AD8E-9772D88D1CF3},1\"",
          "@odata.editLink": "me/files/01V5SLMC5W7KW5KDKIUZG23DUXOLMI2HHT",
          "createdBy": {
            "application": null,
            "user": {
              "id": "13acbba1-fca7-4672-953c-742621ebb9c5",
              "displayName": "raksha murthy"
            }
          },
          "eTag": "\"{D5ADFAB6-480D-4DA6-AD8E-9772D88D1CF3},1\"",
          "id": "01V5SLMC5W7KW5KDKIUZG23DUXOLMI2HHT",
          "lastModifiedBy": {
            "application": null,
            "user": {
              "id": "13acbba1-fca7-4672-953c-742621ebb9c5",
              "displayName": "raksha murthy"
            }
          },
          "name": "test.aspx",
          "parentReference": {
            "driveId": "01P4GENUIWIIIXTKTJWJB2CNHDQFG3DW4U",
            "id": "01V5SLMC56Y2GOVW7725BZO354PWSELRRZ",
            "path": "/"
          },
          "size": 7056,
          "dateTimeCreated": "2015-10-23T11:33:08Z",
          "dateTimeLastModified": "2015-10-23T11:33:08Z",
          "type": "File",
          "webUrl": "https://mind078-my.sharepoint.com/personal/raksha_mind078_onmicrosoft_com/Documents/test.aspx",
          "contentUrl": "https://mind078-my.sharepoint.com/personal/raksha_mind078_onmicrosoft_com/_api/v1.0/me/files/01V5SLMC5W7KW5KDKIUZG23DUXOLMI2HHT/content"
        }
      ]
    }
    onedrivetest.aspx:653 Got the Files
    onedrivetest.aspx:654 {
      "@odata.context": "https://mind078-my.sharepoint.com/_api/v1.0/$metadata#files",
      "value": [
        {
          "@odata.type": "#Microsoft.FileServices.Folder",
          "@odata.id": "https://mind078-my.sharepoint.com/_api/v1.0/me/files/01V5SLMC7V4GCMGSQPG5EZTLTCAH7I7SM6",
          "@odata.etag": "\"{C384E1F5-0F4A-4937-99AE-6201FE8FC99E},1\"",
          "@odata.editLink": "me/files/01V5SLMC7V4GCMGSQPG5EZTLTCAH7I7SM6",
          "createdBy": {
            "application": null,
            "user": {
              "id": "13acbba1-fca7-4672-953c-742621ebb9c5",
              "displayName": "raksha murthy"
            }
          },
          "eTag": "\"{C384E1F5-0F4A-4937-99AE-6201FE8FC99E},1\"",
          "id": "01V5SLMC7V4GCMGSQPG5EZTLTCAH7I7SM6",
          "lastModifiedBy": {
            "application": null,
            "user": {
              "id": "13acbba1-fca7-4672-953c-742621ebb9c5",
              "displayName": "raksha murthy"
            }
          },
          "name": "test123",
          "parentReference": {
            "driveId": "01P4GENUIWIIIXTKTJWJB2CNHDQFG3DW4U",
            "id": "01V5SLMC56Y2GOVW7725BZO354PWSELRRZ",
            "path": "/"
          },
          "size": 0,
          "dateTimeCreated": "2015-11-02T07:09:18Z",
          "dateTimeLastModified": "2015-11-02T10:36:35Z",
          "type": "Folder",
          "webUrl": "https://mind078-my.sharepoint.com/personal/raksha_mind078_onmicrosoft_com/Documents/test123",
          "childCount": 1
        },
        {
          "@odata.type": "#Microsoft.FileServices.File",
          "@odata.id": "https://mind078-my.sharepoint.com/_api/v1.0/me/files/01V5SLMC5W7KW5KDKIUZG23DUXOLMI2HHT",
          "@odata.etag": "\"{D5ADFAB6-480D-4DA6-AD8E-9772D88D1CF3},1\"",
          "@odata.editLink": "me/files/01V5SLMC5W7KW5KDKIUZG23DUXOLMI2HHT",
          "createdBy": {
            "application": null,
            "user": {
              "id": "13acbba1-fca7-4672-953c-742621ebb9c5",
              "displayName": "raksha murthy"
            }
          },
          "eTag": "\"{D5ADFAB6-480D-4DA6-AD8E-9772D88D1CF3},1\"",
          "id": "01V5SLMC5W7KW5KDKIUZG23DUXOLMI2HHT",
          "lastModifiedBy": {
            "application": null,
            "user": {
              "id": "13acbba1-fca7-4672-953c-742621ebb9c5",
              "displayName": "raksha murthy"
            }
          },
          "name": "test.aspx",
          "parentReference": {
            "driveId": "01P4GENUIWIIIXTKTJWJB2CNHDQFG3DW4U",
            "id": "01V5SLMC56Y2GOVW7725BZO354PWSELRRZ",
            "path": "/"
          },
          "size": 7056,
          "dateTimeCreated": "2015-10-23T11:33:08Z",
          "dateTimeLastModified": "2015-10-23T11:33:08Z",
          "type": "File",
          "webUrl": "https://mind078-my.sharepoint.com/personal/raksha_mind078_onmicrosoft_com/Documents/test.aspx",
          "contentUrl": "https://mind078-my.sharepoint.com/personal/raksha_mind078_onmicrosoft_com/_api/v1.0/me/files/01V5SLMC5W7KW5KDKIUZG23DUXOLMI2HHT/content"
        }
      ]
    }

    Monday, November 2, 2015 12:22 PM

Answers