Chilkat Online Tools

SQL Server / Salesforce Platform APIs / File Information

Back to Collection Items

-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    -- Important: Do not use nvarchar(max).  See the warning about using nvarchar(max).
    DECLARE @sTmp0 nvarchar(4000)
    -- This example assumes the Chilkat API to have been previously unlocked.
    -- See Global Unlock Sample for sample code.

    DECLARE @http int
    EXEC @hr = sp_OACreate 'Chilkat_9_5_0.Http', @http OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    DECLARE @success int

    -- Adds the "Authorization: Bearer <access_token>" header.
    EXEC sp_OASetProperty @http, 'AuthToken', '<access_token>'

    DECLARE @sbResponseBody int
    EXEC @hr = sp_OACreate 'Chilkat_9_5_0.StringBuilder', @sbResponseBody OUT

    EXEC sp_OAMethod @http, 'QuickGetSb', @success OUT, 'https://domain.com/services/data/v{{version}}/connect/files/:FILE_ID', @sbResponseBody
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @http
        EXEC @hr = sp_OADestroy @sbResponseBody
        RETURN
      END

    DECLARE @jResp int
    EXEC @hr = sp_OACreate 'Chilkat_9_5_0.JsonObject', @jResp OUT

    EXEC sp_OAMethod @jResp, 'LoadSb', @success OUT, @sbResponseBody
    EXEC sp_OASetProperty @jResp, 'EmitCompact', 0


    PRINT 'Response Body:'
    EXEC sp_OAMethod @jResp, 'Emit', @sTmp0 OUT
    PRINT @sTmp0

    DECLARE @respStatusCode int
    EXEC sp_OAGetProperty @http, 'LastStatus', @respStatusCode OUT

    PRINT 'Response Status Code = ' + @respStatusCode
    IF @respStatusCode >= 400
      BEGIN

        PRINT 'Response Header:'
        EXEC sp_OAGetProperty @http, 'LastHeader', @sTmp0 OUT
        PRINT @sTmp0

        PRINT 'Failed.'
        EXEC @hr = sp_OADestroy @http
        EXEC @hr = sp_OADestroy @sbResponseBody
        EXEC @hr = sp_OADestroy @jResp
        RETURN
      END

    -- Sample JSON response:
    -- (Sample code for parsing the JSON response is shown below)

    -- {
    --   "checksum": "71a50dbba44c78128b221b7df7bb51f1",
    --   "contentHubRepository": null,
    --   "contentModifiedDate": "2023-11-20T16:28:22.000Z",
    --   "contentSize": 95,
    --   "contentUrl": null,
    --   "createdDate": "2023-11-20T16:28:22.000Z",
    --   "description": null,
    --   "downloadUrl": "/services/data/v58.0/connect/files/069.../content?versionNumber=1",
    --   "externalDocumentUrl": null,
    --   "externalFilePermissionInformation": null,
    --   "fileAsset": null,
    --   "fileExtension": "png",
    --   "fileType": "Png",
    --   "flashRenditionStatus": "Na",
    --   "id": "069...",
    --   "isFileAsset": false,
    --   "isInMyFileSync": false,
    --   "isMajorVersion": true,
    --   "mimeType": "image/png",
    --   "moderationFlags": null,
    --   "modifiedDate": "2023-11-20T16:28:22.000Z",
    --   "motif": {
    --     "color": "939393",
    --     "largeIconUrl": "/img/content/content64.png",
    --     "mediumIconUrl": "/img/content/content32.png",
    --     "smallIconUrl": "/img/icon/files16.png",
    --     "svgIconUrl": null
    --   },
    --   "mySubscription": null,
    --   "name": "1x1.png",
    --   "origin": "Chatter",
    --   "owner": {
    --     "additionalLabel": null,
    --     "communityNickname": "User1696423780773910041",
    --     "companyName": "Salesforce",
    --     "displayName": "Name",
    --     "firstName": "firstName",
    --     "id": "005...",
    --     "isActive": true,
    --     "isInThisCommunity": true,
    --     "lastName": "Name",
    --     "motif": {
    --       "color": "1B96FF",
    --       "largeIconUrl": "/img/icon/profile64.png",
    --       "mediumIconUrl": "/img/icon/profile32.png",
    --       "smallIconUrl": "/img/icon/profile16.png",
    --       "svgIconUrl": null
    --     },
    --     "mySubscription": null,
    --     "name": "Name",
    --     "outOfOffice": {
    --       "message": ""
    --     },
    --     "photo": {
    --       "fullEmailPhotoUrl": "https://<my_domain>/ncsphoto/1wsMlOd3tVC7boygqBO8wMT9KzA0D6tqzpbs-Uw0IogXzXAXaYKJnuWCNQmXymRq?fromEmail=1",
    --       "largePhotoUrl": "https://<my_domain>/profilephoto/729.../F",
    --       "mediumPhotoUrl": "https://<my_domain>/profilephoto/729.../M",
    --       "photoVersionId": "729...",
    --       "smallPhotoUrl": "https://<my_domain>/profilephoto/729.../T",
    --       "standardEmailPhotoUrl": "https://<my_domain>/ncsphoto/1wsMlOd3tVC7boygqBO8wMT9KzA0D6tqzpbs-Uw0Ioi-dtynkoFWsl46as__TDFU?fromEmail=1",
    --       "url": "/services/data/v58.0/connect/user-profiles/005.../photo"
    --     },
    --     "reputation": null,
    --     "title": null,
    --     "type": "User",
    --     "url": "/services/data/v58.0/chatter/users/005...",
    --     "userType": "Internal"
    --   },
    --   "pageCount": 0,
    --   "parentFolder": null,
    --   "pdfRenditionStatus": "Na",
    --   "publishStatus": "PrivateAccess",
    --   "renditionUrl": "/services/data/v58.0/connect/files/069.../rendition?type=THUMB120BY90",
    --   "renditionUrl240By180": "/services/data/v58.0/connect/files/069.../rendition?type=THUMB240BY180",
    --   "renditionUrl720By480": "/services/data/v58.0/connect/files/069.../rendition?type=THUMB720BY480",
    --   "repositoryFileId": null,
    --   "repositoryFileUrl": null,
    --   "sharingOption": "Allowed",
    --   "sharingPrivacy": "None",
    --   "sharingRole": "Owner",
    --   "systemModstamp": "2023-11-20T16:28:23.000Z",
    --   "textPreview": null,
    --   "thumb120By90RenditionStatus": "NotScheduled",
    --   "thumb240By180RenditionStatus": "NotScheduled",
    --   "thumb720By480RenditionStatus": "NotScheduled",
    --   "title": "1x1.png",
    --   "topics": {
    --     "currentPageUrl": null,
    --     "nextPageUrl": null,
    --     "topics": [
    --     ]
    --   },
    --   "type": "File",
    --   "url": "/services/data/v58.0/connect/files/069...?versionNumber=1",
    --   "versionNumber": "1"
    -- }

    -- Sample code for parsing the JSON response...
    -- Use this online tool to generate parsing code from sample JSON: Generate JSON Parsing Code

    DECLARE @checksum nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @checksum OUT, 'checksum'
    DECLARE @contentHubRepository nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @contentHubRepository OUT, 'contentHubRepository'
    DECLARE @contentModifiedDate nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @contentModifiedDate OUT, 'contentModifiedDate'
    DECLARE @contentSize int
    EXEC sp_OAMethod @jResp, 'IntOf', @contentSize OUT, 'contentSize'
    DECLARE @contentUrl nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @contentUrl OUT, 'contentUrl'
    DECLARE @createdDate nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @createdDate OUT, 'createdDate'
    DECLARE @description nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @description OUT, 'description'
    DECLARE @downloadUrl nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @downloadUrl OUT, 'downloadUrl'
    DECLARE @externalDocumentUrl nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @externalDocumentUrl OUT, 'externalDocumentUrl'
    DECLARE @externalFilePermissionInformation nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @externalFilePermissionInformation OUT, 'externalFilePermissionInformation'
    DECLARE @fileAsset nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @fileAsset OUT, 'fileAsset'
    DECLARE @fileExtension nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @fileExtension OUT, 'fileExtension'
    DECLARE @fileType nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @fileType OUT, 'fileType'
    DECLARE @flashRenditionStatus nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @flashRenditionStatus OUT, 'flashRenditionStatus'
    DECLARE @id nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @id OUT, 'id'
    DECLARE @isFileAsset int
    EXEC sp_OAMethod @jResp, 'BoolOf', @isFileAsset OUT, 'isFileAsset'
    DECLARE @isInMyFileSync int
    EXEC sp_OAMethod @jResp, 'BoolOf', @isInMyFileSync OUT, 'isInMyFileSync'
    DECLARE @isMajorVersion int
    EXEC sp_OAMethod @jResp, 'BoolOf', @isMajorVersion OUT, 'isMajorVersion'
    DECLARE @mimeType nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @mimeType OUT, 'mimeType'
    DECLARE @moderationFlags nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @moderationFlags OUT, 'moderationFlags'
    DECLARE @modifiedDate nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @modifiedDate OUT, 'modifiedDate'
    DECLARE @Color nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @Color OUT, 'motif.color'
    DECLARE @LargeIconUrl nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @LargeIconUrl OUT, 'motif.largeIconUrl'
    DECLARE @MediumIconUrl nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @MediumIconUrl OUT, 'motif.mediumIconUrl'
    DECLARE @SmallIconUrl nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @SmallIconUrl OUT, 'motif.smallIconUrl'
    DECLARE @SvgIconUrl nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @SvgIconUrl OUT, 'motif.svgIconUrl'
    DECLARE @mySubscription nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @mySubscription OUT, 'mySubscription'
    DECLARE @name nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @name OUT, 'name'
    DECLARE @origin nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @origin OUT, 'origin'
    DECLARE @AdditionalLabel nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @AdditionalLabel OUT, 'owner.additionalLabel'
    DECLARE @CommunityNickname nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @CommunityNickname OUT, 'owner.communityNickname'
    DECLARE @CompanyName nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @CompanyName OUT, 'owner.companyName'
    DECLARE @DisplayName nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @DisplayName OUT, 'owner.displayName'
    DECLARE @FirstName nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @FirstName OUT, 'owner.firstName'
    DECLARE @Id nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @Id OUT, 'owner.id'
    DECLARE @IsActive int
    EXEC sp_OAMethod @jResp, 'BoolOf', @IsActive OUT, 'owner.isActive'
    DECLARE @IsInThisCommunity int
    EXEC sp_OAMethod @jResp, 'BoolOf', @IsInThisCommunity OUT, 'owner.isInThisCommunity'
    DECLARE @LastName nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @LastName OUT, 'owner.lastName'
    DECLARE @MotifColor nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @MotifColor OUT, 'owner.motif.color'
    DECLARE @MotifLargeIconUrl nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @MotifLargeIconUrl OUT, 'owner.motif.largeIconUrl'
    DECLARE @MotifMediumIconUrl nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @MotifMediumIconUrl OUT, 'owner.motif.mediumIconUrl'
    DECLARE @MotifSmallIconUrl nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @MotifSmallIconUrl OUT, 'owner.motif.smallIconUrl'
    DECLARE @MotifSvgIconUrl nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @MotifSvgIconUrl OUT, 'owner.motif.svgIconUrl'
    DECLARE @MySubscription nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @MySubscription OUT, 'owner.mySubscription'
    DECLARE @Name nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @Name OUT, 'owner.name'
    DECLARE @Message nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @Message OUT, 'owner.outOfOffice.message'
    DECLARE @FullEmailPhotoUrl nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @FullEmailPhotoUrl OUT, 'owner.photo.fullEmailPhotoUrl'
    DECLARE @LargePhotoUrl nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @LargePhotoUrl OUT, 'owner.photo.largePhotoUrl'
    DECLARE @MediumPhotoUrl nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @MediumPhotoUrl OUT, 'owner.photo.mediumPhotoUrl'
    DECLARE @PhotoVersionId nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @PhotoVersionId OUT, 'owner.photo.photoVersionId'
    DECLARE @SmallPhotoUrl nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @SmallPhotoUrl OUT, 'owner.photo.smallPhotoUrl'
    DECLARE @StandardEmailPhotoUrl nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @StandardEmailPhotoUrl OUT, 'owner.photo.standardEmailPhotoUrl'
    DECLARE @v_Url nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @v_Url OUT, 'owner.photo.url'
    DECLARE @Reputation nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @Reputation OUT, 'owner.reputation'
    DECLARE @Title nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @Title OUT, 'owner.title'
    DECLARE @v_Type nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @v_Type OUT, 'owner.type'
    DECLARE @ownerUrl nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @ownerUrl OUT, 'owner.url'
    DECLARE @UserType nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @UserType OUT, 'owner.userType'
    DECLARE @pageCount int
    EXEC sp_OAMethod @jResp, 'IntOf', @pageCount OUT, 'pageCount'
    DECLARE @parentFolder nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @parentFolder OUT, 'parentFolder'
    DECLARE @pdfRenditionStatus nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @pdfRenditionStatus OUT, 'pdfRenditionStatus'
    DECLARE @publishStatus nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @publishStatus OUT, 'publishStatus'
    DECLARE @renditionUrl nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @renditionUrl OUT, 'renditionUrl'
    DECLARE @renditionUrl240By180 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @renditionUrl240By180 OUT, 'renditionUrl240By180'
    DECLARE @renditionUrl720By480 nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @renditionUrl720By480 OUT, 'renditionUrl720By480'
    DECLARE @repositoryFileId nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @repositoryFileId OUT, 'repositoryFileId'
    DECLARE @repositoryFileUrl nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @repositoryFileUrl OUT, 'repositoryFileUrl'
    DECLARE @sharingOption nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @sharingOption OUT, 'sharingOption'
    DECLARE @sharingPrivacy nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @sharingPrivacy OUT, 'sharingPrivacy'
    DECLARE @sharingRole nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @sharingRole OUT, 'sharingRole'
    DECLARE @systemModstamp nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @systemModstamp OUT, 'systemModstamp'
    DECLARE @textPreview nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @textPreview OUT, 'textPreview'
    DECLARE @thumb120By90RenditionStatus nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @thumb120By90RenditionStatus OUT, 'thumb120By90RenditionStatus'
    DECLARE @thumb240By180RenditionStatus nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @thumb240By180RenditionStatus OUT, 'thumb240By180RenditionStatus'
    DECLARE @thumb720By480RenditionStatus nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @thumb720By480RenditionStatus OUT, 'thumb720By480RenditionStatus'
    DECLARE @title nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @title OUT, 'title'
    DECLARE @CurrentPageUrl nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @CurrentPageUrl OUT, 'topics.currentPageUrl'
    DECLARE @NextPageUrl nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @NextPageUrl OUT, 'topics.nextPageUrl'
    DECLARE @v_type nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @v_type OUT, 'type'
    DECLARE @url nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @url OUT, 'url'
    DECLARE @versionNumber nvarchar(4000)
    EXEC sp_OAMethod @jResp, 'StringOf', @versionNumber OUT, 'versionNumber'
    DECLARE @i int
    SELECT @i = 0
    DECLARE @count_i int
    EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'topics.topics'
    WHILE @i < @count_i
      BEGIN
        EXEC sp_OASetProperty @jResp, 'I', @i
        SELECT @i = @i + 1
      END

    EXEC @hr = sp_OADestroy @http
    EXEC @hr = sp_OADestroy @sbResponseBody
    EXEC @hr = sp_OADestroy @jResp


