A Workflow's ServiceNow dialog includes the Configure Fields option shown below. json, VS Code provides features to make it simpler to write or modify the file's content. A field type that allows a user to choose from records on a different table Table Module, Tables & Columns Module, Schema Map, System Dictionary Four ways that Administrators can view or modify the database structure in ServiceNow. Connect to a JSON file. I looked at lots of alternatives. Options General Tab. Learn vocabulary, terms, and more with flashcards, games, and other study tools. Efficiency. Here's a quick example:. A: You can specify additional change properties of the change request in the Additional change request parameters field. Always prefer to use XML, whenever document markup and meta-data is essential part of data and cannot be taken away. JSON was not designed to have such features, even though some of them are now trying to find their places in the JSON world, e. net Core, it actually has some great utility for the sole reason that C# is a typed language. URL to fetch is the HTTP/HTTPS URL of the web content to get. Even a plain text type would work for that purpose as well, but that too is unavailable to us. It takes an existing field which contains JSON and expands it into an actual data structure within the Logstash event. H ere are some examples of how you could use a simple Javascript ‘split’ method to parse out the date and/or time value from a date/time field. The column results from the use of SQL/JSON function json_query. Duration ):. The logic below should help in situations where the data is pretty reliable, as in the case below. To create an empty object, pass objectValue. In addition, we will introduce you to some of the most common PostgreSQL JSON operators and functions for handling JSON data. JSONLint is a validator and reformatter for JSON, a lightweight data-interchange format. You can solve this by. Here is an overview of the MyWork application architecture. This link is provided only for showing you a way to Serilize or Deserlize Data using JSON. Happily, there is a neat web app called json2csharp that allows you to enter a JSON string (or a URL to a JSON string), and it will generate the corresponding C# class for you! Copy the JSON response you got from the OpenWeatherMap API and paste it in the json2csharp text field, then click the Generate button. Service instances can be added and removed via REST API. But after the output from flows is sent back to powerapps, in powerapps I am recieving boolean values(Tru. Some configuration can be passed through options. You can directly input a URL into the editor and JSONLint will scrape it for JSON and parse it. There is an updated version for Zenoss 5 now too. 0 of the Splunk Add-on for ServiceNow includes the following new features: Support for ServiceNow Jakarta; The identify field is now configurable. In the above we can see that the audio player is active. You define the telemetry, state, properties, and commands for your type. Posted 5 hours ago. We can use JSON Schema to specify that documents can be any of these. Valid JSON Data Types String Number Object Array Boolean Null 1. Tools for using Python’s json module with BSON documents. The CSV unloader is dumping fields based on a UI View for the table in question. It is open source and has a dedicated support forum. For discussion on the Legacy MongoDB Extended JSON v1, see MongoDB Extended JSON (v1). NET Core and you discover your JSON POSTs aren't working. Whether the JSON value given for the object field should be parsed and indexed (true, default) or completely ignored (false). JSON is not a good choice for storing larger datasets because, by storing disparate data in a single column, JSON does not leverage Amazon Redshift’s column store architecture. I highly recommend people use the “Attachment API” feature introduced in that release. In ABAP the standard classes CL_TREX_JSON_SERIALIZER and CL_TREX_JSON_DESERIALIZER can be used for conversion between abap data types and JSON. field is primarily used with AuditIfNotExists and DeployIfNotExists to reference fields on the resource that are being evaluated. However, a UserType is not very developer friendly so, in this post, I’m going to show how you can do a better job using. ) and a space and then type Your incident has been prioritized and added to our queue for investigation. We start with four properties called keywords which are expressed as JSON keys. Gson provides this with the TypeToken class. It uses the name attribute to match up with Formik state. Integrate ServiceNow and SharePoint Using Microsoft Flow to Create an IT Support Ticket. Entity Framework enables you to map you C#. If the hash_type parameter is not specified, the API defaults to a SHA256 hash lookup. In the Affected CIfield, type "ServiceNow" or select it from the autofill list that appears. JSON Parser Online converts JSON Strings to a friendly readable format. When using a table as your widget option schema, you can define custom fields using any ServiceNow field type, add filters to fields, and search or query instance options. A workaround is to create a Calculated column with formula: =TEXT(yournumber, "0") Then the commas in the number field will gone into the Calculated column: Thanks. Simple JSON Datasource - a generic backend datasource. By default, it will place the parsed JSON in the root (top level) of the Logstash event, but this filter can be configured to place the JSON into any arbitrary event field, using the target. try using “curl -XGET” for the query). A duration in seconds with up to nine fractional digits, terminated by 's'. 0 Framework. The various JSON based functions available in MYSQL to create, read, update, and delete rows. The ServiceNow homepage displays. The output will include each field type and any defined configuration for the type. Creating an issue using the Jira REST API is as simple as making a POST with a JSON document. datetime and byte array) and offers type-strict handling for several numeric types instead of a universal "number" type. org for a visual description of the encoding format. What is JSON? JSON (JavaScript Object Notation) is a lightweight data-interchange format. Values for drupal field_fecha_nacimiento are of unix timestamp type. However, a UserType is not very developer friendly so, in this post, I’m going to show how you can do a better job using. In the example above, this is the person object that "owns" the fullName function. dll) Version: 12. Learn how to use App Connect Designer to create an event-driven flow that parses the response from an HTTP endpoint so that some of the data can be inserted into an email to recipients. org it is meant for “How-to (task) topics, step-by-step, procedural troubleshooting, specifications, etc. Read JSON data in apps like Tableau, Power BI, Informatica, SSRS, Excel. sample_field_name_in_java or SampleFieldNameInJava). However if you only need specific fields you may want to use a generic JSON parser like my SimpleJSON. MySQL version 5. IBM’s Informix has the best support for JSON & BSON data types. Comparison of JSON values takes place at two levels. Posted 5 hours ago. The project will store data on multiple event types so I have decided to just describe one event type for this question. In the Related Records area you can link the incident to a KB Article, Problem, Change, or Parent Incident. Jackson can read JSON into an object graph (tree) of JsonNode objects. NET object into a JSON string. Since you have not explicitly specified a view, the "Default view" is used, just like if you were to load a list within the application without a sysparm_view URL parameter specifi. As a Tower administrator with superuser access, you can define a custom credential type in a standard format using a YAML/JSON-like definition, allowing the assignment of new credential types to jobs and inventory updates. One nice thing about using REST in ServiceNow is that they provide a number of APIs (Table API, Aggregate, Import Set, Performance Analytics) based upon what type of integration is needed. In this article, I will show how to change the label color of Incident State the form using a client script and field styles on the incident list. JSON is a data format that is common in configuration files like package. JSON (JavaScript Object Notation) is a lightweight, text-based, language-independent data exchange format that is easy for humans and machines to read and write. JSON (JavaScript Object Notation), specified by RFC 7159 (which obsoletes RFC 4627) and by ECMA-404, is a lightweight data interchange format inspired by JavaScript object literal syntax (although it is not a strict subset of JavaScript 1). Active Record and PostgreSQLThis guide covers PostgreSQL specific usage of Active Record. Since the JSON function returns a date as per ANSI standard the time portion is lost. You couldn’t directly return an array from. Consider a situation when you need to create a resource and the operation takes a long time to complete. OPENJSON can handle both flat key/value pairs and nested, hierarchically organized objects. The CSV unloader is dumping fields based on a UI View for the table in question. Alternatively, you could index a text field with the standard analyzer, the english analyzer, and the french analyzer. The configuration is used in the REST Connection Manager. 1 “Custom Table” means any non-ServiceNow provided table created or installed by or on behalf of Customer on the ServiceNow platform unless such table is specifically exempt. Learn vocabulary, terms, and more with flashcards, games, and other study tools. When an entity type does not have a bundle. Reading JSON. Search-as-you-type A text-like field optimized for queries to implement as-you-type completion Alias Defines an alias to an existing field. 2 “Custom Table Fields” means any non-ServiceNow provided field created by on behalf of Customer within a Custom Table. It is a wild world! In JavaScript, the approach is to just turn JSON into JavaScript objects and hope nothing goes wrong. JSON Encoding of Field Masks. The datetime value in this field is automatically populated from the database field you select below and represents the latest value from the previous run. Sometimes, one talks of certain fields of an object being immutable. Setup Press icon to get more information about the connection parameters. However, that is where the similarities end, as the field type allows for storing multiple Sys IDs as well as email addresses. I highly recommend people use the “Attachment API” feature introduced in that release. How to add a field which content is dependant upon on another field selection in Servicenow. Querying JSON (JSONB) data types in PostgreSQL One of the unusual features of the PostgreSQL database is the ability to store and process JSON documents. I was excited to look at the RESTful web services that Drupal 8 gives out-of-the-box; what follows is my documentation of the various types of requests supported, required headers, responses, and response codes. Snowflake makes semi-structured data available inside the data warehouse service seamlessly. From the product docs: Dot-walking in ServiceNow provides access to fields on related tables from a form, list, or script. TIP: To find the custom field ID in JIRA, open "Create Issue" page, right click on the page, select 'View page source', search for the additional field and find the custom field ID beside it. The ServiceNow Developer Program provides developers with resources to learn, build and deploy applications on the ServiceNow platform, and offers resources to ensure a successful application building experience. But after the output from flows is sent back to powerapps, in powerapps I am recieving boolean values(Tru. The integration between a Chef Automate server and a ServiceNow instance requires the following: Chef Automate; Chef Automate Incident Creation Application in ServiceNow; The Chef Automate Incident Creation application is a ServiceNow certified scoped application available from the ServiceNow store. The type is asserted from this interface{} type as is needed in the code. Â Both examples split out the date and time, populate them into variables, and then populate the date section into a regular date field on the same record. In the Short description field, type your question or a brief description of the issue. Field Type Definitions and Properties A field type defines the analysis that will occur on a field when documents are indexed or queries are sent to the index. Populate this field with JSON formatted representation of specific ServiceNow incident fields that are mandatory for creating a new incident. alternative solutions. Object; Array; JSON Data Type. at least OTRS 6. I decided to draw up a PHP implementation of performing Inserts, Updates, Queries, and Deletions of ServiceNow records via the JSON web service interface. Custom JSON Live Example. ServiceNow ITSM aligns with ITIL standards to manage access and availability of services, fulfill service requests, and streamline service continuity. Set this value to true to remove the Link header from the response. There are two types: ‘When failed’ and ‘When back online’ Insert your Datadog API key into the Trigger endpoint URLs; OPTIONAL: If you want, you can customize the JSON data sent in the notification via the ‘Payload’ section. We do have facilities for turning a record into json. It is a useful start, even though it is nothing like as comprehensive as the existing XML support. This module provides two helper methods dumps and loads that wrap the native json methods and provide explicit BSON conversion to and from JSON. 7 (MariaDB as of the 10. Overview Configuration is provided for establishing connections with the ServiceNow service. Another Value can then be set to this one by assignment. Failure to do so will cause the json decode to fail on the default values. When working with the Request trigger or the HTTP actions, you may need to parse out JSON data. Understand the Basic User Interface and Navigation in ServiceNow. ts or a folder with a package. The following table lists these standard types and their availability. The same rules that are used to decode a JSON string can be applied to encoding as well. ServiceNow Looking at Reporting Types and Field Options. The ServiceNow API accepts json/xml you'll have to change your content-type to application/json and create the mappings in a json format. Before you begin, note that DataWeave 2. It’s important to understand that this type coercion is performed in JSON parser, and it has nothing to do with DataFrame’s type casting functionality. Field Types in ServiceNow: In this Video Different Field Type are Explained. The HTTP kind of an update operation which uses a field mask must be set to PATCH instead of PUT in order to satisfy HTTP semantics (PUT must only be used for full updates). They can include conditional parsing and nested parsing, and can be configured via the Fusion UI or the Parsers API. But I needed something that supported the actual underlying Postgresql json type. If the value of OutputPath is null, that means the input and result are discarded, and the effective output from the state is an empty JSON object, {}. You can use the display value when the field is a choice or reference type field, such as &state=closed instead of &state=7. Available as of Camel 2. In the solution, using Newtonsoft. This means that there is no way to change those parts of the object state, even though other parts of the object may be changeable (weakly immutable). Service instances can be added and removed via REST API. , expected to be understood by any client that might use the API). However, that is where the similarities end, as the field type allows for storing multiple Sys IDs as well as email addresses. Every time someone adds documentation to the ticket and saves it, it is copied here. We do have facilities for turning a record into json. While the documentation appears to follow the basic style of the. properties. JSON is supported in MonetDB as a subtype over type VARCHAR, which ensures that only valid JSON strings are added to the database. The column results from the use of a JSON generation function, such as json_object. Basic Types JSON Documents can be either basic values (strings, numbers, integers, the boolean constants or null), or ordered or unordered list of key:value pairs. The ServiceNow component provides access to all of ServiceNow REST API. To use JSON-based changelogs, you must include snakeyaml-1. This allows you to perform "RESTful" operations like read, modify, add or delete data from your service desk. For more complex scenarios, such as nested arrays or JSON in form data, you need to use the contentType keyword to specify the media type for encoding the value of a complex field. Using a table enables you to: Add any ServiceNow field type, including fields with advanced customization, to the option schema. Gson supports some pre-defined field naming policies to convert the standard Java field names (i. stringify() method converts a JavaScript object or value to a JSON string, optionally replacing values if a replacer function is specified or optionally including only the specified properties if a replacer array is specified. I'm new in python. Tips & Tricks. Important Note: Always run GlideRecord statements in a development instance first and make sure they work correctly before using in production! Server Side. We demonstrate on this page with single level arrays. We'll explore various ways of formatting dates using Jackson, which is used by Spring Boot as its default JSON processor. Assume you have a Person object defined as shown. Integrate ServiceNow and SharePoint Using Microsoft Flow to Create an IT Support Ticket. Now we know which player is active we can query the current item with. Such data can also be stored as text, but the JSON data types have the advantage of enforcing that each stored value is valid according to the JSON rules. It takes an existing field which contains JSON and expands it into an actual data structure within the Logstash event. Also fields that equal the the default value can be omitted from the serialized data. I just created some client scripts to accomplish this task so I figured I would share them here. Saving Custom Field Data from a Report into Project Insight Screenshot of the report and custom fields. The JSON object has two properties, "fields" and "results". Instances of this class are not thread-safe. A 5001 event type says the issue is cleared. return_displayValue to the system properties, and every JSON request will return a display value for a reference field. Gson supports some pre-defined field naming policies to convert the standard Java field names (i. Jackson can read JSON into an object graph (tree) of JsonNode objects. A Senior Technical Consultant is a position in our professional services (Customer Outcomes) organization focused on being the technical expert on the ServiceNow ITOM/ITAM application suite which. There is no restriction between these types - this may be surprising if you expect it to just store JSON objects/ dict s. JsonParseException: Unexpected character (‘f’ (code 102)): was expecting double-quote to start field name. > TYPE_DESCR (ref to CL_ABAP_TYPEDESCR) – value type < RV_COMPRESS (bool) – compress initial value The default implementation of the method allows compressing any initial value. Notice that within a complex type, each sub-field has a type and may have attributes, just as top-level fields do. However, if you want to query using a specific hash algorithm, you can specify it using URL parameter hash_type. This is a very useful constructor. 0) and create a recipient of the POST JSON request to web server type. The various JSON based functions available in MYSQL to create, read, update, and delete rows. In case you are new to the concept here is the definition and a link to product documentation. The JSONv2 web service is provided by a platform-level processor similar to the services for SOAP. Does ServiceNow support generating/saving a single JSON file from request form? Any help is highly appreciated. Processing JSON With Jackson Jackson by default maps a key for the JSON field with the setter method name. Import Data into ServiceNow Tables. You can use the JSON Generator to build your request. In the Query Editor, you can enrich your local copy of ServiceNow data with other data sources, pivot ServiceNow columns, and more. 01 Next, we need to apply the query. Field Description; Connection name: Give this ServiceNow connection a unique name that identifies which ServiceNow instance it is connected to. By default the decoded JSON object replaces the string field from which it was read. Assume you have a Person object defined as shown. JSON can be loaded in ORM models as string fields and be directly sent to JavaScript client-side code via Ajax requests. The scheduler REST API is used to define a schedule for system activities and manage the jobs that result from the schedule. Live JSON generator to interactively create, edit and generate JSON objects. Type Max length functions are just used to create a JSON. ServiceNow administrators can leverage these fields in the transform map to further enrich and customize the incident in ServiceNow. Update: For more information, you can download our free ebook, The Ultimate Guide to the WordPress REST API. Start studying ServiceNow System Administrator Certification. JSON (JavaScript Object Notation) is a lightweight, text-based, language-independent data exchange format that is easy for humans and machines to read and write. POST /api/v2/ticket_fields. The client-side script passes parameters to the Script Include. JSON uses UTF-8 encoded text strings, so JSON strings can be stored as CHAR or VARCHAR data types. If JSON values don't exist, OPENJSON returns NULL values. In the Short description field, type your question or a brief description of the issue. JSON or JavaScript Object Notation is a language-independent open data format that uses human-readable text to express data objects consisting of attribute-value pairs. The live music event (described in full using the JSON schema at the bottom of this question) is an object that stores data such as where the event will take place, the time/date of the event and the cost of the event. Since it supports JSON SQL operations, it only works on backends that have an actual JSON type, currently: PostgreSQL. Script namespace. JsonSerializable::jsonSerialize — Specify data which should be serialized to JSON; JSON Functions. Join GitHub today. Result: a list of objects with their properties filled, even if there are things like nested objects (specs in these case) and arrays in there. In this tutorial we will see how to convert a java List to JSON. Please refer to the ServiceNow documentation for more information about how to add a custom field. Either id or name of each responder should be provided. sample http request in servicenow using RESTMessageV2 server side api tested running in ServiceNow Geneva Release as a background script in global scope - servicenow_sample_http_request. What that means is that all public fields and properties with getters are automatically serialized to JSON, and fields and properties that shouldn't be serialized are opted-out by placing JsonIgnoreAttribute on them. This is an example of a Colors JSON file which you might see used to store configuration settings to setup your system to share color information settings. Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers. This field can accommodate a JSON Array as input which is supposed to hold individual entity of JSON Objects which will be the Test Name, Test Description, Expected result and sequence. Json nuget to play with the json object. Deserialize fp (a. So for this I have created a new method named loadIntoListView(String json). For Jira Additional Fields we need to provide which type Field it is Starts -->. The JSON path evaluation that Oracle Database employs always uses only one of the object members that have a given field name; any other members with the same name are ignored. Create a default Value of the given type. Entity Framework enables you to map you C#. 8, “Data Type Storage Requirements” , for more information. To create an issue, you will need to know certain key metadata, like the ID of the project that the issue will be created in, the ID of the issue type, and which fields to fill. In the above we can see that the audio player is active. Here’s how the server might respond to an invalid JSON document:. Learn how to use App Connect Designer to create an event-driven flow that parses the response from an HTTP endpoint so that some of the data can be inserted into an email to recipients. Java Script Object Notation (JSON) is a format used to describe data and is widely used in applications, web services, Electronic Data Interchange (EDI), and much more. I'm trying with time in millis as integer, millis as How should I send a date field to a REST server in JSON format?. Since not all relational database systems support JSON types, Hibernate does not come with a built-in JSON Type mapper. He has worked with various applications and integrations within ServiceNow. Parse JSON object in C# with different value types - JsonExperiements. • A JSON-to-XML mapping is friendly when the generated XML has meaningful element and attribute names, rather than a name value pair design. Consider a situation when you need to create a resource and the operation takes a long time to complete. The trick is to concatenate everything in a single string, using the JSON style, and set the content type by using the method set_header_field. at least OTRS 6. The Script Include returns data as XML or a JSON object. In addition, the JSON data may be stored in a text field, rather than an optimized data type, which has its cost in speed of query execution and data storage. Using these will log warning. If all fields are immutable, then the object is immutable. Letting JSON do it for you may give you some surprising results when mixing text and numbers. OPENJSON converts JSON values to the types that are specified in the WITH clause. Those are our fields that we defined on Droid!. Well organized and easy to understand Web building tutorials with lots of examples of how to use HTML, CSS, JavaScript, SQL, PHP, Python, Bootstrap, Java and XML. This simple DataWeave example changes the XML input to JSON output by using selector expressions without any functions. But there is another big benefit in ASP. If you specify values in this field, the Kettle indexed data type is applied to. JSON is an alias for LONGTEXT introduced for compatibility reasons with MySQL's JSON data type. In addition, the JSON data may be stored in a text field, rather than an optimized data type, which has its cost in speed of query execution and data storage. You can also use the Query Editor to create formulas to connect to JSON files. When accessing to an element of this list, we have a dictionary type, also as we were expecting. They are based on the JSON format and includes a token signature to ensure the integrity of the token. Pricing score pricing Score is a 1 to 10 (10 is high cost), based on the TCO (cost of licences, customizations, training, hardware when relevant) Vs. Another Value can then be set to this one by assignment. POST Examples. The ServiceNow connector supports Username/Password (Basic) authentication and OAuth 2. NET will skip writing a field/property value to JSON if the value is the same as the field/property's default value, or the custom value specified in DefaultValueAttribute if the attribute is present. For Jira Additional Fields we need to provide which type Field it is Starts -->. NET SDK to create a schema that includes complex types. ) and a space and then type Your incident has been prioritized and added to our queue for investigation. Number fields with the Replication ID property enabled. In previous postings we have shown examples of JSON data stored in a VARCHAR2 and CLOB columns. Updates v1. For example, the required field on objects is ENFORCED because a type assignable to T is guaranteed to contain all fields marked required. org Category: Informational July 2006 The application/json Media Type for JavaScript Object Notation (JSON) Status of This Memo This memo provides information for the Internet community. For example C# string can represent either Bond type string or wstring. An example of JSON data: The json module enables you to convert between JSON and Python Objects. Since not all relational database systems support JSON types, Hibernate does not come with a built-in JSON Type mapper. Example: If your ServiceNow instance requires new incidents to be created with impact and priority set at creation time, the Additional incident settings field would include the following:. ServiceNow Interview Questions and Answers ServiceNow Interview Questions. Deserialize JSON With Non-Matching Field Names to Object Now, let's see how Gson does with a json string containing fields that simply don't match the fields of our Foo object:. xcworkspace file was generated within xcode project directory. Start studying ServiceNow System Administrator Certification. In the example above, this is the person object that "owns" the fullName function. Create Tables, Fields, Form Layouts, Views. The data read from JSON documents can be imported into one or more database tables. Data Type: This column indicates the type of value for the current field. Background. Suppose we have an Animal class with a parameterized type. Note As of Fusion 3. 8, "Data Type Storage Requirements" , for more information. org Category: Informational July 2006 The application/json Media Type for JavaScript Object Notation (JSON) Status of This Memo This memo provides information for the Internet community. It is the best and effective way when need to return multiple values as a response from the PHP script to the jQuery. Type Script. Start studying ServiceNow System Administrator Certification. Crest Data Systems is a leading provider of solutions and services for Data Analytics, Splunk, Security, DevOps, Elastic Search, ServiceNow and Cloud Technologies. JSON web tokens are a type of access tokens that are widely used in commercial applications. See the complete profile on LinkedIn and discover Paul’s connections. Cryptographic algorithms and identifiers for use with this specification are described in the separate JSON Web Algorithms (JWA) specification and an IANA registry defined by that specification. You couldn’t directly return an array from. at least OTRS 6. The JSON returned is quite complicated, so I have been trying to read the JSON with a Apex Class structure within salesforce, but this struggles with a varying field type. This scenario describes a two-component Job that extracts data from the JSON file Store. json_util – Tools for using Python’s json module with BSON documents¶. assoc − It is a boolean type parameter, when set to TRUE, returned objects will be converted into associative arrays. If you have an XSLT file, you can add to to the app for the right transformation. In my article on the future of WordPress, I wrote about how the introduction of a JSON RESTful API to WordPress core will radically expand WordPress’s reach and capabilities. Upload JSON File and Start Editing. JSON PARSER ONLINE is a tool which lets you parse json string into a preety and colorful json tree view. This book is aimed at advanced ServiceNow System Administrators and developers who would like to gain greater control of ServiceNow and its architecture. I was wondering how this works if both the fields are of reference type. I have a GeoJSON file with ids: { "type": ". NET Framework classs, stuff like behavior or thrown exceptions are omited:. Working with JSON in Swift If your app communicates with a web application, information returned from the server is often formatted as JSON. A field for storing JSON. Posted 2 months ago. Browse to your JSON file location, select it, and click. Similar to the behavior of a Reference Field, a field of type Glide List (glide_list) stores the Sys ID of a referenced record. 0 to authenticate requests. Custom Development Work with clients to get them started on Shopify and solve their unique development needs. An example of this use can be seen in the DeployIfNotExists example. From the options, select ‘Web’ and click on Connect. contact_type is phone. Please refer to the ServiceNow documentation for more information about how to add a custom field.