Welcome to Office 365 APIs | Microsoft Docs
Skip to main content

Office 365 APIs

This site contains the documentation for Office 365 REST APIs exposed on the OneNote and Outlook endpoints. The documentation is no longer actively updated. It is here for your reference, in case you have already included any of the API in your project.

Office 365 services, such as OneNote, Outlook, Excel, OneDrive, Microsoft Teams, Planner, and SharePoint, are now exposed in Microsoft Graph. Microsoft Graph is a unified API endpoint for accessing data across Microsoft 365, which includes Office 365, Enterprise Mobility, and Security and Windows services. It provides a simplified developer experience, with one endpoint and a single authentication token that gives your app access to data across all these services.

Our recommendation:

  • If you are starting a new app, please use Microsoft Graph.
  • If you are maintaining an existing project, use this documentation set for reference. In addition, plan your move to the latest APIs in Microsoft Graph to take advantage of all the new functionality and innovation there.
  • If you are adding new functionality to an existing project, integrate that new functionality by using Microsoft Graph.

With Microsoft Graph, you can access Office 365 data and more, from solutions across mobile, web, and desktop platforms. So whether you're building web applications by using .NET, PHP, Java, Python, or Ruby on Rails, or creating apps for the Universal Windows Platform (UWP), iOS, Android, or on another device platform, it's your choice.

In this section

 none
How to get Internal names of columns in sharepoint lists? RRS feed

  • Question

  • 1) I want to get the internal name of the column of sharepoint list.

    2) This may possible that the internal name may contains spacesa and special symbols.

    3) I want to pass a display name of a column and get it's internal name.

    4) It is using webservice to fetch the list data in a seperate .Net [workbook] application.

     

    • Edited by ooday Tuesday, December 7, 2010 6:15 AM
    Monday, December 6, 2010 12:12 PM

Answers

  • You can get the internal name for a column by browsing to the List Settings > Edit Column and look at the QueryString.  This will be url encoded but is a simple way of retrieving the internal name without writing any code.  You will get something like:

    /_layouts/FldEdit.aspx?List=%7B37920121%2D19B2%2D4C77%2D92FF%2D8B3E07853114%7D&Field=Product%5Fx0020%5FDescription

    %5F is a '_'.  The field name is Product_x0020_Description.

    The code option is to use:

    string itemInternalName = item.Fields["Field Display Name"].InternalName;

    Hope this helps

    Dave


    My SharePoint Blog - http://www.davehunter.co.uk/blog
    Monday, December 6, 2010 12:28 PM

