{"id":5361,"date":"2022-08-28T08:11:40","date_gmt":"2022-08-28T02:41:40","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-insert-xml-data-into-sql-server-c-twilio-closed\/"},"modified":"2022-08-28T08:11:40","modified_gmt":"2022-08-28T02:41:40","slug":"solved-insert-xml-data-into-sql-server-c-twilio-closed","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-insert-xml-data-into-sql-server-c-twilio-closed\/","title":{"rendered":"[Solved] insert xml data into sql server c# twilio [closed]"},"content":{"rendered":"

[ad_1]
\n<\/p>\n

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

So here’s my two cents:<\/p>\n

    \n
  1. \n

    Get a clear idea of the flow of information. (e.g. if you’re pulling information from somewhere via RESTful web services, you’ll likely need to get the client API documentation and build your API calls around the existing methods. If the client (Twilio) is pushing information to you, then it will need to know how to call your web service\/s).<\/p>\n<\/li>\n

  2. \n

    Once you know how you are getting the XML, I would recommend building at least one layer of abstraction like a Data Access layer which has your actual method that executes a stored procedure with the XML as an input parameter. For instance, you could create a method: <\/p>\n

    GetTwilioResponse(customTypeToHoldTwilioAPIparams params)\n{\n    Here would be your code for calling the Twilio API.  \n    Somewhere in here, if the response from Twilio is good, then call a method in another class that will call the stored procedure;\n}\n<\/code><\/pre>\n<\/li>\n
  3. \n
    After you figure out how the SP is going to be executed, you can write your stored procedure to iterate over the XML and put it into the database.<\/p>\n<\/li>\n
  4. \n
    If you’re pulling from the client, you’ll need to implement some sort of scheduling mechanism too.<\/p>\n<\/li>\n<\/ol>\n
    This is just one opinion on how to proceed.  This is just how I would approach the task if it were me \ud83d\ude42<\/p>\n
    Edit: Looking at the twilio documentation, it looks like you’ll be pulling from Twilio via the Twilio REST API<\/a>.  In this case, you’ll probably need to first figure out your mechanism for calling it on a pre-determined basis, then worry about the implementation in code.  <\/p>\n<\/p><\/div>\n
    <\/div>\n<\/div>\n
                <\/span> <\/p><\/div>\n<\/div>\n
    [ad_2]<\/p>\n
    solved insert xml data into sql server c# twilio [closed] <\/p>\n","protected":false},"excerpt":{"rendered":"
    [ad_1] So here’s my two cents: Get a clear idea of the flow of information. (e.g. if you’re pulling information from somewhere via RESTful web services, you’ll likely need to get the client API documentation and build your API calls around the existing methods. If the client (Twilio) is pushing information to you, then it … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[324,500,1335,1236,577],"class_list":["post-5361","post","type-post","status-publish","format-standard","hentry","category-solved","tag-c","tag-sql-server","tag-twilio","tag-web-services","tag-xml"],"yoast_head":"\n[Solved] insert xml data into sql server c# twilio [closed] - JassWeb<\/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:\/\/jassweb.com\/solved\/solved-insert-xml-data-into-sql-server-c-twilio-closed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] insert xml data into sql server c# twilio [closed] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] So here’s my two cents: Get a clear idea of the flow of information. (e.g. if you’re pulling information from somewhere via RESTful web services, you’ll likely need to get the client API documentation and build your API calls around the existing methods. If the client (Twilio) is pushing information to you, then it ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-insert-xml-data-into-sql-server-c-twilio-closed\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-08-28T02:41:40+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-insert-xml-data-into-sql-server-c-twilio-closed\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-insert-xml-data-into-sql-server-c-twilio-closed\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] insert xml data into sql server c# twilio [closed]\",\"datePublished\":\"2022-08-28T02:41:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-insert-xml-data-into-sql-server-c-twilio-closed\/\"},\"wordCount\":255,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"c++\",\"sql-server\",\"twilio\",\"web-services\",\"xml\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-insert-xml-data-into-sql-server-c-twilio-closed\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-insert-xml-data-into-sql-server-c-twilio-closed\/\",\"name\":\"[Solved] insert xml data into sql server c# twilio [closed] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-08-28T02:41:40+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-insert-xml-data-into-sql-server-c-twilio-closed\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-insert-xml-data-into-sql-server-c-twilio-closed\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-insert-xml-data-into-sql-server-c-twilio-closed\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] insert xml data into sql server c# twilio [closed]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] insert xml data into sql server c# twilio [closed] - JassWeb","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:\/\/jassweb.com\/solved\/solved-insert-xml-data-into-sql-server-c-twilio-closed\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] insert xml data into sql server c# twilio [closed] - JassWeb","og_description":"[ad_1] So here’s my two cents: Get a clear idea of the flow of information. (e.g. if you’re pulling information from somewhere via RESTful web services, you’ll likely need to get the client API documentation and build your API calls around the existing methods. If the client (Twilio) is pushing information to you, then it ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-insert-xml-data-into-sql-server-c-twilio-closed\/","og_site_name":"JassWeb","article_published_time":"2022-08-28T02:41:40+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-insert-xml-data-into-sql-server-c-twilio-closed\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-insert-xml-data-into-sql-server-c-twilio-closed\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] insert xml data into sql server c# twilio [closed]","datePublished":"2022-08-28T02:41:40+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-insert-xml-data-into-sql-server-c-twilio-closed\/"},"wordCount":255,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["c++","sql-server","twilio","web-services","xml"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-insert-xml-data-into-sql-server-c-twilio-closed\/","url":"https:\/\/jassweb.com\/solved\/solved-insert-xml-data-into-sql-server-c-twilio-closed\/","name":"[Solved] insert xml data into sql server c# twilio [closed] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-08-28T02:41:40+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-insert-xml-data-into-sql-server-c-twilio-closed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-insert-xml-data-into-sql-server-c-twilio-closed\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-insert-xml-data-into-sql-server-c-twilio-closed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] insert xml data into sql server c# twilio [closed]"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/5361","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=5361"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/5361\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=5361"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=5361"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=5361"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}