END
GO

Curl Command

curl -X GET
	-H "Authorization: Bearer <access_token>"
https://domain.com/services/data/v{{version}}/connect/files/:FILE_ID

Postman Collection Item JSON

{
  "name": "File Information",
  "event": [
    {
      "listen": "prerequest",
      "script": {
        "exec": [
          ""
        ],
        "type": "text/javascript"
      }
    },
    {
      "listen": "test",
      "script": {
        "exec": [
          ""
        ],
        "type": "text/javascript"
      }
    }
  ],
  "protocolProfileBehavior": {
    "disabledSystemHeaders": {}
  },
  "request": {
    "method": "GET",
    "header": [
    ],
    "url": {
      "raw": "{{_endpoint}}/services/data/v{{version}}/connect/files/:FILE_ID",
      "host": [
        "{{_endpoint}}"
      ],
      "path": [
        "services",
        "data",
        "v{{version}}",
        "connect",
        "files",
        ":FILE_ID"
      ],
      "variable": [
        {
          "key": "FILE_ID",
          "value": ""
        }
      ]
    },
    "description": "Get information about a specified file, including references to external files. Upload a new version of an existing file, including references to external files. Rename a file, move a file to a different folder, and delete a file.\nTo upload a new version of an existing file, make a POST request. Upload the new version as a binary part in a multipart/form-data request. See Uploading Binary Files. To upload a new file to the Files home, use /connect/files/users/me.Get information about a specified file, including references to external files.\nhttps://developer.salesforce.com/docs/atlas.en-us.chatterapi.meta/chatterapi/connect_resources_files_information.htm"
  },
  "response": [
    {
      "name": "File Information",
      "originalRequest": {
        "method": "GET",
        "header": [
        ],
        "url": {
          "raw": "{{_endpoint}}/services/data/v{{version}}/connect/files/:FILE_ID",
          "host": [
            "{{_endpoint}}"
          ],
          "path": [
            "services",
            "data",
            "v{{version}}",
            "connect",
            "files",
            ":FILE_ID"
          ],
          "variable": [
            {
              "key": "FILE_ID",
              "value": "0692o00000woaKjAAI"
            }
          ]
        }
      },
      "status": "OK",
      "code": 200,
      "_postman_previewlanguage": "json",
      "header": [
        {
          "key": "Date",
          "value": "Mon, 20 Nov 2023 16:33:38 GMT"
        },
        {
          "key": "Strict-Transport-Security",
          "value": "max-age=63072000; includeSubDomains"
        },
        {
          "key": "X-Content-Type-Options",
          "value": "nosniff"
        },
        {
          "key": "X-XSS-Protection",
          "value": "1; mode=block"
        },
        {
          "key": "X-Robots-Tag",
          "value": "none"
        },
        {
          "key": "Cache-Control",
          "value": "no-cache,must-revalidate,max-age=0,no-store,private"
        },
        {
          "key": "Content-Type",
          "value": "application/json;charset=UTF-8"
        },
        {
          "key": "Vary",
          "value": "Accept-Encoding"
        },
        {
          "key": "Content-Encoding",
          "value": "gzip"
        },
        {
          "key": "Transfer-Encoding",
          "value": "chunked"
        }
      ],
      "cookie": [
      ],
      "body": "{\n    \"checksum\": \"71a50dbba44c78128b221b7df7bb51f1\",\n    \"contentHubRepository\": null,\n    \"contentModifiedDate\": \"2023-11-20T16:28:22.000Z\",\n    \"contentSize\": 95,\n    \"contentUrl\": null,\n    \"createdDate\": \"2023-11-20T16:28:22.000Z\",\n    \"description\": null,\n    \"downloadUrl\": \"/services/data/v58.0/connect/files/069.../content?versionNumber=1\",\n    \"externalDocumentUrl\": null,\n    \"externalFilePermissionInformation\": null,\n    \"fileAsset\": null,\n    \"fileExtension\": \"png\",\n    \"fileType\": \"Png\",\n    \"flashRenditionStatus\": \"Na\",\n    \"id\": \"069...\",\n    \"isFileAsset\": false,\n    \"isInMyFileSync\": false,\n    \"isMajorVersion\": true,\n    \"mimeType\": \"image/png\",\n    \"moderationFlags\": null,\n    \"modifiedDate\": \"2023-11-20T16:28:22.000Z\",\n    \"motif\": {\n        \"color\": \"939393\",\n        \"largeIconUrl\": \"/img/content/content64.png\",\n        \"mediumIconUrl\": \"/img/content/content32.png\",\n        \"smallIconUrl\": \"/img/icon/files16.png\",\n        \"svgIconUrl\": null\n    },\n    \"mySubscription\": null,\n    \"name\": \"1x1.png\",\n    \"origin\": \"Chatter\",\n    \"owner\": {\n        \"additionalLabel\": null,\n        \"communityNickname\": \"User1696423780773910041\",\n        \"companyName\": \"Salesforce\",\n        \"displayName\": \"Name\",\n        \"firstName\": \"firstName\",\n        \"id\": \"005...\",\n        \"isActive\": true,\n        \"isInThisCommunity\": true,\n        \"lastName\": \"Name\",\n        \"motif\": {\n            \"color\": \"1B96FF\",\n            \"largeIconUrl\": \"/img/icon/profile64.png\",\n            \"mediumIconUrl\": \"/img/icon/profile32.png\",\n            \"smallIconUrl\": \"/img/icon/profile16.png\",\n            \"svgIconUrl\": null\n        },\n        \"mySubscription\": null,\n        \"name\": \"Name\",\n        \"outOfOffice\": {\n            \"message\": \"\"\n        },\n        \"photo\": {\n            \"fullEmailPhotoUrl\": \"https://<my_domain>/ncsphoto/1wsMlOd3tVC7boygqBO8wMT9KzA0D6tqzpbs-Uw0IogXzXAXaYKJnuWCNQmXymRq?fromEmail=1\",\n            \"largePhotoUrl\": \"https://<my_domain>/profilephoto/729.../F\",\n            \"mediumPhotoUrl\": \"https://<my_domain>/profilephoto/729.../M\",\n            \"photoVersionId\": \"729...\",\n            \"smallPhotoUrl\": \"https://<my_domain>/profilephoto/729.../T\",\n            \"standardEmailPhotoUrl\": \"https://<my_domain>/ncsphoto/1wsMlOd3tVC7boygqBO8wMT9KzA0D6tqzpbs-Uw0Ioi-dtynkoFWsl46as__TDFU?fromEmail=1\",\n            \"url\": \"/services/data/v58.0/connect/user-profiles/005.../photo\"\n        },\n        \"reputation\": null,\n        \"title\": null,\n        \"type\": \"User\",\n        \"url\": \"/services/data/v58.0/chatter/users/005...\",\n        \"userType\": \"Internal\"\n    },\n    \"pageCount\": 0,\n    \"parentFolder\": null,\n    \"pdfRenditionStatus\": \"Na\",\n    \"publishStatus\": \"PrivateAccess\",\n    \"renditionUrl\": \"/services/data/v58.0/connect/files/069.../rendition?type=THUMB120BY90\",\n    \"renditionUrl240By180\": \"/services/data/v58.0/connect/files/069.../rendition?type=THUMB240BY180\",\n    \"renditionUrl720By480\": \"/services/data/v58.0/connect/files/069.../rendition?type=THUMB720BY480\",\n    \"repositoryFileId\": null,\n    \"repositoryFileUrl\": null,\n    \"sharingOption\": \"Allowed\",\n    \"sharingPrivacy\": \"None\",\n    \"sharingRole\": \"Owner\",\n    \"systemModstamp\": \"2023-11-20T16:28:23.000Z\",\n    \"textPreview\": null,\n    \"thumb120By90RenditionStatus\": \"NotScheduled\",\n    \"thumb240By180RenditionStatus\": \"NotScheduled\",\n    \"thumb720By480RenditionStatus\": \"NotScheduled\",\n    \"title\": \"1x1.png\",\n    \"topics\": {\n        \"currentPageUrl\": null,\n        \"nextPageUrl\": null,\n        \"topics\": []\n    },\n    \"type\": \"File\",\n    \"url\": \"/services/data/v58.0/connect/files/069...?versionNumber=1\",\n    \"versionNumber\": \"1\"\n}"
    }
  ]
}