{"id":15709,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/webhizmeti\/"},"modified":"2021-02-25T16:38:58","modified_gmt":"2021-02-25T16:38:58","slug":"webservice","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/webservice\/","title":{"rendered":"WEBH\u0130ZMET\u0130"},"content":{"rendered":"

Microsoft Excel’in g\u00fc\u00e7l\u00fc \u00f6zelliklerinden biri olan WEBSERVICE<\/em> (T\u00fcrk\u00e7e’de WEBH\u0130ZMET\u0130<\/em>) fonksiyonu, belirli bir URL’den veri \u00e7ekme imkan\u0131 sunar. Bu i\u015flev, \u00f6zellikle \u00e7evrimi\u00e7i veri kaynaklar\u0131ndan veri elde etmek i\u00e7in kullan\u0131l\u0131r. Ancak bu fonksiyon yaln\u0131zca Microsoft Excel’de bulunur ve Google Sheets i\u00e7in do\u011frudan bir alternatifi mevcut de\u011fildir. Bu yaz\u0131da, WEBH\u0130ZMET\u0130<\/em> fonksiyonunun nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 anlataca\u011f\u0131z.<\/p>\n

WEBH\u0130ZMET\u0130 Fonksiyonunun S\u00f6zdizimi<\/h2>\n

WEBSERVICE(url)<\/code> fonksiyonunun temel s\u00f6zdizimi olduk\u00e7a basittir. url<\/code> parametresi, veri almak istedi\u011finiz web sayfas\u0131n\u0131n adresini belirtir.<\/p>\n

 =WEBSERVICE(\"http:\/\/example.com\/data\") <\/code><\/pre>\n
Bu fonksiyon verilen URL’ye bir HTTP GET iste\u011fi g\u00f6nderir ve ald\u0131\u011f\u0131 yan\u0131t\u0131 metin olarak d\u00f6nd\u00fcr\u00fcr.<\/p>\n
Pratik Kullan\u0131m Senaryolar\u0131<\/h2>\n
    \n
  • D\u00f6viz Kuru \u00c7ekme:<\/strong> Finansal analizlerde g\u00fcnl\u00fck d\u00f6viz kurlar\u0131n\u0131 \u00e7ekmek gerekebilir. Bu ama\u00e7la, g\u00fcvenilir bir finansal veri sa\u011flay\u0131c\u0131s\u0131n\u0131n API’sini kullanabilirsiniz.<\/li>\n
  • Hava Durumu Bilgileri:<\/strong> Belirli bir lokasyon i\u00e7in g\u00fcncel hava durumu bilgisine eri\u015fmek i\u00e7in meteoroloji servislerinin API’lar\u0131n\u0131 kullanabilirsiniz.<\/li>\n<\/ul>\n
    \u00d6rnek Uygulamalar<\/h2>\n
    1. D\u00f6viz Kuru \u00c7ekme<\/h3>\n
    Birinci \u00f6rne\u011fimizde, Amerika Birle\u015fik Devletleri dolar\u0131 (USD) ile Euro (EUR) aras\u0131ndaki g\u00fcncel d\u00f6viz kuru bilgisini \u00e7ekiyoruz. Bu i\u015flem i\u00e7in g\u00fcvenilir bir API sa\u011flay\u0131c\u0131s\u0131 olan ExchangeRate-API<\/strong>‘yi kullanaca\u011f\u0131z.<\/p>\n
     =WEBSERVICE(\"https:\/\/api.exchangerate-api.com\/v4\/latest\/USD\") <\/code><\/pre>\n
    Bu fonksiyon, USD baz alarak di\u011fer para birimleri ile olan g\u00fcncel d\u00f6viz kurlar\u0131n\u0131 JSON format\u0131nda d\u00f6nd\u00fcr\u00fcr. Elde edilen JSON verisini i\u015flemek i\u00e7in ekstra fonksiyonlar veya makrolar gerekli olabilir.<\/p>\n
    2. Hava Durumu Bilgileri<\/h3>\n
    \u0130kinci \u00f6rne\u011fimizde, \u0130stanbul i\u00e7in g\u00fcncel hava durumu bilgisini \u00e7ekece\u011fiz. Bu \u00f6rnekte, pop\u00fcler bir hava durumu API’si olan OpenWeatherMap<\/strong>‘\u0131 kullanaca\u011f\u0131z.<\/p>\n
     =WEBSERVICE(\"http:\/\/api.openweathermap.org\/data\/2.5\/weather?q=Istanbul&appid=your_api_key\") <\/code><\/pre>\n
    Bu fonksiyon, API anahtar\u0131n\u0131zla \u0130stanbul’un hava durumu verisini JSON format\u0131nda sa\u011flar. Al\u0131nan veriyi i\u015flemek i\u00e7in JSON i\u015fleme fonksiyonlar\u0131na ihtiya\u00e7 duyulabilir.<\/p>\n
    Bu fonksiyonlar\u0131 kullan\u0131rken veri gizlili\u011fi ve API’nin kullan\u0131m ko\u015fullar\u0131 g\u00f6z \u00f6n\u00fcnde bulundurulmal\u0131d\u0131r. Ayr\u0131ca, bu t\u00fcr web tabanl\u0131 sorgular\u0131n \u00e7al\u0131\u015fma s\u00fcresi, hesaplamalar\u0131n\u0131z\u0131n verimlili\u011fini etkileyebilir. Do\u011fru API anahtarlar\u0131 ve URL bilgileri ile yap\u0131land\u0131r\u0131ld\u0131\u011f\u0131nda, WEBSERVICE<\/em> fonksiyonu Excel kullan\u0131c\u0131lar\u0131na b\u00fcy\u00fck kolayl\u0131k sa\u011flar ve veri g\u00fcncellemelerini otomatikle\u015ftirir.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Bir web hizmetinden al\u0131nan verileri getirir<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[590],"tags":[],"class_list":["post-15709","post","type-post","status-publish","format-standard","hentry","category-web-13"],"acf":[],"yoast_head":"\nExcel'de WEBSERVICE (WEBH\u0130ZMET\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da WEBSERVICE (WEBH\u0130ZMET\u0130) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/tr\/webservice\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de WEBSERVICE (WEBH\u0130ZMET\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da WEBSERVICE (WEBH\u0130ZMET\u0130) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/tr\/webservice\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:38:58+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel'de WEBSERVICE (WEBH\u0130ZMET\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/webservice\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/webservice\/\",\"name\":\"Excel'de WEBSERVICE (WEBH\u0130ZMET\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:53+00:00\",\"dateModified\":\"2021-02-25T16:38:58+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da WEBSERVICE (WEBH\u0130ZMET\u0130) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/tr\/webservice\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/webservice\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/webservice\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Web\",\"item\":\"https:\/\/functiontranslator.com\/tr\/web-13\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"WEBH\u0130ZMET\u0130\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel'de WEBSERVICE (WEBH\u0130ZMET\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da WEBSERVICE (WEBH\u0130ZMET\u0130) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","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:\/\/functiontranslator.com\/tr\/webservice\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de WEBSERVICE (WEBH\u0130ZMET\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da WEBSERVICE (WEBH\u0130ZMET\u0130) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","og_url":"https:\/\/functiontranslator.com\/tr\/webservice\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:38:58+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de WEBSERVICE (WEBH\u0130ZMET\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/webservice\/","url":"https:\/\/functiontranslator.com\/tr\/webservice\/","name":"Excel'de WEBSERVICE (WEBH\u0130ZMET\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:53+00:00","dateModified":"2021-02-25T16:38:58+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da WEBSERVICE (WEBH\u0130ZMET\u0130) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/tr\/webservice\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/webservice\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/webservice\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Web","item":"https:\/\/functiontranslator.com\/tr\/web-13\/"},{"@type":"ListItem","position":3,"name":"WEBH\u0130ZMET\u0130"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15709","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/comments?post=15709"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15709\/revisions"}],"predecessor-version":[{"id":27066,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15709\/revisions\/27066"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15709"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15709"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15709"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}