{"id":4755,"date":"2018-09-06T15:59:12","date_gmt":"2018-09-06T15:59:12","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=4755"},"modified":"2020-05-29T21:48:49","modified_gmt":"2020-05-29T21:48:49","slug":"read-data-netsuite-ssis-simpletalk-soap-api","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/read-data-netsuite-ssis-simpletalk-soap-api\/","title":{"rendered":"How to read data from NetSuite in SSIS (SimpleTalk SOAP API)"},"content":{"rendered":"

Introduction<\/h2>\n

\"\"<\/a>In this post we will learn how to read data from NetSuite in SSIS. We will use ZappySys XML Source<\/a> for SOAP API access.<\/p>\n

 <\/p>\n

 <\/p>\n

Prerequisites<\/span><\/h2>\r\nBefore we perform the steps listed in this article, you will need to make sure the following prerequisites are met:\r\n
    \r\n \t
  1. SSIS<\/abbr> designer installed.\u00a0Sometimes it is referred to as BIDS<\/abbr> or SSDT<\/abbr> (download it from the Microsoft site<\/a>).<\/li>\r\n \t
  2. Basic knowledge of SSIS package\u00a0development using\u00a0Microsoft SQL Server Integration Services<\/em>.<\/li>\r\n \t
  3. Make sure\u00a0ZappySys SSIS PowerPack<\/a><\/span>\u00a0is installed (download it<\/a>, if you haven't already).<\/li>\r\n \t
  4. (Optional step<\/em>).<\/em>\u00a0Read this article<\/a>, if you are planning to deploy packages to a server and schedule their execution later.<\/li>\r\n<\/ol><\/div>\n

    What is NetSuite CRM?<\/span><\/h2>\n

    NetSuite is a CRM \/ ERP product. It gives you scalable cloud CRM \/ ERP solution targeted at high-growing, mid-sized businesses and large enterprises. It automates front- and back-office processes including: financial management, revenue management, fixed assets, order management, billing, and inventory management.<\/p>\n

    Preparing for NetSuite WebService Call in SSIS<\/span><\/h2>\n

    For NetSuite API call we have to make sure certain settings and obtain Application ID and AccountID. So let’s get started.<\/p>\n

    How to enable NetSuite Web Service Feature<\/h3>\r\nBefore you call any NetSuite SOAP API (i.e.\u00a0SuiteTask Web Service<\/strong>), First thing to get started with NetSuite SOAP API (i.e. ) is to enable Web Service Feature. Once you enable Web Service, you can programmatically access NetSuite data in your App (e.g. Power BI, Tableau, Informatica).\r\n\r\nClick this link<\/a>\u00a0to see steps to enable Web Service Feature\r\n
    \r\n\r\n\"Enable<\/a>\r\n

    Enable NetSuite Web Service Feature (SuiteTalk API)<\/p>\r\n\r\n<\/div>\r\n

    Obtain NetSuite Account ID<\/span><\/h3>\r\nNetSuite Account ID is needed by Login API call. So perform following steps if you dont know account id.\r\n
      \r\n \t
    1. Login to your NetSuite Portal<\/li>\r\n \t
    2. Click the\u00a0Setup Tab<\/strong><\/li>\r\n \t
    3. In the drop-down click\u00a0Integration<\/strong>\u00a0>\u00a0\u00a0Web services preferences<\/strong><\/li>\r\n \t
    4. On that page you will find your Account ID (example account ID = TSTDRV1234567<\/strong>\u00a0)<\/li>\r\n<\/ol>\r\n
      \r\n\r\n\"Obtain<\/a>\r\n

      Obtain NetSuite Account ID (Needed for Web Service Login)<\/p>\r\n\r\n<\/div>\r\n

      Obtain NetSuite Application ID<\/span><\/h3>\r\nOnce you have account ID now we need to get Application ID. For that follow these steps.\r\n
        \r\n \t
      1. Login to your NetSuite Portal<\/li>\r\n \t
      2. Click the\u00a0Setup Tab<\/strong><\/li>\r\n \t
      3. In the drop-down click\u00a0Integration<\/strong>\u00a0>\u00a0\u00a0Manage Integrations<\/strong><\/li>\r\n \t
      4. On that page you will find your existing Applications along with Account ID \/ Status (example Application ID = AE2EACFD-1234-1222-1111-12345544555<\/strong>\u00a0)<\/li>\r\n \t
      5. If you don\u2019t have any application created yet then just click on New.<\/li>\r\n<\/ol>\r\n
        \r\n\r\n\"Create<\/a>\r\n

        Create new App \/ Get NetSuite Application ID<\/p>\r\n\r\n<\/div>\r\n

        <\/h3><\/div>\n

        Understanding how NetSuite SOAP API Call works<\/h2>\r\nIn this section we will briefly understand how NetSuite SOAP API call works. When you use ZappySys Driver \/ Component it will take care many details for you but still you have to configure correct XML Body.\r\n\r\nThere are two steps involved before you can call any SOAP API in NetSuite.\r\n
          \r\n \t
        1. Call Login method<\/a> and extract\u00a0JSESSIONID from response Cookie (This token expires after some time)<\/li>\r\n \t
        2. Call any other API (Pass obtained JSESSIONID token in Cookie header)<\/li>\r\n<\/ol>\r\n

          NetSuite Login Call<\/h3>\r\nRequest<\/strong>\r\n
          POST https:\/\/webservices.netsuite.com\/services\/NetSuitePort_2017_1\r\nContent-Type: text\/xml;charset=UTF-8\r\nSOAPAction: \"login\"\r\nAccept-Encoding: gzip, deflate\r\n\r\n<?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n<soap:Envelope xmlns:soap=\"http:\/\/schemas.xmlsoap.org\/soap\/envelope\/\" xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\" xmlns:xsd=\"http:\/\/www.w3.org\/2001\/XMLSchema\">\r\n  <soap:Header>\r\n    <applicationInfo xmlns=\"urn:messages_2017_1.platform.webservices.netsuite.com\">\r\n      <applicationId>xxxxxxxxxxxxxx<\/applicationId>\r\n    <\/applicationInfo>\r\n  <\/soap:Header>\r\n  <soap:Body>\r\n    <login xmlns=\"urn:messages_2017_1.platform.webservices.netsuite.com\">\r\n      <passport>\r\n        <email xmlns=\"urn:core_2017_1.platform.webservices.netsuite.com\">xxxxxxxxxxxxx<\/email>\r\n        <password xmlns=\"urn:core_2017_1.platform.webservices.netsuite.com\">xxxxxxxxxxxx<\/password>\r\n        <account xmlns=\"urn:core_2017_1.platform.webservices.netsuite.com\">TSTxxxxxxxxxxxxxxx<\/account>\r\n        <role internalId=\"3\" xmlns=\"urn:core_2017_1.platform.webservices.netsuite.com\" \/>\r\n      <\/passport>\r\n    <\/login>\r\n  <\/soap:Body>\r\n<\/soap:Envelope><\/pre>\r\nResponse<\/strong>\r\n\r\nNotice\u00a0JSESSIONID=6xI6xxxxxxxxx in the login call response below. This Session ID can be used to call next call. ZappySys HTTP Connection Manager configured with Dynamic Token<\/a> option can extract Cookie and reuse it until its expired (1 hour by default).\r\n
          HTTP\/1.1 200 OK\r\nDate: Wed, 03 Oct 2018 16:50:41 GMT\r\nContent-Length: 1676\r\nContent-Type: text\/xml; charset=utf-8\r\nX-N-OperationId: 777274f6-49c6-4883-bcd1-1d70df90d78e\r\nStrict-Transport-Security: max-age=31536000\r\nNS_RTIMER_COMPOSITE: 13633xxxxxxxxx:70617xxxxxxxxxxxxx36F6D:80\r\nSet-Cookie: JSESSIONID=6xI61rdFt26pxxxxxxxxxxxxxxxqvJIMlu!-17981123445; path=\/; secure; HttpOnly\r\nSet-Cookie: NS_VER=2018.1.0; domain=webservices.netsuite.com; path=\/\r\nSet-Cookie: NS_ROUTING_VERSION=LAGGING; path=\/\r\nP3P: CP=\"CAO PSAa OUR BUS PUR\"\r\nVary: User-Agent\r\nKeep-Alive: timeout=10, max=990\r\nConnection: Keep-Alive\r\n\r\n<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n<soapenv:Envelope xmlns:soapenv=\"http:\/\/schemas.xmlsoap.org\/soap\/envelope\/\" xmlns:xsd=\"http:\/\/www.w3.org\/2001\/XMLSchema\" xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\">\r\n  <soapenv:Header>\r\n    <platformMsgs:documentInfo xmlns:platformMsgs=\"urn:messages_2017_1.platform.webservices.netsuite.com\">\r\n      <platformMsgs:nsId>WEBSERVICES_xxxxxxxxxxxxxxxxx_9fc719<\/platformMsgs:nsId>\r\n    <\/platformMsgs:documentInfo>\r\n  <\/soapenv:Header>\r\n  <soapenv:Body>\r\n    <loginResponse xmlns=\"urn:messages_2017_1.platform.webservices.netsuite.com\">\r\n      <sessionResponse xmlns=\"urn:messages_2017_1.platform.webservices.netsuite.com\">\r\n        <ns1:status isSuccess=\"true\" xmlns:ns1=\"urn:core_2017_1.platform.webservices.netsuite.com\"\/>\r\n        <ns2:wsRoleList xmlns:ns2=\"urn:core_2017_1.platform.webservices.netsuite.com\">\r\n          <ns2:wsRole>\r\n            <ns2:role internalId=\"3\">\r\n              <ns2:name>Administrator<\/ns2:name>\r\n            <\/ns2:role>\r\n            <ns2:isDefault>false<\/ns2:isDefault>\r\n            <ns2:isInactive>false<\/ns2:isInactive>\r\n          <\/ns2:wsRole>\r\n          <ns2:wsRole>\r\n            <ns2:role internalId=\"15\">\r\n              <ns2:name>Employee Center<\/ns2:name>\r\n            <\/ns2:role>\r\n            <ns2:isDefault>false<\/ns2:isDefault>\r\n            <ns2:isInactive>false<\/ns2:isInactive>\r\n          <\/ns2:wsRole>\r\n      <\/sessionResponse>\r\n    <\/loginResponse>\r\n  <\/soapenv:Body>\r\n<\/soapenv:Envelope><\/pre>\r\n \r\n
          NetSuite API Call ( getAll method )<\/h3>\r\nNow once you have JSESSIONID extracted you can pass it to call next API call as below. For example here is how to call getAll<\/strong><\/a> method to obtain currency list and exchange rates. If you are not sure how to craft correct Request XML then use tool like SoapUI<\/a>.\r\n\r\nYou can use NetSuite WSDL file\u00a0from here<\/a>\u00a0and import it in\u00a0SoapUI<\/a>.\r\n\r\n\"\"<\/a>\r\n\r\n \r\n\r\nRequest<\/strong>\r\n\r\nSee how Cookie is passed for authentication purpose. Again you can pass this manually or use HTTP connection with Dynamic Token<\/a> to pass it automatically along with each API call.\r\n
          POST https:\/\/webservices.netsuite.com\/services\/NetSuitePort_2017_1\r\nContent-Type: text\/xml;charset=UTF-8\r\nSOAPAction: \"getAll\"\r\nCookie: JSESSIONID=6xI61rxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxMlu!-1798141234\r\nAccept-Encoding: gzip, deflate\r\n\r\n<soapenv:Envelope \r\n   xmlns:soapenv=\"http:\/\/schemas.xmlsoap.org\/soap\/envelope\/\" \r\n   xmlns:urn=\"urn:messages_2018_1.platform.webservices.netsuite.com\" \r\n   xmlns:urn1=\"urn:core_2018_1.platform.webservices.netsuite.com\">\r\n   <soapenv:Body>\r\n      <urn:getAll>\r\n         <record recordType=\"currency\"\/> \r\n      <\/urn:getAll>\r\n   <\/soapenv:Body>\r\n<\/soapenv:Envelope><\/pre>\r\nResponse<\/strong>\r\n
          HTTP\/1.1 200 OK\r\nDate: Wed, 03 Oct 2018 16:50:42 GMT\r\nContent-Length: 9648\r\nContent-Type: text\/xml; charset=utf-8\r\nX-N-OperationId: 1b2989e4-b930-4a72-b471-00a8e131dfd4\r\nNS_RTIMER_COMPOSITE: 21403xxxxxx:706172746E65xxxxxxxxxxxx6F6D:80\r\nStrict-Transport-Security: max-age=31536000\r\nP3P: CP=\"CAO PSAa OUR BUS PUR\"\r\nVary: User-Agent\r\n\r\n<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n<soapenv:Envelope xmlns:soapenv=\"http:\/\/schemas.xmlsoap.org\/soap\/envelope\/\" xmlns:xsd=\"http:\/\/www.w3.org\/2001\/XMLSchema\" xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\">\r\n  <soapenv:Header>\r\n    <platformMsgs:documentInfo xmlns:platformMsgs=\"urn:messages_2017_1.platform.webservices.netsuite.com\">\r\n      <platformMsgs:nsId>WEBSERVICES_TSTDRV1439151_100320189871507121000128715_6ae8e8<\/platformMsgs:nsId>\r\n    <\/platformMsgs:documentInfo>\r\n  <\/soapenv:Header>\r\n  <soapenv:Body>\r\n    <getAllResponse xmlns=\"urn:messages_2018_1.platform.webservices.netsuite.com\">\r\n      <platformCore:getAllResult xmlns:platformCore=\"urn:core_2017_1.platform.webservices.netsuite.com\">\r\n        <platformCore:status isSuccess=\"true\" \/>\r\n        <platformCore:totalRecords>11<\/platformCore:totalRecords>\r\n        <platformCore:recordList>\r\n          <platformCore:record internalId=\"1\" xsi:type=\"listAcct:Currency\" xmlns:listAcct=\"urn:accounting_2017_1.lists.webservices.netsuite.com\">\r\n            <listAcct:name>USD<\/listAcct:name>\r\n            <listAcct:symbol>USD<\/listAcct:symbol>\r\n            <listAcct:isBaseCurrency>true<\/listAcct:isBaseCurrency>\r\n            <listAcct:isInactive>false<\/listAcct:isInactive>\r\n            <listAcct:overrideCurrencyFormat>false<\/listAcct:overrideCurrencyFormat>\r\n            <listAcct:displaySymbol>$<\/listAcct:displaySymbol>\r\n            <listAcct:symbolPlacement>_beforeNumber<\/listAcct:symbolPlacement>\r\n            <listAcct:locale>_unitedStatesEnglish<\/listAcct:locale>\r\n            <listAcct:formatSample>$1,234.56<\/listAcct:formatSample>\r\n            <listAcct:exchangeRate>1.0<\/listAcct:exchangeRate>\r\n            <listAcct:fxRateUpdateTimezone>_americaNewYork<\/listAcct:fxRateUpdateTimezone>\r\n            <listAcct:currencyPrecision>_two<\/listAcct:currencyPrecision>\r\n          <\/platformCore:record>\r\n          <platformCore:record internalId=\"2\" xsi:type=\"listAcct:Currency\" xmlns:listAcct=\"urn:accounting_2017_1.lists.webservices.netsuite.com\">\r\n            <listAcct:name>GBP<\/listAcct:name>\r\n            <listAcct:symbol>GBP<\/listAcct:symbol>\r\n            <listAcct:isBaseCurrency>true<\/listAcct:isBaseCurrency>\r\n            <listAcct:isInactive>false<\/listAcct:isInactive>\r\n            <listAcct:overrideCurrencyFormat>false<\/listAcct:overrideCurrencyFormat>\r\n            <listAcct:displaySymbol>\u00a3<\/listAcct:displaySymbol>\r\n            <listAcct:symbolPlacement>_beforeNumber<\/listAcct:symbolPlacement>\r\n            <listAcct:locale>_unitedKingdomEnglish<\/listAcct:locale>\r\n            <listAcct:formatSample>\u00a31,234.56<\/listAcct:formatSample>\r\n            <listAcct:exchangeRate>1.33165497<\/listAcct:exchangeRate>\r\n            <listAcct:fxRateUpdateTimezone>_americaNewYork<\/listAcct:fxRateUpdateTimezone>\r\n            <listAcct:currencyPrecision>_two<\/listAcct:currencyPrecision>\r\n          <\/platformCore:record>\r\n          <platformCore:record internalId=\"3\" xsi:type=\"listAcct:Currency\" xmlns:listAcct=\"urn:accounting_2017_1.lists.webservices.netsuite.com\">\r\n            <listAcct:name>CAD<\/listAcct:name>\r\n            <listAcct:symbol>CAD<\/listAcct:symbol>\r\n            <listAcct:isBaseCurrency>true<\/listAcct:isBaseCurrency>\r\n            <listAcct:isInactive>false<\/listAcct:isInactive>\r\n            <listAcct:overrideCurrencyFormat>false<\/listAcct:overrideCurrencyFormat>\r\n            <listAcct:displaySymbol>$<\/listAcct:displaySymbol>\r\n            <listAcct:symbolPlacement>_beforeNumber<\/listAcct:symbolPlacement>\r\n            <listAcct:locale>_canadaEnglish<\/listAcct:locale>\r\n            <listAcct:formatSample>$1,234.56<\/listAcct:formatSample>\r\n            <listAcct:exchangeRate>0.76457273<\/listAcct:exchangeRate>\r\n            <listAcct:fxRateUpdateTimezone>_americaNewYork<\/listAcct:fxRateUpdateTimezone>\r\n            <listAcct:currencyPrecision>_two<\/listAcct:currencyPrecision>\r\n          <\/platformCore:record>\r\n        <\/platformCore:recordList>\r\n      <\/platformCore:getAllResult>\r\n    <\/getAllResponse>\r\n  <\/soapenv:Body>\r\n<\/soapenv:Envelope><\/pre>\r\n
          NetSuite Search API (Pagination Example)<\/h3>\r\nNow let's look at more complex API calls where Pagination is needed. For example when you call search API to pull data from specific table (e.g. Account) you need to loop through multiple responses until all records are consumed.\r\n\r\nRequest (Page-1)<\/strong>\r\n
          POST https:\/\/webservices.netsuite.com\/services\/NetSuitePort_2017_1\r\nContent-Type: text\/xml; charset=utf-8\r\nSOAPAction: \"search\"\r\nCookie: JSESSIONID=BKQ7xxxxxxxxxxxx4Ug!-995xxxxxx\r\nAccept-Encoding: gzip, deflate\r\n\r\n<?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n<soap:Envelope xmlns:soap=\"http:\/\/schemas.xmlsoap.org\/soap\/envelope\/\" xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\" xmlns:xsd=\"http:\/\/www.w3.org\/2001\/XMLSchema\">\r\n  <soap:Header>\r\n    <applicationInfo xmlns=\"urn:messages_2017_1.platform.webservices.netsuite.com\">\r\n      <applicationId>xxxxxxxxxxxxxxx<\/applicationId>\r\n    <\/applicationInfo>\r\n    <searchPreferences xmlns=\"urn:messages_2017_1.platform.webservices.netsuite.com\">\r\n      <pageSize>50<\/pageSize>\r\n    <\/searchPreferences>\r\n  <\/soap:Header>\r\n  <soap:Body>\r\n    <search xmlns=\"urn:messages_2017_1.platform.webservices.netsuite.com\">\r\n      <searchRecord xmlns:q1=\"urn:accounting_2017_1.lists.webservices.netsuite.com\" xsi:type=\"q1:AccountSearch\">\r\n        <q1:basic>\r\n          <description operator=\"doesNotContain\" xmlns=\"urn:common_2017_1.platform.webservices.netsuite.com\">\r\n            <searchValue xmlns=\"urn:core_2017_1.platform.webservices.netsuite.com\">x<\/searchValue>\r\n          <\/description>\r\n          <name operator=\"contains\" xmlns=\"urn:common_2017_1.platform.webservices.netsuite.com\">\r\n            <searchValue xmlns=\"urn:core_2017_1.platform.webservices.netsuite.com\">a<\/searchValue>\r\n          <\/name>\r\n        <\/q1:basic>\r\n      <\/searchRecord>\r\n    <\/search>\r\n  <\/soap:Body>\r\n<\/soap:Envelope><\/pre>\r\n \r\n\r\nResponse (Page-1)<\/strong>\r\n\r\nIn below response notice 2 things. SearchId is like a cursor id which you have to pass for each page you request after first page. And you can stop looping after 4th page based on totalPages count.\r\n\r\nplatformCore:searchId<\/strong> = WEBSERVICES_ABCD_12345-xxxxxxxxx\r\nplatformCore:totalPages<\/strong> = 4\r\n
          HTTP\/1.1 200 OK\r\nDate: Wed, 03 Oct 2018 18:40:33 GMT\r\nContent-Length: 49266\r\nContent-Type: text\/xml; charset=utf-8\r\nX-N-OperationId: c1e79336-63b7-4eb7-989e-5c3d24c56891\r\nNS_RTIMER_COMPOSITE: 118xxxxxxxx:70617xxxxxxxxxxxxxxxxxxxxxD:80\r\nStrict-Transport-Security: max-age=31536000\r\nP3P: CP=\"CAO PSAa OUR BUS PUR\"\r\nVary: User-Agent\r\n\r\n<?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n<soapenv:Envelope xmlns:soapenv=\"http:\/\/schemas.xmlsoap.org\/soap\/envelope\/\" xmlns:xsd=\"http:\/\/www.w3.org\/2001\/XMLSchema\" xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\">\r\n  <soapenv:Header>\r\n    <platformMsgs:documentInfo xmlns:platformMsgs=\"urn:messages_2017_1.platform.webservices.netsuite.com\">\r\n      <platformMsgs:nsId>WEBSERVICES_ABCD_12345-xxxxxxxxx<\/platformMsgs:nsId>\r\n    <\/platformMsgs:documentInfo>\r\n  <\/soapenv:Header>\r\n  <soapenv:Body>\r\n    <searchResponse xmlns=\"urn:messages_2017_1.platform.webservices.netsuite.com\">\r\n      <platformCore:searchResult xmlns:platformCore=\"urn:core_2017_1.platform.webservices.netsuite.com\">\r\n        <platformCore:status isSuccess=\"true\" \/>\r\n        <platformCore:totalRecords>193<\/platformCore:totalRecords>\r\n        <platformCore:pageSize>50<\/platformCore:pageSize>\r\n        <platformCore:totalPages>4<\/platformCore:totalPages>\r\n        <platformCore:pageIndex>1<\/platformCore:pageIndex>\r\n        <platformCore:searchId>WEBSERVICES_ABCD_12345-xxxxxxxxx<\/platformCore:searchId>\r\n        <platformCore:recordList>\r\n          <platformCore:record internalId=\"1\" xsi:type=\"listAcct:Account\" xmlns:listAcct=\"urn:accounting_2017_1.lists.webservices.netsuite.com\">\r\n            <listAcct:acctType>_bank<\/listAcct:acctType>\r\n            <listAcct:acctNumber>1111<\/listAcct:acctNumber>\r\n            <listAcct:acctName>Checking<\/listAcct:acctName>\r\n            <listAcct:includeChildren>false<\/listAcct:includeChildren>\r\n            <listAcct:currency internalId=\"1\">\r\n              <platformCore:name>USD<\/platformCore:name>\r\n            <\/listAcct:currency>\r\n            <listAcct:generalRate>_current<\/listAcct:generalRate>\r\n            <listAcct:parent internalId=\"246\">\r\n              <platformCore:name>xxxxxxxxxxxxxxxxxxx<\/platformCore:name>\r\n            <\/listAcct:parent>\r\n            <listAcct:cashFlowRate>_average<\/listAcct:cashFlowRate>\r\n            <listAcct:description>Checking<\/listAcct:description>\r\n            <listAcct:isInactive>false<\/listAcct:isInactive>\r\n            <listAcct:inventory>false<\/listAcct:inventory>\r\n            <listAcct:eliminate>false<\/listAcct:eliminate>\r\n            <listAcct:revalue>true<\/listAcct:revalue>\r\n          <\/platformCore:record>\r\n          <platformCore:record internalId=\"2\" xsi:type=\"listAcct:Account\" xmlns:listAcct=\"urn:accounting_2017_1.lists.webservices.netsuite.com\">\r\n            <listAcct:acctType>_bank<\/listAcct:acctType>\r\n            <listAcct:acctNumber>22222<\/listAcct:acctNumber>\r\n            <listAcct:acctName>Savings<\/listAcct:acctName>\r\n            <listAcct:includeChildren>false<\/listAcct:includeChildren>\r\n            <listAcct:currency internalId=\"1\">\r\n              <platformCore:name>USD<\/platformCore:name>\r\n            <\/listAcct:currency>\r\n            <listAcct:generalRate>_current<\/listAcct:generalRate>\r\n            <listAcct:parent internalId=\"246\">\r\n              <platformCore:name>yyyyyyyyy<\/platformCore:name>\r\n            <\/listAcct:parent>\r\n            <listAcct:cashFlowRate>_average<\/listAcct:cashFlowRate>\r\n            <listAcct:description>Savings<\/listAcct:description>\r\n            <listAcct:isInactive>false<\/listAcct:isInactive>\r\n            <listAcct:inventory>false<\/listAcct:inventory>\r\n            <listAcct:eliminate>false<\/listAcct:eliminate>\r\n            <listAcct:revalue>true<\/listAcct:revalue>\r\n          <\/platformCore:record>\r\n          .........\r\n          .........\r\n          .........\r\n          .........\t\t  \r\n        <\/platformCore:recordList>\r\n      <\/platformCore:searchResult>\r\n    <\/searchResponse>\r\n  <\/soapenv:Body>\r\n<\/soapenv:Envelope><\/pre>\r\n \r\n\r\nRequest (Page-2 and onwards)<\/strong>\r\n\r\nHere is the second page request. Notice few things here. In heraders we are now sending SOAPAction: \"searchMoreWithId\"<\/strong> rather than \"search\"<\/strong>.\u00a0 Also our SOAP Body is also different compared to first page request. Now we only sending pageIndex<\/strong> we want to fetch and searchId<\/strong>. We have also change <search><\/strong> tag with <searchMoreWithId><\/strong> under Body.\r\n
          POST https:\/\/webservices.netsuite.com\/services\/NetSuitePort_2017_1\r\nContent-Type: text\/xml; charset=utf-8\r\nSOAPAction: \"searchMoreWithId\"\r\nCookie: JSESSIONID=BKQ7xxxxxxxxxxxx4Ug!-995xxxxxx\r\nAccept-Encoding: gzip, deflate\r\n\r\n<?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n<soap:Envelope xmlns:soap=\"http:\/\/schemas.xmlsoap.org\/soap\/envelope\/\" xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\" xmlns:xsd=\"http:\/\/www.w3.org\/2001\/XMLSchema\">\r\n  <soap:Header>\r\n    <applicationInfo xmlns=\"urn:messages_2017_1.platform.webservices.netsuite.com\">\r\n      <applicationId>xxxxxxxxxxxxxxxxxx<\/applicationId>\r\n    <\/applicationInfo>\r\n    <searchPreferences xmlns=\"urn:messages_2017_1.platform.webservices.netsuite.com\">\r\n      <pageSize>50<\/pageSize>\r\n    <\/searchPreferences>\r\n  <\/soap:Header>\r\n  <soap:Body>\r\n    <searchMoreWithId xmlns=\"urn:messages_2017_1.platform.webservices.netsuite.com\">\r\n      <searchId>WEBSERVICES_ABCD_12345-xxxxxxxxx<\/searchId>\r\n      <pageIndex>2<\/pageIndex>\r\n    <\/searchMoreWithId>\r\n  <\/soap:Body>\r\n<\/soap:Envelope><\/pre>\r\nResponse (Page-2 and onwards)<\/strong>\r\n
          HTTP\/1.1 200 OK\r\nDate: Wed, 03 Oct 2018 18:40:33 GMT\r\nContent-Length: 49266\r\nContent-Type: text\/xml; charset=utf-8\r\nX-N-OperationId: c1e79336-63b7-4eb7-989e-5c3d24c56891\r\nNS_RTIMER_COMPOSITE: 118xxxxxxxx:70617xxxxxxxxxxxxxxxxxxxxxD:80\r\nStrict-Transport-Security: max-age=31536000\r\nP3P: CP=\"CAO PSAa OUR BUS PUR\"\r\nVary: User-Agent\r\n\r\n<?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n<soapenv:Envelope xmlns:soapenv=\"http:\/\/schemas.xmlsoap.org\/soap\/envelope\/\" xmlns:xsd=\"http:\/\/www.w3.org\/2001\/XMLSchema\" xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\">\r\n  <soapenv:Header>\r\n    <platformMsgs:documentInfo xmlns:platformMsgs=\"urn:messages_2017_1.platform.webservices.netsuite.com\">\r\n      <platformMsgs:nsId>WEBSERVICES_ABCD_12345-xxxxxxxxx<\/platformMsgs:nsId>\r\n    <\/platformMsgs:documentInfo>\r\n  <\/soapenv:Header>\r\n  <soapenv:Body>\r\n    <searchMoreWithIdResponse xmlns=\"urn:messages_2017_1.platform.webservices.netsuite.com\">\r\n      <platformCore:searchResult xmlns:platformCore=\"urn:core_2017_1.platform.webservices.netsuite.com\">\r\n        <platformCore:status isSuccess=\"true\" \/>\r\n        <platformCore:totalRecords>193<\/platformCore:totalRecords>\r\n        <platformCore:pageSize>50<\/platformCore:pageSize>\r\n        <platformCore:totalPages>4<\/platformCore:totalPages>\r\n        <platformCore:pageIndex>2<\/platformCore:pageIndex>\r\n        <platformCore:searchId>WEBSERVICES_ABCD_12345-xxxxxxxxx<\/platformCore:searchId>\r\n        <platformCore:recordList>\r\n          <platformCore:record internalId=\"1\" xsi:type=\"listAcct:Account\" xmlns:listAcct=\"urn:accounting_2017_1.lists.webservices.netsuite.com\">\r\n            <listAcct:acctType>_bank<\/listAcct:acctType>\r\n            <listAcct:acctNumber>8000<\/listAcct:acctNumber>\r\n            <listAcct:acctName>Checking<\/listAcct:acctName>\r\n            <listAcct:includeChildren>false<\/listAcct:includeChildren>\r\n            <listAcct:currency internalId=\"1\">\r\n              <platformCore:name>USD<\/platformCore:name>\r\n            <\/listAcct:currency>\r\n            <listAcct:generalRate>_current<\/listAcct:generalRate>\r\n            <listAcct:parent internalId=\"246\">\r\n              <platformCore:name>xxxxxxxxxxxxxxxxxxx<\/platformCore:name>\r\n            <\/listAcct:parent>\r\n            <listAcct:cashFlowRate>_average<\/listAcct:cashFlowRate>\r\n            <listAcct:description>Checking<\/listAcct:description>\r\n            <listAcct:isInactive>false<\/listAcct:isInactive>\r\n            <listAcct:inventory>false<\/listAcct:inventory>\r\n            <listAcct:eliminate>false<\/listAcct:eliminate>\r\n            <listAcct:revalue>true<\/listAcct:revalue>\r\n          <\/platformCore:record>\r\n          <platformCore:record internalId=\"2\" xsi:type=\"listAcct:Account\" xmlns:listAcct=\"urn:accounting_2017_1.lists.webservices.netsuite.com\">\r\n            <listAcct:acctType>_bank<\/listAcct:acctType>\r\n            <listAcct:acctNumber>8001<\/listAcct:acctNumber>\r\n            <listAcct:acctName>Savings<\/listAcct:acctName>\r\n            <listAcct:includeChildren>false<\/listAcct:includeChildren>\r\n            <listAcct:currency internalId=\"1\">\r\n              <platformCore:name>USD<\/platformCore:name>\r\n            <\/listAcct:currency>\r\n            <listAcct:generalRate>_current<\/listAcct:generalRate>\r\n            <listAcct:parent internalId=\"246\">\r\n              <platformCore:name>yyyyyyyyy<\/platformCore:name>\r\n            <\/listAcct:parent>\r\n            <listAcct:cashFlowRate>_average<\/listAcct:cashFlowRate>\r\n            <listAcct:description>Savings<\/listAcct:description>\r\n            <listAcct:isInactive>false<\/listAcct:isInactive>\r\n            <listAcct:inventory>false<\/listAcct:inventory>\r\n            <listAcct:eliminate>false<\/listAcct:eliminate>\r\n            <listAcct:revalue>true<\/listAcct:revalue>\r\n          <\/platformCore:record>\r\n          .........\r\n          .........\r\n          .........\r\n          .........\t\t  \r\n        <\/platformCore:recordList>\r\n      <\/platformCore:searchResult>\r\n    <\/searchMoreWithIdResponse>\r\n  <\/soapenv:Body>\r\n<\/soapenv:Envelope><\/pre>\r\n \r\n\r\n <\/div>\n
           <\/p>\n
          Getting Started<\/span><\/h2>\n
          Now let\u2019s check step by step instructions on\u00a0how to load NetSuite data in SSIS<\/strong>. In this exercise we will focus on\u00a0calling search API<\/a>\u00a0but you can call virtually any API using the same technique.<\/p>\n
          For detailed help on NetSuite SOAP API and other useful information check\u00a0this documentation<\/a>. To browse schema you can use\u00a0this link<\/a>. From schema browser we will use Search Type name later on in this article. For example later on in this article to search accounts we will use\u00a0AccountSearch<\/strong>\u00a0as below example. This name can be found\u00a0from here(click search tab)<\/a>\u00a0You can change it to something else. For now dont worry too much until we get to that point.<\/p>\n
          \n
          \n
          \n
          <\/div>\n<\/div>\n
          \n
          <<\/span>searchRecord <\/span>xmlns<\/span>:<\/span>q1<\/span>=<\/span>\"urn:accounting_2017_1.lists.webservices.netsuite.com\"<\/span> xsi<\/span>:<\/span>type<\/span>=<\/span>\"q1:AccountSearch\"<\/span>><\/span><\/code><\/div>\n<\/div>\n<\/div>\n
          <\/div>\n<\/div>\n
          Configure SSIS HTTP Connection for NetSuite<\/h3>\n
          Now let’s look at how to configure SSIS HTTP Connection for NetSuite API login. We will use Dynamic Token Approach<\/a>.<\/p>\n
            \n
          1. \n
              \n
            1. Open SSIS Package<\/li>\n
            2. Drag Data flow from SSIS Toolbox and double click it<\/li>\n
            3. Inside data flow SSIS toolbox, find ZS XML Source<\/a>\u00a0and drag it on the surface.<\/li>\n
            4. Double click it to configure. First enter NetSuite API URL. If you need to use latest WebService version e.g. NetSuitePort_2019_1 then you must use company specific endpoint.\n
              https:\/\/webservices.netsuite.com\/services\/NetSuitePort_2017_1<\/pre>\n
              –OR–<\/p>\n
              To use NetSuitePort_2019_1<\/span>\u00a0\u00a0or higher use company specific endpoint like below otherwise you will get error<\/a>. NOTE:<\/strong> You must change Body in coming section to match Version if you use below way.<\/p>\n
              https:\/\/111222333444.suitetalk.api.netsuite.com\/services\/NetSuitePort_2019_1<\/pre>\n<\/li>\n
            5. Check Use Credentials option and Click New HTTP connection.<\/li>\n
            6. Configure general properties of connections as below.\n
                \n
              1. Select Credentials Type as Dynamic Token<\/strong><\/li>\n
              2. Use any URL<\/strong> (It will be ignored)<\/li>\n
              3. Enter your NetSuite UserID, Password<\/li>\n
              4. Enter Header as Cookie<\/strong><\/li>\n
              5. Enter AUth Scheme as JSESSIONID=<\/strong><\/li>\n<\/ol>\n<\/li>\n
              6. First Screen will look like as below. Click Configure.\n
              7. On Dynamic Token<\/strong>\u00a0>\u00a0Request Tab<\/strong> we have to set Token URL, Method, Body, Header.\n
                  \n
                1. In the URL enter same URL again\n
                  https:\/\/webservices.netsuite.com\/services\/NetSuitePort_2017_1<\/pre>\n<\/li>\n
                2. In the Body enter as below. Change APPLICATION-ID and ACCOUNT-ID with correct ID we obtained earlier. [$userid$] and [$password$] is special placeholders will be replaced automatically at runtime.
                  NOTE:<\/strong> Try to match your URL version in the Body Request. If you used For example if you used 2019_1 in URL then change below body to match that version <\/div><\/div>\n
                  <?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n<soap:Envelope xmlns:soap=\"http:\/\/schemas.xmlsoap.org\/soap\/envelope\/\" xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\" xmlns:xsd=\"http:\/\/www.w3.org\/2001\/XMLSchema\">\r\n  <soap:Header>\r\n    <applicationInfo xmlns=\"urn:messages_2017_1.platform.webservices.netsuite.com\">\r\n      <applicationId>xxxxxxYOUR-APPLICATION-IDxxxxxx<\/applicationId>\r\n    <\/applicationInfo>\r\n  <\/soap:Header>\r\n  <soap:Body>\r\n    <login xmlns=\"urn:messages_2017_1.platform.webservices.netsuite.com\">\r\n      <passport>\r\n        <email xmlns=\"urn:core_2017_1.platform.webservices.netsuite.com\">[$userid$]<\/email>\r\n        <password xmlns=\"urn:core_2017_1.platform.webservices.netsuite.com\">[$password$]<\/password>\r\n        <account xmlns=\"urn:core_2017_1.platform.webservices.netsuite.com\">xxxxxxYOUR-ACCOUNT-IDxxxxxx<\/account>\r\n        <role internalId=\"3\" xmlns=\"urn:core_2017_1.platform.webservices.netsuite.com\" \/>\r\n      <\/passport>\r\n    <\/login>\r\n  <\/soap:Body>\r\n<\/soap:Envelope><\/pre>\n
                  NOTE: Remove below line from above Body if you get INVALID_ROLE error later in this tutorial. If if you get INVALID_LOGIN_CREDENTIALS error then refer here.<\/div><\/div>\n
                  <role internalId=\"3\" xmlns=\"urn:core_2017_1.platform.webservices.netsuite.com\" \/><\/pre>\n<\/li>\n
                3. Select Content Type as text\/xml<\/li>\n
                4. In the Headers click on Raw Edit Button and enter like below.\n
                  SOAPAction: \"login\"<\/pre>\n<\/li>\n<\/ol>\n<\/li>\n
                5. Once all settings done your Request<\/strong> Tab will look like below\n
                6. On Response<\/strong> Tab configure like below. You have to enter Cookie name as JSESSIONID<\/strong>\n
                7. Click OK to Save Connection.<\/li>\n
                8. We will configure XML Source in next section.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n
                  Configure SSIS XML Source to read NetSuite data<\/h3>\n
                  Now let’s continue configuration of XML Source.\u00a0In this section we will show you how to get data without pagination. In next section we will see how to modify XML Source Settings to pagination request to read many records (e.g. 1000+ rows).<\/p>\n
                    \n
                  1. On your XML Source enter NetSuite Webservice URL like below.\n
                    https:\/\/webservices.netsuite.com\/services\/NetSuitePort_2017_1<\/pre>\n<\/li>\n
                  2. Now check Use Credentials and select previously created HTTP connection.<\/li>\n
                  3. Select Method as\u00a0\u00a0POST<\/strong> and content type as text\/xml<\/strong><\/li>\n
                  4. Edit Request Body and enter like below (or any other XML body for API you like to call. Make sure SOAPAction in next step updated correctly too for other action)
                    NOTE: Try to match your URL version in the Body Request. If you used For example if you used 2019_1 in URL then change below body to match that version <\/div><\/div>\n
                    <soapenv:Envelope \r\n   xmlns:soapenv=\"http:\/\/schemas.xmlsoap.org\/soap\/envelope\/\" \r\n   xmlns:urn=\"urn:messages_2018_1.platform.webservices.netsuite.com\" \r\n   xmlns:urn1=\"urn:core_2018_1.platform.webservices.netsuite.com\">\r\n   <soapenv:Body>\r\n      <urn:getAll>\r\n         <record recordType=\"currency\"\/> \r\n      <\/urn:getAll>\r\n   <\/soapenv:Body>\r\n<\/soapenv:Envelope><\/pre>\n<\/li>\n
                  5. NOTE: If you used\u00a0NetSuitePort_2019_1 or higher version in URL then make sure you changed version\u00a0\u00a02017_1<\/strong> to 2019_1<\/strong> in below body<\/div><\/div><\/li>\n
                  6. Now you click Raw Edit above headers grid and enter method name in SOAPAction (e.g. getAll<\/strong> in our case)\n
                    SOAPAction: \"getAll\"<\/pre>\n
                    NOTE: SOAPAction Header is very important so make sure you change it to match Action you like to call. You can Use Correct WebService WSDL File (Metadata)<\/a>\u00a0\u00a0in Tool like SOAPUI as explained here<\/a><\/p>\n
                    Version 2017_1 WSDL Link<\/a>
                    \n                    Version 2018_1 WSDL Link<\/a>
                    \n                    Version 2019_1 WSDL Link<\/a>
                    \nFor Other Versions Just Change URL Version Part to different Number e.g. 2019_2_0<\/strong><\/p>\n<\/div><\/div><\/li>\n
                  7. Now enter Filter like below or navigate by clicking Select Filter button.\n
                    $.soapenv:Envelope.soapenv:Body.getAllResponse.platformCore:getAllResult.platformCore:recordList.platformCore:record[*]<\/pre>\n
                    \"Configure<\/a>
                    Configure XML Source – NetSuite SOAP API getAll (Body, Header, ContentType, Method, Filter)<\/p><\/div><\/li>\n
                  8. Now click preview data.\n
                  9. Click OK to save XML Source UI<\/li>\n
                  10. Now you can connect XML Source to target like OLEDB Destination and load NetSuite data into SQL Server.<\/li>\n<\/ol>\n
                    Configure\u00a0SSIS XML Source with Pagination<\/h3>\n
                    So in previous section we saw how to configure XML Source for basic API calls (without pagination). In this section we will see how to call more complex API (e.g. search ) which requires pagination. Some ideas about NetSuite Pagination discussed here too<\/a>.<\/p>\n
                    Foe pagination setup using XML Source we have to configure following properties via Properties Grid or Advanced Edit rather than Normal UI. May of these properties not available via UI as of now.<\/p>\n
                      \n
                    1. Create new data flow and drag new ZS XML Source.<\/li>\n
                    2. Right click on XML Source and click Properties in Data flow designer. Find property by name in the Grid and set correct value.
                      \nNOTE:<\/strong> In newer version v3.1.2 or higher you can use XML Source UI to enter some multi line properties for ease of use (e.g.\u00a0FirstPageBodyPart and NextPageBodyPart can be entered on Advanced Pagination Tab, all other properties are easier to enter from Grid Mode if you sort alphabetically)<\/li>\n<\/ol>\n
                      \n\n\n\n\n\n\n\n\n\n\n\n\n
                      ElementsToTreatAsArray<\/td>\nplatformCore:record<\/td>\n<\/tr>\n
                      EnablePageTokenForBody<\/td>\nTrue<\/td>\n<\/tr>\n
                      Filter<\/td>\n$.soapenv:Envelope.soapenv:Body.search[$tag$]Response.platformCore:searchResult.platformCore:recordList.platformCore:record[*]<\/td>\n<\/tr>\n
                      FirstPageBodyPart<\/td>\n\n
                          <search xmlns=\"urn:messages_2017_1.platform.webservices.netsuite.com\">\r\n      <searchRecord xmlns:q1=\"urn:accounting_2017_1.lists.webservices.netsuite.com\" xsi:type=\"q1:AccountSearch\">\r\n        <q1:basic>\r\n          <description operator=\"doesNotContain\" xmlns=\"urn:common_2017_1.platform.webservices.netsuite.com\">\r\n            <searchValue xmlns=\"urn:core_2017_1.platform.webservices.netsuite.com\">x<\/searchValue>\r\n          <\/description>\r\n          <name operator=\"contains\" xmlns=\"urn:common_2017_1.platform.webservices.netsuite.com\">\r\n            <searchValue xmlns=\"urn:core_2017_1.platform.webservices.netsuite.com\">a<\/searchValue>\r\n          <\/name>\r\n        <\/q1:basic>\r\n      <\/searchRecord>\r\n    <\/search><\/pre>\n
                      Change as per your need but we used above example search<\/td>\n<\/tr>\n
                      HasDifferentNextPageInfo<\/td>\nTrue<\/td>\n<\/tr>\n
                      NextPageBodyPart<\/td>\n\n
                          <searchMoreWithId xmlns=\"urn:messages_2017_1.platform.webservices.netsuite.com\">\r\n      <searchId>[$pagetoken$]<\/searchId>\r\n      <pageIndex>[$pagenumber$]<\/pageIndex>\r\n    <\/searchMoreWithId><\/pre>\n
                       <\/td>\n<\/tr>\n
                      NextUrlAttribute<\/td>\n$.soapenv:Envelope.soapenv:Body.search[$tag$]Response.platformCore:searchResult.platformCore:searchId<\/td>\n<\/tr>\n
                      PagePlaceholders<\/td>\nheader=|MoreWithId;filter=|MoreWithId<\/td>\n<\/tr>\n
                      PagesMaxPagesExpr<\/td>\n$.soapenv:Envelope.soapenv:Body.searchResponse.platformCore:searchResult.platformCore:totalPages<\/td>\n<\/tr>\n
                      <\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
                      Once above items are set in property grid. Double click XML source to edit few more items from UI.<\/p>\n
                        \n
                      1. Enter URL as below\n
                        https:\/\/webservices.netsuite.com\/services\/NetSuitePort_2017_1<\/pre>\n<\/li>\n
                      2. Check Use Credentials and select HTTP connection<\/strong> we created in previous section.<\/li>\n
                      3. Click Raw Edit<\/strong> button (above headers grid) and enter below\n
                        SOAPAction: \"search[$tag$]\"<\/pre>\n<\/li>\n
                      4. Click on Edit button next to Body. Enter following XML fragment for search request. Change ApplicationId<\/strong> and adjust PageSize if needed.\n
                        <?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n<soap:Envelope xmlns:soap=\"http:\/\/schemas.xmlsoap.org\/soap\/envelope\/\" xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\" xmlns:xsd=\"http:\/\/www.w3.org\/2001\/XMLSchema\">\r\n  <soap:Header>\r\n    <applicationInfo xmlns=\"urn:messages_2017_1.platform.webservices.netsuite.com\">\r\n      <applicationId>ABCD-1234-XXXXXXXXXXXXXXX<\/applicationId>\r\n    <\/applicationInfo>\r\n    <searchPreferences xmlns=\"urn:messages_2017_1.platform.webservices.netsuite.com\">\r\n      <pageSize>100<\/pageSize>\r\n    <\/searchPreferences>\r\n  <\/soap:Header>\r\n  <soap:Body>\r\n[$tag$]\r\n  <\/soap:Body>\r\n<\/soap:Envelope><\/pre>\n<\/li>\n
                      5. Select POST<\/strong> method, change content type to XML (text \/ xml, charset=UTF-8)<\/strong><\/li>\n
                      6. That’s it. Click ‘Preview to confirm.<\/li>\n
                      7. Click ok to save XML Source.\n
                        \"Read<\/a>
                        Read NetSuite data in SSIS with Pagination ( search, searchMoreWithId API call)<\/p><\/div><\/li>\n<\/ol>\n
                        Configure SQL Server Destination to load NetSuite data<\/h3>\n
                        Once you have XML Source configured you can connect XML Source to Target (OLEDB Destination) and load data into SQL Server.<\/p>\n
                        Conclusion<\/h2>\n
                        In this post we explored many advanced options of HTTP Connection and XML Source to enable NetSuite API integration in SSIS. Download SSIS PowerPack<\/a> today for FREE to uncover many other data integration scenarios not discussed in this article.<\/p>\n","protected":false},"excerpt":{"rendered":"
                        Introduction In this post we will learn how to read data from NetSuite in SSIS. We will use ZappySys XML Source for SOAP API access.     What is NetSuite CRM? NetSuite is a CRM \/ ERP product. It gives you scalable cloud CRM \/ ERP solution targeted at high-growing, mid-sized businesses and large enterprises. […]<\/p>\n","protected":false},"author":1,"featured_media":5110,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[225,16,8,62],"tags":[366,67],"yoast_head":"\r\nHow to read data from NetSuite in SSIS (SimpleTalk SOAP API) | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"Learn how to read data from NetSuite in SSIS. We will explore how to call NetSuite SOAP API in SSIS, configure API pagination. Load NetSuite in SQL Server.\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/zappysys.com\/blog\/read-data-netsuite-ssis-simpletalk-soap-api\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"How to read data from NetSuite in SSIS (SimpleTalk SOAP API) | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"Learn how to read data from NetSuite in SSIS. We will explore how to call NetSuite SOAP API in SSIS, configure API pagination. Load NetSuite in SQL Server.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/read-data-netsuite-ssis-simpletalk-soap-api\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/ZappySys\/\" \/>\r\n<meta property=\"article:published_time\" content=\"2018-09-06T15:59:12+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2020-05-29T21:48:49+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/09\/netsuite-logo.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"665\" \/>\r\n\t<meta property=\"og:image:height\" content=\"471\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"ZappySys\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/zappysys\/\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ZappySys\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/read-data-netsuite-ssis-simpletalk-soap-api\/\",\"url\":\"https:\/\/zappysys.com\/blog\/read-data-netsuite-ssis-simpletalk-soap-api\/\",\"name\":\"How to read data from NetSuite in SSIS (SimpleTalk SOAP API) | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/read-data-netsuite-ssis-simpletalk-soap-api\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/read-data-netsuite-ssis-simpletalk-soap-api\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/09\/netsuite-logo.png\",\"datePublished\":\"2018-09-06T15:59:12+00:00\",\"dateModified\":\"2020-05-29T21:48:49+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\"},\"description\":\"Learn how to read data from NetSuite in SSIS. We will explore how to call NetSuite SOAP API in SSIS, configure API pagination. Load NetSuite in SQL Server.\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/read-data-netsuite-ssis-simpletalk-soap-api\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/read-data-netsuite-ssis-simpletalk-soap-api\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/read-data-netsuite-ssis-simpletalk-soap-api\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/09\/netsuite-logo.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/09\/netsuite-logo.png\",\"width\":665,\"height\":471},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/read-data-netsuite-ssis-simpletalk-soap-api\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to read data from NetSuite in SSIS (SimpleTalk SOAP API)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/zappysys.com\/blog\/#website\",\"url\":\"https:\/\/zappysys.com\/blog\/\",\"name\":\"ZappySys Blog\",\"description\":\"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/zappysys.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\",\"name\":\"ZappySys\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g\",\"caption\":\"ZappySys\"},\"sameAs\":[\"http:\/\/www.zappysys.com\/\",\"https:\/\/www.facebook.com\/ZappySys\/\",\"https:\/\/twitter.com\/https:\/\/twitter.com\/zappysys\/\"],\"url\":\"https:\/\/zappysys.com\/blog\/author\/admin\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to read data from NetSuite in SSIS (SimpleTalk SOAP API) | ZappySys Blog","description":"Learn how to read data from NetSuite in SSIS. We will explore how to call NetSuite SOAP API in SSIS, configure API pagination. Load NetSuite in SQL Server.","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:\/\/zappysys.com\/blog\/read-data-netsuite-ssis-simpletalk-soap-api\/","og_locale":"en_US","og_type":"article","og_title":"How to read data from NetSuite in SSIS (SimpleTalk SOAP API) | ZappySys Blog","og_description":"Learn how to read data from NetSuite in SSIS. We will explore how to call NetSuite SOAP API in SSIS, configure API pagination. Load NetSuite in SQL Server.","og_url":"https:\/\/zappysys.com\/blog\/read-data-netsuite-ssis-simpletalk-soap-api\/","og_site_name":"ZappySys Blog","article_author":"https:\/\/www.facebook.com\/ZappySys\/","article_published_time":"2018-09-06T15:59:12+00:00","article_modified_time":"2020-05-29T21:48:49+00:00","og_image":[{"width":665,"height":471,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/09\/netsuite-logo.png","type":"image\/png"}],"author":"ZappySys","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/zappysys\/","twitter_misc":{"Written by":"ZappySys","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/read-data-netsuite-ssis-simpletalk-soap-api\/","url":"https:\/\/zappysys.com\/blog\/read-data-netsuite-ssis-simpletalk-soap-api\/","name":"How to read data from NetSuite in SSIS (SimpleTalk SOAP API) | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/read-data-netsuite-ssis-simpletalk-soap-api\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/read-data-netsuite-ssis-simpletalk-soap-api\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/09\/netsuite-logo.png","datePublished":"2018-09-06T15:59:12+00:00","dateModified":"2020-05-29T21:48:49+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82"},"description":"Learn how to read data from NetSuite in SSIS. We will explore how to call NetSuite SOAP API in SSIS, configure API pagination. Load NetSuite in SQL Server.","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/read-data-netsuite-ssis-simpletalk-soap-api\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/read-data-netsuite-ssis-simpletalk-soap-api\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/read-data-netsuite-ssis-simpletalk-soap-api\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/09\/netsuite-logo.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/09\/netsuite-logo.png","width":665,"height":471},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/read-data-netsuite-ssis-simpletalk-soap-api\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to read data from NetSuite in SSIS (SimpleTalk SOAP API)"}]},{"@type":"WebSite","@id":"https:\/\/zappysys.com\/blog\/#website","url":"https:\/\/zappysys.com\/blog\/","name":"ZappySys Blog","description":"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/zappysys.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82","name":"ZappySys","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g","caption":"ZappySys"},"sameAs":["http:\/\/www.zappysys.com\/","https:\/\/www.facebook.com\/ZappySys\/","https:\/\/twitter.com\/https:\/\/twitter.com\/zappysys\/"],"url":"https:\/\/zappysys.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/4755"}],"collection":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/comments?post=4755"}],"version-history":[{"count":8,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/4755\/revisions"}],"predecessor-version":[{"id":8957,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/4755\/revisions\/8957"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/5110"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=4755"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=4755"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=4755"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}