All replies

  • You can get the internal name for a column by browsing to the List Settings > Edit Column and look at the QueryString.  This will be url encoded but is a simple way of retrieving the internal name without writing any code.  You will get something like:

    /_layouts/FldEdit.aspx?List=%7B37920121%2D19B2%2D4C77%2D92FF%2D8B3E07853114%7D&Field=Product%5Fx0020%5FDescription

    %5F is a '_'.  The field name is Product_x0020_Description.

    The code option is to use:

    string itemInternalName = item.Fields["Field Display Name"].InternalName;

    Hope this helps

    Dave


    My SharePoint Blog - http://www.davehunter.co.uk/blog
    Monday, December 6, 2010 12:28 PM
  • HI,

    Refer below link, which may useful for you.

    http://www.sharepointdevwiki.com/display/public/Getting+the+Field+by+the+Internal+Name


    Thanks & Regards, Neerubee
    Monday, December 6, 2010 12:40 PM
  • Hi,

    Thanks to Dave's reply. You can follow Dave's way but I would like to share mine as well.

    http://www.u2u.net/res/Tools/CamlQueryBuilder.aspx

    Download this utility and open your desired sharepoint site, pick up the desired list, scroll for columns for that list (should appear in dropdownlist) and build a simple query. It will always show you the column internal names [ like  <FieldRef Name='Product_x0020_Info' /> ] and also a handy tool for building CAML queries as well which you might need in future.

    Thanks


    Operation completed successfully. ========== Deploy: 1 succeeded, 0 failed, 0 skipped ==========
    Monday, December 6, 2010 12:45 PM
  • It doesn't use List Settings, but here is my quick method of uncovering the internal name of a column.  For the list in question, open the New item form.  View the source of the form and search for "FieldInternalName".  Each field on the form has a commented area that contains the Fieldname, FieldInternalName, and FieldType.  Here is an example:

    <!-- FieldName="Comments"
    FieldInternalName="Comments"
    FieldType="SPFieldNote"
      -->
    Hope this helps...
    - Tom
    • Proposed as answer by Lavish0610 Wednesday, March 19, 2014 8:36 PM
    Monday, December 6, 2010 1:59 PM
  • Hi Sharepoint Tom,

    I know my method does not use List Settings but CAML utility is a good way to find internal names (I thought I should share). I use to follow your method before and it is also a good one. Thanks for sharing.

    Thanks


    Operation completed successfully. ========== Deploy: 1 succeeded, 0 failed, 0 skipped ==========
    Monday, December 6, 2010 2:14 PM
  • Thanks for you reply buddies
    Tuesday, December 7, 2010 6:16 AM
  • One thing I found is that Internal names are sometimes truncated.  I created a field called "Expected Remediation Date" and SharePoint truncated the internal name to "Expected_x0020_Remediation_x0020"

    Basically left off the "_Date".

    Wednesday, November 28, 2012 12:57 PM
  • You can use the InternalName property to get this details, check the article "How to get Internal names of columns in sharepoint lists" at http://tad.co.in/?p=919

    http://tad.co.in

    Wednesday, December 5, 2012 9:12 AM
  • SharePoint List Display Name and Internal Column Name Exporter PowerShell Script(FREE Download)

    In a SharePoint list, we usually use the user friendly (readable) names in list columns or fields. Each column has a display name and internal name which we also call as physical name of the column / field.

    There are not many options for how to get the internal name and the easiest way is to copy it from the query string. This can be time consuming and error prone especially when working with many columns in a list.

    The following PowerShell script will Export the SharePoint Column Display Name and Internal Name into a text file. This can then be used to create your document templates for SharePoint Document Merge (to automate document creation from SharePoint list data) or for any other Internal Column Name requirements (workflow, triggers etc...)

    Get PowerShell script: http://sharepointlists.com/getinternalcolumnnames.html
    Tuesday, December 18, 2018 10:35 PM
  • The following PowerShell script will Export the SharePoint Column Display Name and Internal Name into a text file. This can then be used to create your document templates for SharePoint Document Merge (to automate document creation from SharePoint list data) or for any other Internal Column Name requirements (workflow, triggers etc...)

    Get PowerShell script: http://sharepointlists.com/getinternalcolumnnames.html
    Tuesday, December 18, 2018 10:36 PM
Welcome to Office 365 APIs | Microsoft Docs
Skip to main content

Office 365 APIs

This site contains the documentation for Office 365 REST APIs exposed on the OneNote and Outlook endpoints. The documentation is no longer actively updated. It is here for your reference, in case you have already included any of the API in your project.

Office 365 services, such as OneNote, Outlook, Excel, OneDrive, Microsoft Teams, Planner, and SharePoint, are now exposed in Microsoft Graph. Microsoft Graph is a unified API endpoint for accessing data across Microsoft 365, which includes Office 365, Enterprise Mobility, and Security and Windows services. It provides a simplified developer experience, with one endpoint and a single authentication token that gives your app access to data across all these services.

Our recommendation:

  • If you are starting a new app, please use Microsoft Graph.
  • If you are maintaining an existing project, use this documentation set for reference. In addition, plan your move to the latest APIs in Microsoft Graph to take advantage of all the new functionality and innovation there.
  • If you are adding new functionality to an existing project, integrate that new functionality by using Microsoft Graph.

With Microsoft Graph, you can access Office 365 data and more, from solutions across mobile, web, and desktop platforms. So whether you're building web applications by using .NET, PHP, Java, Python, or Ruby on Rails, or creating apps for the Universal Windows Platform (UWP), iOS, Android, or on another device platform, it's your choice.

In this section