{"id":24261,"date":"2024-02-15T14:53:34","date_gmt":"2024-02-15T22:53:34","guid":{"rendered":"https:\/\/docs.extraview.com\/v25\/book\/insert-1\/"},"modified":"2025-02-17T10:04:45","modified_gmt":"2025-02-17T18:04:45","slug":"insert-1","status":"publish","type":"page","link":"https:\/\/docs.extraview.com\/v25\/extraview-25\/application-programming-interface-1\/insert-1\/","title":{"rendered":"insert"},"content":{"rendered":"

This API call inserts a new record into the ExtraView database. All fields are treated as optional, and all defined business rules are executed and checked before and after the record is inserted (the preupdate and postupdate rule directives). The fields used with this command are typically those that are placed on the ADD_PROBLEM layout for the business area and project specified in the command syntax.<\/p>\n

\n\tSYNTAX<\/h3>\n

http:\/\/www.myserver.com\/evj\/ExtraView\/ev_api.action?<\/span>
\n\tuser_id=username
\n\t&password=password<\/span> <\/span>OR <\/span>[&access_token=token-value]
\n\t&statevar=insert
\n\t&p_template_file=file.html
\n\t&username_display=ID | LAST | FIRST
\n\t&send_email=no
\n\t&field_name1=value1 [&field_name2=value2] [&field_name_n=valuen]
\n\t <\/span><\/p>\n

There are two name-value pairs that can be provided, that are not fields within ExtraView. These are \u2013<\/p>\n

    \n
  1. \n\t\t&send_email=no<\/span><\/li>\n<\/ol>\n

    If you supply this name and value, then the insert will override the standard default with which ExtraView will generate email upon the submission of a new issue<\/p>\n

      \n
    1. \n\t\t&username_display=ID | LAST | FIRST<\/span><\/li>\n<\/ol>\n

      The optional parameter <\/span>USERNAME_DISPLAY<\/span> <\/span>may be used to override the behavior setting named USERNAME_DISPLAY, for the duration of the execution of a single API call. This allows the developer to return the user names in a different format than the system-wide default.<\/p>\n

      If the issue is added to the database without error, the function will return the issue number as shown below. Note that the term \u201cBug #\u201d is dependent on the screen title used for the ID field in the data dictionary.<\/p>\n

      Bug # 12352 added.<\/span><\/p>\n

      \n\tNOTES<\/h3>\n

      You must not provide a name and value for the <\/span>ID<\/span> <\/span>field. ExtraView allocates all new issue numbers internally and any attempt to provide an ID will result in an error message, similar to <\/span>“You cannot provide a Bug # when you are adding a new issue.”<\/span><\/p>\n

      Many of the fields within the ExtraView database, such as product_name, status, priority, severity_level, assigned_to, category, etc., must be given valid values that already exist within the meta-data of your installation. If you attempt to enter a value that is not known to ExtraView, an error message will result.<\/p>\n

      If you attempt to contravene a business rule, an error message will result. For example, if your installation only allows new issues to be SUBMITTED and you immediately attempt to provide a value of CLOSED when inserting a record, an error message will result.<\/p>\n

      Also, note that special non-alphabetic characters, such as a space, must be \u201cescaped\u201d.<\/p>\n

      You may optionally specify the values for the AREA and PROJECT into which the issue is to be inserted, using their numeric ID. These ID\u2019s can be seen within the administration utilities in the web interface. You may not use their titles. If you do not specify the AREA and PROJECT within the parameter list, then the current AREA and PROJECT of the current user are used. For example, use:<\/p>\n

      … … &p_area=3&p_project=58 … ….<\/span><\/p>\n

      All field permissions are obeyed with the command, and if you attempt to insert a field that does not have write permission, then the whole command will fail.<\/p>\n

      The optional access_token<\/code> parameter allows you to use a valid OAuth2 token obtained with the get_token<\/code> command.  If you provide the access_token<\/code> parameter, then the user_id<\/code> and password<\/code> parameters should not be provided.  This prevents the password being sent in clear text over your network connection.<\/p>\n

      \n\tInserting Document & Image type fields<\/h4>\n

      These fields require additional metadata in the form of a description and the file to upload’s character set. You will have created an HTML form for the upload. An HTML snippet that shows how to make this work is as follows:<\/p>\n

      \n\tImage Description: <input type=\"text\" name=\"image_desc\"
      \n\tvalue=\"image_dd_name desc\" \/>
      \n\t<br \/>
      \n\t<input type=\"hidden\" name=\"image_dd_name_charset\" value=\"UTF-8\" \/>
      \n\tFile to upload: <input type=\"file\" name=\"image_dd_name\" \/><\/code><\/div>\n

      This form assumes an image field that has a data dictionary name of <\/span>image_dd_name<\/span>. Note the optional <\/span>charset<\/span> <\/span>and <\/span>desc<\/span>. The <\/span>charset<\/span> <\/span>is not required for image fields, but for documents it can be useful. The default, if <\/span>charset<\/span> <\/span>is not given is UTF-8.<\/p>\n","protected":false},"excerpt":{"rendered":"

      This API call inserts a new record into the ExtraView database. All fields are treated as optional, and all defined business rules are executed and checked before and after the record is inserted (the preupdate and postupdate rule directives). The fields used with this command are typically those that are placed on the ADD_PROBLEM layout…<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":24223,"menu_order":58,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_lmt_disableupdate":"no","_lmt_disable":"","_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"class_list":["post-24261","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"\ninsert - Product Documentation<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/docs.extraview.com\/v25\/extraview-25\/application-programming-interface-1\/insert-1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"insert - Product Documentation\" \/>\n<meta property=\"og:description\" content=\"This API call inserts a new record into the ExtraView database. All fields are treated as optional, and all defined business rules are executed and checked before and after the record is inserted (the preupdate and postupdate rule directives). The fields used with this command are typically those that are placed on the ADD_PROBLEM layout...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.extraview.com\/v25\/extraview-25\/application-programming-interface-1\/insert-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Product Documentation\" \/>\n<meta property=\"article:modified_time\" content=\"2025-02-17T18:04:45+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/application-programming-interface-1\/insert-1\/\",\"url\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/application-programming-interface-1\/insert-1\/\",\"name\":\"insert - Product Documentation\",\"isPartOf\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#website\"},\"datePublished\":\"2024-02-15T22:53:34+00:00\",\"dateModified\":\"2025-02-17T18:04:45+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/application-programming-interface-1\/insert-1\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.extraview.com\/v25\/extraview-25\/application-programming-interface-1\/insert-1\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/application-programming-interface-1\/insert-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/docs.extraview.com\/v25\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ExtraView 25\",\"item\":\"https:\/\/docs.extraview.com\/v25\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Application Programming Interface\",\"item\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/application-programming-interface-1\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"insert\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/#website\",\"url\":\"https:\/\/docs.extraview.com\/v25\/\",\"name\":\"ExtraView Product Documentation\",\"description\":\"ExtraView Documentation\",\"publisher\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/docs.extraview.com\/v25\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/#organization\",\"name\":\"ExtraView Corporation\",\"url\":\"https:\/\/docs.extraview.com\/v25\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png\",\"contentUrl\":\"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png\",\"width\":512,\"height\":512,\"caption\":\"ExtraView Corporation\"},\"image\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"insert - Product Documentation","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/docs.extraview.com\/v25\/extraview-25\/application-programming-interface-1\/insert-1\/","og_locale":"en_US","og_type":"article","og_title":"insert - Product Documentation","og_description":"This API call inserts a new record into the ExtraView database. All fields are treated as optional, and all defined business rules are executed and checked before and after the record is inserted (the preupdate and postupdate rule directives). The fields used with this command are typically those that are placed on the ADD_PROBLEM layout...","og_url":"https:\/\/docs.extraview.com\/v25\/extraview-25\/application-programming-interface-1\/insert-1\/","og_site_name":"Product Documentation","article_modified_time":"2025-02-17T18:04:45+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/application-programming-interface-1\/insert-1\/","url":"https:\/\/docs.extraview.com\/v25\/extraview-25\/application-programming-interface-1\/insert-1\/","name":"insert - Product Documentation","isPartOf":{"@id":"https:\/\/docs.extraview.com\/v25\/#website"},"datePublished":"2024-02-15T22:53:34+00:00","dateModified":"2025-02-17T18:04:45+00:00","breadcrumb":{"@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/application-programming-interface-1\/insert-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.extraview.com\/v25\/extraview-25\/application-programming-interface-1\/insert-1\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/application-programming-interface-1\/insert-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/docs.extraview.com\/v25\/"},{"@type":"ListItem","position":2,"name":"ExtraView 25","item":"https:\/\/docs.extraview.com\/v25\/"},{"@type":"ListItem","position":3,"name":"Application Programming Interface","item":"https:\/\/docs.extraview.com\/v25\/extraview-25\/application-programming-interface-1\/"},{"@type":"ListItem","position":4,"name":"insert"}]},{"@type":"WebSite","@id":"https:\/\/docs.extraview.com\/v25\/#website","url":"https:\/\/docs.extraview.com\/v25\/","name":"ExtraView Product Documentation","description":"ExtraView Documentation","publisher":{"@id":"https:\/\/docs.extraview.com\/v25\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/docs.extraview.com\/v25\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/docs.extraview.com\/v25\/#organization","name":"ExtraView Corporation","url":"https:\/\/docs.extraview.com\/v25\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/","url":"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png","contentUrl":"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png","width":512,"height":512,"caption":"ExtraView Corporation"},"image":{"@id":"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/"}}]}},"taxonomy_info":[],"featured_image_src_large":false,"author_info":{"display_name":"carl.koppel","author_link":"https:\/\/docs.extraview.com\/v25\/author\/carl-koppel\/"},"comment_info":0,"_links":{"self":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/24261","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/comments?post=24261"}],"version-history":[{"count":0,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/24261\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/24223"}],"wp:attachment":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/media?parent=24261"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}