Product documentation Docs
    • English
    • Deutsch
    • 日本語
    • 한국어
    • Français
  • More Sites
    • Now Community
    • Developer Site
    • Knowledge Base
    • Product Information
    • ServiceNow.com
    • Training
    • Customer Success Center
    • ServiceNow Support Videos
  • Log in

Product documentation

  • Home
How search works:
  • Punctuation and capital letters are ignored
  • Special characters like underscores (_) are removed
  • Known synonyms are applied
  • The most relevant topics (based on weighting and matching to search terms) are listed first in search results
Topics are ranked in search results by how closely they match your search terms
  • A match on the entire phrase you typed
  • A match on part of the phrase you typed
  • A match on ALL of the terms in the phrase you typed
  • A match on ANY of the terms in the phrase you typed

Note: Matches in titles are always highly ranked.

  • Release version
    Table of Contents
    • Now Platform administration
Table of Contents
Choose your release version
    Home London Platform Administration Now Platform administration Data management Export and import XML files Exporting data Export directly from a URL Call URL export programmatically

    Call URL export programmatically

    • Save as PDF Selected topic Topic & subtopics All topics in contents
    • Unsubscribe Log in to subscribe to topics and get notified when content changes.
    • Share this page

    Call URL export programmatically

    You can dynamically export data from a script or web service by calling a URL export from any programming language.

    About this task

    The following procedure includes code samples that demonstrate calling a URL export in C# for a .Net framework call:

    Procedure

    1. Add the following Imports:
      using System.Net;
      using System.IO;
    2. Call the Download method:
      static void Main(string[] args)
      
           {
              // Call to DownloadFile method supplying the URL and location to save CSV file locally
              int read = DownloadFile("https://<instance>.service-now.com/incident_list.do?CSV&sysparm_query=priority=1&sysparm_orderby=assigned_to",
                           "c:\\test\\incident.csv");
          }
    3. Create a Download method as follows:
      public static int DownloadFile(String url,
                                             String localFilename)
          {
              // Function will return the number of bytes processed
              // to the caller. Initialize to 0 here.
              int bytesProcessed = 0;
              // Assign values to these objects here so that they can
              // be referenced in the finally block
              Stream remoteStream = null;
              Stream localStream = null;
              WebResponse response = null;
              // Use a try/catch/finally block as both the WebRequest and Stream
              // classes throw exceptions upon error
              try
              {
                  // Create a request for the specified remote file name
                  WebRequest request = WebRequest.Create(url);
                  // Create the credentials required for Basic Authentication
                  System.Net.ICredentials cred = new System.Net.NetworkCredential("user_name", "password");
                  // Add the credentials to the request
                  request.Credentials = cred;
                  if (request != null)
                  {
                      // Send the request to the server and retrieve the
                      // WebResponse object 
                      response = request.GetResponse();
                      if (response != null)
                      {
                          // Once the WebResponse object has been retrieved,
                          // get the stream object associated with the response's data
                          remoteStream = response.GetResponseStream();
                          // Create the local file
                          localStream = File.Create(localFilename);
                          // Allocate a 1k buffer
                          byte[] buffer = new byte[1024];
                          int bytesRead;
                          // Simple do/while loop to read from stream until
                          // no bytes are returned
                          do
                          {
                              // Read data (up to 1k) from the stream
                              bytesRead = remoteStream.Read(buffer, 0, buffer.Length);
                              // Write the data to the local file
                              localStream.Write(buffer, 0, bytesRead);
                              // Increment total bytes processed
                              bytesProcessed += bytesRead;
                          } while (bytesRead > 0);
                      }
                  }
              }
              catch (Exception e)
              {
                  Console.WriteLine(e.Message);
              }
              finally
              {
                  // Close the response and streams objects here 
                  // to make sure they're closed even if an exception
                  // is thrown at some point
                  if (response != null) response.Close();
                  if (remoteStream != null) remoteStream.Close();
                  if (localStream != null) localStream.Close();
              }
              // Return total bytes processed to caller.
              return bytesProcessed;
          }

    Tags:

    Feedback
    On this page

    Previous topic

    Next topic

    • Contact Us
    • Careers
    • Terms of Use
    • Privacy Statement
    • Sitemap
    • © ServiceNow. All rights reserved.

    Release version
    Choose your release version

      Call URL export programmatically

      • Save as PDF Selected topic Topic & subtopics All topics in contents
      • Unsubscribe Log in to subscribe to topics and get notified when content changes.
      • Share this page

      Call URL export programmatically

      You can dynamically export data from a script or web service by calling a URL export from any programming language.

      About this task

      The following procedure includes code samples that demonstrate calling a URL export in C# for a .Net framework call:

      Procedure

      1. Add the following Imports:
        using System.Net;
        using System.IO;
      2. Call the Download method:
        static void Main(string[] args)
        
             {
                // Call to DownloadFile method supplying the URL and location to save CSV file locally
                int read = DownloadFile("https://<instance>.service-now.com/incident_list.do?CSV&sysparm_query=priority=1&sysparm_orderby=assigned_to",
                             "c:\\test\\incident.csv");
            }
      3. Create a Download method as follows:
        public static int DownloadFile(String url,
                                               String localFilename)
            {
                // Function will return the number of bytes processed
                // to the caller. Initialize to 0 here.
                int bytesProcessed = 0;
                // Assign values to these objects here so that they can
                // be referenced in the finally block
                Stream remoteStream = null;
                Stream localStream = null;
                WebResponse response = null;
                // Use a try/catch/finally block as both the WebRequest and Stream
                // classes throw exceptions upon error
                try
                {
                    // Create a request for the specified remote file name
                    WebRequest request = WebRequest.Create(url);
                    // Create the credentials required for Basic Authentication
                    System.Net.ICredentials cred = new System.Net.NetworkCredential("user_name", "password");
                    // Add the credentials to the request
                    request.Credentials = cred;
                    if (request != null)
                    {
                        // Send the request to the server and retrieve the
                        // WebResponse object 
                        response = request.GetResponse();
                        if (response != null)
                        {
                            // Once the WebResponse object has been retrieved,
                            // get the stream object associated with the response's data
                            remoteStream = response.GetResponseStream();
                            // Create the local file
                            localStream = File.Create(localFilename);
                            // Allocate a 1k buffer
                            byte[] buffer = new byte[1024];
                            int bytesRead;
                            // Simple do/while loop to read from stream until
                            // no bytes are returned
                            do
                            {
                                // Read data (up to 1k) from the stream
                                bytesRead = remoteStream.Read(buffer, 0, buffer.Length);
                                // Write the data to the local file
                                localStream.Write(buffer, 0, bytesRead);
                                // Increment total bytes processed
                                bytesProcessed += bytesRead;
                            } while (bytesRead > 0);
                        }
                    }
                }
                catch (Exception e)
                {
                    Console.WriteLine(e.Message);
                }
                finally
                {
                    // Close the response and streams objects here 
                    // to make sure they're closed even if an exception
                    // is thrown at some point
                    if (response != null) response.Close();
                    if (remoteStream != null) remoteStream.Close();
                    if (localStream != null) localStream.Close();
                }
                // Return total bytes processed to caller.
                return bytesProcessed;
            }

      Tags:

      Feedback

          Share this page

          Got it! Feel free to add a comment
          To share your product suggestions, visit the Idea Portal.
          Please let us know how to improve this content

          Check any that apply

          To share your product suggestions, visit the Idea Portal.
          Confirm

          We were unable to find "Coaching" in Jakarta. Would you like to search instead?

          No Yes
          • Contact Us
          • Careers
          • Terms of Use
          • Privacy Statement
          • Sitemap
          • © ServiceNow. All rights reserved.

          Subscribe Subscribed Unsubscribe Last updated: Tags: January February March April May June July August September October November December No Results Found Versions Search preferences successfully updated My release version successfully updated My release version successfully deleted An error has occurred. Please try again later. You have been unsubscribed from all topics. You are now subscribed to and will receive notifications if any changes are made to this page. You have been unsubscribed from this content Thank you for your feedback. Form temporarily unavailable. Please try again or contact  docfeedback@servicenow.com  to submit your comments. The topic you requested does not exist in the release. You were redirected to a related topic instead. The available release versions for this topic are listed There is no specific version for this documentation. Explore products Click to go to the page. Release notes and upgrades Click to open the dropdown menu. Delete Remove No selected version Reset This field is required You are already subscribed to this topic Attach screenshot The file you uploaded exceeds the allowed file size of 20MB. Please try again with a smaller file. Please complete the reCAPTCHA step to attach a screenshot
          Log in to personalize your search results and subscribe to topics
          No, thanks Login