How to get fields of enterprise Task/Project/Resource of SharePoint in JSOM or JavaScript?

Get field of enterprise Task/Project/Resource of SharePoint in JSOM or JavaScript:


Use the below snippet all fields/column of Task using JSOM.

<script type="text/javascript" src="_layouts/15/sp.js"></script>
<script type="text/javascript" src="_layouts/15/ps.js"></script>

<script type="text/javascript" >
var Fields = [];

function getFields (from, type) {
    // console.log(type);

    console.log('Getting all fields');
    // Initialize the current client context. 
    var filcontext = PS.ProjectContext.get_current();
    var allFields = filcontext.get_customFields();
    filcontext.load(allFields, "Include(Id, Name, EntityType, InternalName, FieldType, Formula)");
    filcontext.executeQueryAsync(OnRequestSuccess, OnRequestFailed);
    // Callback for request failure
    function OnRequestFailed (sender, args) {
        console.log(args.get_message());
    };
    function OnRequestSuccess(){

        var collection_enumerator = allFields.getEnumerator();
        var count = 0;
        while (collection_enumerator.moveNext()) {
            var id = collection_enumerator.get_current().get_id();
            var name = collection_enumerator.get_current().get_name();
            var nameWOSpace = collection_enumerator.get_current().get_name();
            var entityType = collection_enumerator.get_current().get_entityType().get_name();
            var internalName = collection_enumerator.get_current().get_internalName();
            var fieldTypeVal = collection_enumerator.get_current().get_fieldType();
            var formula = collection_enumerator.get_current().get_formula();
            console.log('Entity Type : '+ entityType);
            if (entityType == type && formula == null) {
                if (fieldTypeVal == '9' || fieldTypeVal == '4' || fieldTypeVal == '15' || fieldTypeVal == '17' || fieldTypeVal == '21') {
                    var fieldType = '';
                    if (fieldTypeVal == '21') {
                        fieldType = 'TEXT';
                    } else if (fieldTypeVal == '15') {
                        fieldType = 'NUMBER';
                    } else if (fieldTypeVal == '17') {
                        fieldType = 'FLAG';
                    } else if (fieldTypeVal == '4') {
                        fieldType = 'DATE';
                    } else if (fieldTypeVal == '9') {
                        fieldType = 'NUMBER';
                    }
                    Fields.push({
                        'id': id,
                        'colInternalName': internalName,
                        'colName': name,
                        'colType': fieldType,
                        'isLookup': false
                    });

                }
            }
        }
        console.log(Fields); //It will give us all field of except formula and lookup type 
    }
 }

getFields('OnLoad','Task');//This is call for Field of Tasks
//getFields('OnLoad','Resource');//This is call for Field of Task of Resource
//getFields('OnLoad','Project');//This is call for Fields of Project

</script>

Comments

Post a Comment

Popular posts from this blog

Get list item entity type full name of a SharePoint list using REST API

Image
Get list item entity type full name of a SharePoint list using REST API : Follow the below steps to get ListItemEntityTypeFullName which must required for adding/updating items/records to the server or the SharePoint list. 1) First user/developer need logged in to the SharePoint site and then copy any of below URL/API. 2) Replace the _spPageContextInfo.webAbsoluteURL or siteurl (absolute URL) with the URL of you site for example. siteurl = https://testcompany.sharepoint.com/sites/testsite1 3) and replace SharePoint ListName = Payments or you original list name 4) Finally hit or place the complete URL/API API = https://testcompany.sharepoint.com/sites/testsite1/_api/Web/Lists/getbytitle('Students')/ListItemEntityTypeFullName into the browser search bar/box and click on enter button from keyboard then you will able to see output as shown in Output below   _spPageContextInfo.webAbsoluteUrl + "/_api/Web/Lists/getbytitle('ListName')/items?select=EntityTypeFullName OR s...
Read more

Get SharePoint list name by GUID

Image
 Get SharePoint list name by GUID in jQuery: Use the below snippet code to get the name of list by using listGuid . To do so replace the below list guid with your SP list GUID. var listGuid = "aa4774cf-oa71-83e4-6a67-01b53d5a7y6i2";//use your own SP site list guid getlistNameByGUID(listGuid); function getlistNameByGUID(guid) { $.ajax({         url: _spPageContextInfo.siteAbsoluteUrl + "/_api/Web/Lists(guid'"+listGuid+"')",         method: "GET",         headers: { "Accept": "application/json; odata=verbose" },         success: function (data) {              console.log(data.d.Title);         },         error: function (e) {             console.log(e)         }   }); } Output: Company//list name of my sp site  Was this helpful? Comment you suggestions and share it with yo...
Read more

Get Current Web Logged In User of SharePoint Site in jQuery

Get Current web logged in User of a SharePoint site in jQuery: Use the below snippet and just replace the jQuery library URL and run on you SharePoint page. <script src="../Assets/Jquery/jquery-1.9.1.min.js"></script> <script > function getCurrentLogInUser(){ $.ajax({     url: _spPageContextInfo.webServerRelativeUrl + "/_api/web/currentuser",     type: "GET",     async:false,     headers: { "Accept": "application/json;odata=verbose" } }).success(function( data ){     console.log( data );     console.log( data.d.Title ); }).error(function(e){     console.log( e ); }); } getCurrentLogInUser(); </script> Output:
Read more