Implementing Salesforce REST API Techniques

Nov 28, 2023


 

 

After completing this unit, you will able to:

1.  Introduction

2.  What is REST API?

3.  Authentication

4.  Get all object REST API

5.  Get sobject with all fields REST API

6.  Get All Fields Property using SOQL

7.  Get specific field property

8.  Retrieve all objects in an org

9.  Retrieve all fields from a standard object

 

 

1.  Introduction

In the dynamic landscape of Salesforce development, the ability to seamlessly integrate external systems and exchange data is a cornerstone of success. One of the most powerful tools in a Salesforce developer's toolkit is the REST API—a versatile and efficient way to connect and communicate with Salesforce services.

This blog post aims to be your comprehensive guide to mastering REST API integration within the Salesforce environment. Whether you're a seasoned developer looking to enhance your skills or a newcomer eager to unlock the full potential of Salesforce, this step-by-step guide will walk you through the intricacies of implementing RESTful API calls.

Get ready to embark on a journey of discovery as we demystify the complexities of REST API integration in Salesforce. By the end of this guide, you'll be equipped with the knowledge and confidence to harness the full power of RESTful communication within your Salesforce applications. Let's dive in and elevate your Salesforce development skills to new heights!

 

 

2.  What is REST API?

REST API, which stands for Representational State Transfer Application Programming Interface, is a set of architectural principles for designing networked applications. It is an approach to building web services that are lightweight, scalable, and maintainable. REST is not a protocol but rather a set of constraints and principles that, when followed, help in creating efficient, scalable, and flexible web services.

 

 

3.  Authentication

Before diving into Tooling API calls, it's crucial to understand the authentication process. Salesforce uses OAuth 2.0 for authentication, ensuring secure access to your org's metadata. Developers need to obtain a valid access token through the OAuth flow to make authorized requests to the Tooling API.

Get the access token in postman using this link: Get Access Token in Postman

 

 

4.  Get all object REST API

The Get All Objects API call allows developers to retrieve metadata information about all standard and custom objects in their Salesforce org. This information includes details such as object names, labels, fields, and various metadata attributes. This API call is particularly useful when building dynamic applications that need to adapt to changes in the Salesforce schema or when performing introspection of the org's structure.

URL: baseUrl/services/data/v58.0/sobject

 

 

Response:

 

 

5.  Get sobject with all fields REST API

 URL: baseUrl/services/data/v58.0/sobjects/Opportunity/describe

 

 

 Response:

 

 

6.  Get All Fields Property using SOQL

 URL: baseUrl/services/data/v56.0/query/?q=SELECT DeveloperName,QualifiedApiName,NewUrl,(SELECT Id, MasterLabel, DeveloperName, QualifiedApiName, Length, DataType, Description FROM Fields) FROM EntityDefinition WHERE QualifiedApiName = 'Lead'

 

 

 Response:

 

 

7.  Get specific field property

 URL: baseUrl/services/data/v56.0/query/?q=SELECT DeveloperName,QualifiedApiName,NewUrl,(SELECT Id, MasterLabel, DeveloperName, Length, DataType FROM Fields WHERE DeveloperName = 'Text_Field') FROM EntityDefinition WHERE QualifiedApiName = 'Test_Custom_Object__c'

 

 

 Response:

 {

    "totalSize": 1,
    "done": true,
    "records": [
        {
            "attributes": {
                "type": "EntityDefinition",
                "url": "/services/data/v56.0/sobjects/EntityDefinition/01I5i000002KtNj"
            },
            "DeveloperName": "Test_Custom_Object",
            "QualifiedApiName": "Test_Custom_Object__c",
            "NewUrl": "/a0J/e",
            "Fields": {
                "totalSize": 1,
                "done": true,
                "records": [
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Text Field",
                        "DeveloperName": "Text_Field",
                        "Length": 255,
                        "DataType": "Text(255)"
                    }
                ]
            }
        }
    ]
}
 

 

 

8.  Retrieve all objects using SOQL

 URL: baseUrl/services/data/v56.0/query/?q=SELECT Label, PluralLabel, DeveloperName, QualifiedApiName FROM EntityDefinition

 

 

 Response:

 

 

9.  Retrieve all fields from a standard object

URL: baseUrl/services/data/v56.0/query/?q=SELECT DeveloperName, QualifiedApiName, NewUrl, (SELECT Id, MasterLabel, DeveloperName, QualifiedApiName, Length, DataType, Description FROM Fields) FROM EntityDefinition WHERE QualifiedApiName = 'Account'

 

 

 Response:

{
    "totalSize": 1,
    "done": true,
    "records": [
        {
            "attributes": {
                "type": "EntityDefinition",
                "url": "/services/data/v56.0/sobjects/EntityDefinition/Account"
            },
            "DeveloperName": "Account",
            "QualifiedApiName": "Account",
            "NewUrl": "/001/e",
            "Fields": {
                "totalSize": 76,
                "done": true,
                "records": [
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Account ID",
                        "DeveloperName": "Id",
                        "QualifiedApiName": "Id",
                        "Length": 18,
                        "DataType": "Lookup()",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Deleted",
                        "DeveloperName": "IsDeleted",
                        "QualifiedApiName": "IsDeleted",
                        "Length": 0,
                        "DataType": "Checkbox",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Account",
                        "DeveloperName": "MasterRecord",
                        "QualifiedApiName": "MasterRecordId",
                        "Length": 18,
                        "DataType": "Lookup(Account)",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Account Name",
                        "DeveloperName": "Name",
                        "QualifiedApiName": "Name",
                        "Length": 255,
                        "DataType": "Name",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Type",
                        "DeveloperName": "Type",
                        "QualifiedApiName": "Type",
                        "Length": 255,
                        "DataType": "Picklist",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Account Record Type",
                        "DeveloperName": "RecordType",
                        "QualifiedApiName": "RecordTypeId",
                        "Length": 18,
                        "DataType": "Record Type",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Parent Account",
                        "DeveloperName": "Parent",
                        "QualifiedApiName": "ParentId",
                        "Length": 18,
                        "DataType": "Hierarchy",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Billing Address",
                        "DeveloperName": "BillingAddress",
                        "QualifiedApiName": "BillingAddress",
                        "Length": 0,
                        "DataType": "Address",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Shipping Address",
                        "DeveloperName": "ShippingAddress",
                        "QualifiedApiName": "ShippingAddress",
                        "Length": 0,
                        "DataType": "Address",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Phone",
                        "DeveloperName": "Phone",
                        "QualifiedApiName": "Phone",
                        "Length": 40,
                        "DataType": "Phone",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Fax",
                        "DeveloperName": "Fax",
                        "QualifiedApiName": "Fax",
                        "Length": 40,
                        "DataType": "Fax",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Account Number",
                        "DeveloperName": "AccountNumber",
                        "QualifiedApiName": "AccountNumber",
                        "Length": 40,
                        "DataType": "Text(40)",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Website",
                        "DeveloperName": "Website",
                        "QualifiedApiName": "Website",
                        "Length": 255,
                        "DataType": "URL(255)",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Photo URL",
                        "DeveloperName": "PhotoUrl",
                        "QualifiedApiName": "PhotoUrl",
                        "Length": 255,
                        "DataType": "URL(255)",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "SIC Code",
                        "DeveloperName": "Sic",
                        "QualifiedApiName": "Sic",
                        "Length": 20,
                        "DataType": "Text(20)",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Industry",
                        "DeveloperName": "Industry",
                        "QualifiedApiName": "Industry",
                        "Length": 255,
                        "DataType": "Picklist",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Annual Revenue",
                        "DeveloperName": "AnnualRevenue",
                        "QualifiedApiName": "AnnualRevenue",
                        "Length": 0,
                        "DataType": "Currency(18, 0)",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Employees",
                        "DeveloperName": "NumberOfEmployees",
                        "QualifiedApiName": "NumberOfEmployees",
                        "Length": 0,
                        "DataType": "Number(8, 0)",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Ownership",
                        "DeveloperName": "Ownership",
                        "QualifiedApiName": "Ownership",
                        "Length": 255,
                        "DataType": "Picklist",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Ticker Symbol",
                        "DeveloperName": "TickerSymbol",
                        "QualifiedApiName": "TickerSymbol",
                        "Length": 20,
                        "DataType": "Content(20)",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Description",
                        "DeveloperName": "Description",
                        "QualifiedApiName": "Description",
                        "Length": 32000,
                        "DataType": "Long Text Area(32000)",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Rating",
                        "DeveloperName": "Rating",
                        "QualifiedApiName": "Rating",
                        "Length": 255,
                        "DataType": "Picklist",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Account Site",
                        "DeveloperName": "Site",
                        "QualifiedApiName": "Site",
                        "Length": 80,
                        "DataType": "Text(80)",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Account Owner",
                        "DeveloperName": "Owner",
                        "QualifiedApiName": "OwnerId",
                        "Length": 18,
                        "DataType": "Lookup(User)",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Created Date",
                        "DeveloperName": "CreatedDate",
                        "QualifiedApiName": "CreatedDate",
                        "Length": 0,
                        "DataType": "Date/Time",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Created By",
                        "DeveloperName": "CreatedBy",
                        "QualifiedApiName": "CreatedById",
                        "Length": 18,
                        "DataType": "Lookup(User)",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Last Modified Date",
                        "DeveloperName": "LastModifiedDate",
                        "QualifiedApiName": "LastModifiedDate",
                        "Length": 0,
                        "DataType": "Date/Time",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Last Modified By",
                        "DeveloperName": "LastModifiedBy",
                        "QualifiedApiName": "LastModifiedById",
                        "Length": 18,
                        "DataType": "Lookup(User)",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "System Modstamp",
                        "DeveloperName": "SystemModstamp",
                        "QualifiedApiName": "SystemModstamp",
                        "Length": 0,
                        "DataType": "Date/Time",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Last Activity",
                        "DeveloperName": "LastActivityDate",
                        "QualifiedApiName": "LastActivityDate",
                        "Length": 0,
                        "DataType": "Date",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Last Viewed Date",
                        "DeveloperName": "LastViewedDate",
                        "QualifiedApiName": "LastViewedDate",
                        "Length": 0,
                        "DataType": "Date/Time",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Last Referenced Date",
                        "DeveloperName": "LastReferencedDate",
                        "QualifiedApiName": "LastReferencedDate",
                        "Length": 0,
                        "DataType": "Date/Time",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Object Access Level",
                        "DeveloperName": "UserRecordAccess",
                        "QualifiedApiName": "UserRecordAccessId",
                        "Length": 18,
                        "DataType": "Lookup(User Record Access)",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Person Account",
                        "DeveloperName": "PersonContact",
                        "QualifiedApiName": "PersonContactId",
                        "Length": 18,
                        "DataType": "Lookup(Contact)",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Is Person Account",
                        "DeveloperName": "IsPersonAccount",
                        "QualifiedApiName": "IsPersonAccount",
                        "Length": 0,
                        "DataType": "Checkbox",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Mailing Address",
                        "DeveloperName": "PersonMailingAddress",
                        "QualifiedApiName": "PersonMailingAddress",
                        "Length": 0,
                        "DataType": "Address",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Other Address",
                        "DeveloperName": "PersonOtherAddress",
                        "QualifiedApiName": "PersonOtherAddress",
                        "Length": 0,
                        "DataType": "Address",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Mobile",
                        "DeveloperName": "PersonMobilePhone",
                        "QualifiedApiName": "PersonMobilePhone",
                        "Length": 40,
                        "DataType": "Phone",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Home Phone",
                        "DeveloperName": "PersonHomePhone",
                        "QualifiedApiName": "PersonHomePhone",
                        "Length": 40,
                        "DataType": "Phone",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Other Phone",
                        "DeveloperName": "PersonOtherPhone",
                        "QualifiedApiName": "PersonOtherPhone",
                        "Length": 40,
                        "DataType": "Phone",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Asst. Phone",
                        "DeveloperName": "PersonAssistantPhone",
                        "QualifiedApiName": "PersonAssistantPhone",
                        "Length": 40,
                        "DataType": "Phone",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Email",
                        "DeveloperName": "PersonEmail",
                        "QualifiedApiName": "PersonEmail",
                        "Length": 80,
                        "DataType": "Email",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Title",
                        "DeveloperName": "PersonTitle",
                        "QualifiedApiName": "PersonTitle",
                        "Length": 80,
                        "DataType": "Text(80)",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Department",
                        "DeveloperName": "PersonDepartment",
                        "QualifiedApiName": "PersonDepartment",
                        "Length": 80,
                        "DataType": "Text(80)",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Assistant",
                        "DeveloperName": "PersonAssistantName",
                        "QualifiedApiName": "PersonAssistantName",
                        "Length": 40,
                        "DataType": "Text(40)",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Lead Source",
                        "DeveloperName": "PersonLeadSource",
                        "QualifiedApiName": "PersonLeadSource",
                        "Length": 255,
                        "DataType": "Picklist",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Birthdate",
                        "DeveloperName": "PersonBirthdate",
                        "QualifiedApiName": "PersonBirthdate",
                        "Length": 0,
                        "DataType": "Date",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Last Stay-in-Touch Request Date",
                        "DeveloperName": "PersonLastCURequestDate",
                        "QualifiedApiName": "PersonLastCURequestDate",
                        "Length": 0,
                        "DataType": "Date/Time",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Last Stay-in-Touch Save Date",
                        "DeveloperName": "PersonLastCUUpdateDate",
                        "QualifiedApiName": "PersonLastCUUpdateDate",
                        "Length": 0,
                        "DataType": "Date/Time",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Email Bounced Reason",
                        "DeveloperName": "PersonEmailBouncedReason",
                        "QualifiedApiName": "PersonEmailBouncedReason",
                        "Length": 255,
                        "DataType": "Text(255)",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Email Bounced Date",
                        "DeveloperName": "PersonEmailBouncedDate",
                        "QualifiedApiName": "PersonEmailBouncedDate",
                        "Length": 0,
                        "DataType": "Date/Time",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Individual",
                        "DeveloperName": "PersonIndividual",
                        "QualifiedApiName": "PersonIndividualId",
                        "Length": 18,
                        "DataType": "Lookup(Individual)",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Data.com Key",
                        "DeveloperName": "Jigsaw",
                        "QualifiedApiName": "Jigsaw",
                        "Length": 20,
                        "DataType": "Text(20)",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Jigsaw Company Id",
                        "DeveloperName": "JigsawCompany",
                        "QualifiedApiName": "JigsawCompanyId",
                        "Length": 20,
                        "DataType": "External Lookup",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Clean Status",
                        "DeveloperName": "CleanStatus",
                        "QualifiedApiName": "CleanStatus",
                        "Length": 40,
                        "DataType": "Picklist",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Account Source",
                        "DeveloperName": "AccountSource",
                        "QualifiedApiName": "AccountSource",
                        "Length": 255,
                        "DataType": "Picklist",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "D-U-N-S Number",
                        "DeveloperName": "DunsNumber",
                        "QualifiedApiName": "DunsNumber",
                        "Length": 9,
                        "DataType": "Text(9)",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Tradestyle",
                        "DeveloperName": "Tradestyle",
                        "QualifiedApiName": "Tradestyle",
                        "Length": 255,
                        "DataType": "Text(255)",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "NAICS Code",
                        "DeveloperName": "NaicsCode",
                        "QualifiedApiName": "NaicsCode",
                        "Length": 8,
                        "DataType": "Text(8)",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "NAICS Description",
                        "DeveloperName": "NaicsDesc",
                        "QualifiedApiName": "NaicsDesc",
                        "Length": 120,
                        "DataType": "Text(120)",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Year Started",
                        "DeveloperName": "YearStarted",
                        "QualifiedApiName": "YearStarted",
                        "Length": 4,
                        "DataType": "Text(4)",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "SIC Description",
                        "DeveloperName": "SicDesc",
                        "QualifiedApiName": "SicDesc",
                        "Length": 80,
                        "DataType": "Text(80)",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "D&B Company",
                        "DeveloperName": "DandbCompany",
                        "QualifiedApiName": "DandbCompanyId",
                        "Length": 18,
                        "DataType": "Lookup(D&B Company)",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Operating Hours",
                        "DeveloperName": "OperatingHours",
                        "QualifiedApiName": "OperatingHoursId",
                        "Length": 18,
                        "DataType": "Lookup(Operating Hours)",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Customer Priority",
                        "DeveloperName": "CustomerPriority",
                        "QualifiedApiName": "CustomerPriority__c",
                        "Length": 255,
                        "DataType": "Picklist",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "SLA",
                        "DeveloperName": "SLA",
                        "QualifiedApiName": "SLA__c",
                        "Length": 255,
                        "DataType": "Picklist",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Active",
                        "DeveloperName": "Active",
                        "QualifiedApiName": "Active__c",
                        "Length": 255,
                        "DataType": "Picklist",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Number of Locations",
                        "DeveloperName": "NumberofLocations",
                        "QualifiedApiName": "NumberofLocations__c",
                        "Length": 0,
                        "DataType": "Number(3, 0)",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Upsell Opportunity",
                        "DeveloperName": "UpsellOpportunity",
                        "QualifiedApiName": "UpsellOpportunity__c",
                        "Length": 255,
                        "DataType": "Picklist",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "SLA Serial Number",
                        "DeveloperName": "SLASerialNumber",
                        "QualifiedApiName": "SLASerialNumber__c",
                        "Length": 10,
                        "DataType": "Text(10)",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "SLA Expiration Date",
                        "DeveloperName": "SLAExpirationDate",
                        "QualifiedApiName": "SLAExpirationDate__c",
                        "Length": 0,
                        "DataType": "Date",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Active for Current Year",
                        "DeveloperName": "Active_for_Current_Year",
                        "QualifiedApiName": "Active_for_Current_Year__c",
                        "Length": 0,
                        "DataType": "Checkbox",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Level",
                        "DeveloperName": "Level",
                        "QualifiedApiName": "Level__pc",
                        "Length": 255,
                        "DataType": "Picklist",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Languages",
                        "DeveloperName": "Languages",
                        "QualifiedApiName": "Languages__pc",
                        "Length": 100,
                        "DataType": "Text(100)",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Test Templete",
                        "DeveloperName": "Test_Templete",
                        "QualifiedApiName": "Test_Templete__pc",
                        "Length": 255,
                        "DataType": "Text(255)",
                        "Description": null
                    },
                    {
                        "attributes": {
                            "type": "FieldDefinition"
                        },
                        "Id": "000000000000000AAA",
                        "MasterLabel": "Social Security Number",
                        "DeveloperName": "Social_Security_Number",
                        "QualifiedApiName": "Social_Security_Number__pc",
                        "Length": 175,
                        "DataType": "Text (Encrypted)(175)",
                        "Description": null
                    }
                ]
            }
        }
    ]
}
 

 

 

I hope this blog helped you!