Integration with the Yandex XML API

Yandex XML allows you to extract search results for a specific query. 

To configure the settings, follow these steps: 

1. Write settingshttps://xml.yandex.ru/settings/: IP address from which calls will be made

2. Perform a query test and generate the request body as a URLhttps://xml.yandex.ru/test/

3. The implementation of an outbound API call 

Procedure Request 

CREATE PROCEDURE [dbo].[api_yandexxml_request]
	@parameters ExtendedDictionaryParameter READONLY,  -- incoming parameters for internal processing (use 
	Key, Value2)
	@username nvarchar(32)  -- current user.
AS
BEGIN
	-- SELECT 1  Msg, Result, Url (address where the request will go)
	select '' Msg, 1 Result, 'https://yandex.ru/search/xml?user=dobrovolec31&key=03.79579838:
	0320f8517953936d413c99a14b583a03&query=%D0%B4%D0%B2%D0%B8%D0%B6%D0%BE%D0%BA+%D0%BC%D0%B0%D1%80%D0%BA%
	D0%B5%D1%82%D0%BF%D0%BB%D0%B5%D0%B9%D1%81%D0%B0&l10n=ru&sortby=rlv&filter=strict&
	maxpassages=5&groupby=attr%3Dd.mode%3Ddeep.groups-on-page%3D10.docs-in-group%3D3' Url

	-- SELECT 2 PARAMETERS - parameters that will be passed to an external source
--	select 'id' name, '5' value, '' [type] -- form (in the form passed), header (в http headers), send
 get requests directly to URL
END

Response procedure unchanged (here you can organize saving positions in the database + parsing data)

CREATE PROCEDURE [dbo].[api_yandexxml_response]
	@response nvarchar(max),
	@parameters ExtendedDictionaryParameter READONLY,  -- incoming parameters for internal processing (use Key,
	Value2 - the same as on request)

	@username nvarchar(32)
AS
BEGIN
	-- SELECT 1
	select '' Msg, 1 Result, @response Response
	-- SELECT 2 External action
END

4. Click the Call or Direct button and check that the request passes normally. 

Note: 

Limits on requests can be found here - https://xml.yandex.ru/limits/

You can use similar code to process incoming XML: 

declare @string  nvarchar(max) = N'\nthe engine of the marketplace0rlv51589898908494003-1839658126566110043500300
-prestable-app-host-sas-web-yp-107-XML274894627489462748946Нашлось 3 млн ответов345734573457270642027064202706420found 3 million responses028https://
www.agora.ru/blog/cms-dlja-marketplejsa-vse-chto-nuzhno-znat-pered-startom/www.agora.ruЧто такое <hlword>маркетплейс</hlword>?Chose CMS 
for Marketplace20190123T1943172676utf-8Marketplace — this is an electronic trading platform where many different sellers display their products 
in a common window. This is the principle used by well-known companies...<_PassagesType>0rutext/htmlhttps://yandexwebcache.net/yandbtm?lang=ru
&fmode=inject&tm=1589898908&tld=ru&la=1589537408&text=%D0%B4%D0%B2%D0%B8%D0%B6%D0%BE%D0%BA%20%D0%BC%D0%B0%D1%80%D0%BA%D0%B5%D1%82
%D0%BF%D0%BB%D0%B5%D0%B9%D1%81%D0%B0&url=https%3A%2F%2Fwww.agora.ru%2Fblog%2Fcms-dlja-marketplejsa-vse-chto-nuzhno-znat-pered-startom%2F&l10n
=ru&mime=html&sign=847937c95bf85a40ba85cdb3975df9b1&keyno=0https://www.agora.ru/prices/www.agora.ruPrices20200115T0300001126utf-8Marketplace.
The e-auction. Integration with SAP.Online store. The marketplace (the marketplace). Electronic bidding.<_PassagesType>0rutext/htmlhttps://yandex
webcache.net/yandbtm?lang=ru&fmode=inject&tm=1589898908&tld=ru&la=1589537408&text=%D0%B4%D0%B2%D0%B8%D0%B6%D0%BE%D0%BA%20%D0%BC%D0
%B0%D1%80%D0%BA%D0%B5%D1%82%D0%BF%D0%BB%D0%B5%D0%B9%D1%81%D0%B0&url=https%3A%2F%2Fwww.agora.ru%2Fblog%2Fcms-dlja-marketplejsa-vse-chto-nuzhno-znat
-pered-startom%2F&l10n=ru&mime=html&sign=847937c95bf85a40ba85cdb3975df9b1&keyno=03306https://www.cs-cart.ru/blog/reyting-luchshih-
platform-dlya-onlayn-marketpleysov-v-2020-godu/www.cs-cart.ruFunctionality. It is important  that <hlword>engine</hlword> <hlword>of 
marketplace</hlword> было...20200310T1347113169utf-8What engine should I choose  for creating a marketplace in 2020? In this article, we talk 
about the most popular CMS for online marketplaces, their pros and cons.<_PassagesType>0rutext/htmlhttps://yandexwebcache.net/yandbtm?lang=ru&
fmode=inject&tm=1589898908&tld=ru&la=1589617664&text=%D0%B4%D0%B2%D0%B8%D0%B6%D0%BE%D0%BA%20%D0%BC%D0%B0%D1%80%D0%BA%D0%B5%D1%82%D0%BF%
D0%BB%D0%B5%D0%B9%D1%81%D0%B0&url=https%3A%2F%2Fwww.cs-cart.ru%2Fblog%2Freyting-luchshih-platform-dlya-onlayn-marketpleysov-v-2020-godu%2F&l10n=
ru&mime=html&sign=54c754e62ae51b1d546e23a881b1f8a0&keyno=0https://multivendor.cs-cart.ru/multivendor.cs-cart.ruThe most functional <hlword
>engine</hlword> for online-<hlword>of marketplace</hlword>: 500+...20140710T0105204321utf-8Why are marketplaces — the future 
of e-Commerce? Marketplace is an online store where many independent sellers display their products for general sale...<_PassagesType>0rutext/html
https://yandexwebcache.net/yandbtm?lang=ru&fmode=inject&tm=1589898908&tld=ru&la=1589617664&text=%D0%B4%D0%B2%D0%B8%D0%B6%D0%BE%D0%BA
%20%D0%BC%D0%B0%D1%80%D0%BA%D0%B5%D1%82%D0%BF%D0%BB%D0%B5%D0%B9%D1%81%D0%B0&url=https%3A%2F%2Fwww.cs-cart.ru%2Fblog%2Freyting-luchshih-platform-dlya-
onlayn-marketpleysov-v-2020-godu%2F&l10n=ru&mime=html&sign=54c754e62ae51b1d546e23a881b1f8a0&keyno=0https://www.cs-cart.ru/blog/kak-otkryit
-onlayn-marketpleys-s-nulya/ www.cs-cart.ruHow do I open online?-<hlword>marketplace</hlword> from scratch-Magazine about eCommerce20200513T1
735383653utf-8Online marketplace — this is an e-Commerce site where a lot of independent sellers sell goods on a shared storefront and in their 
micro-stores.<_PassagesType>0rutext/htmlhttps://yandexwebcache.net/yandbtm?lang=ru&fmode=inject&tm=1589898908&tld=ru&la=1589617664&
amp;text=%D0%B4%D0%B2%D0%B8%D0%B6%D0%BE%D0%BA%20%D0%BC%D0%B0%D1%80%D0%BA%D0%B5%D1%82%D0%BF%D0%BB%D0%B5%D0%B9%D1%81%D0%B0&url=https%3A%2F%2Fwww.cs-cart.
ru%2Fblog%2Freyting-luchshih-platform-dlya-onlayn-marketpleysov-v-2020-godu%2F&l10n=ru&mime=html&sign=54c754e62ae51b1d546e23a881b1f8a0&key
no=010175https://vc.ru/life/79466-kak-sozdat-marketpleys-tehnicheskiy-likbezvc.ru How create<hlword>marketplace</hlword>: technical... — 
Personal experience on vc.ru20190820T0300006771utf-8Мmarketplace — is a startup that will require a lot of effort and (most often) funds. And if the 
business model is not working, the sooner the entrepreneur understands it, the better.<_PassagesType>0rutext/htmlhttps://yandexwebcache.net/yandbtm?
lang=ru&fmode=inject&tm=1589898908&tld=ru&la=1589492352&text=%D0%B4%D0%B2%D0%B8%D0%B6%D0%BE%D0%BA%20%D0%BC%D0%B0%D1%80%D0%BA%D0%B5%D1%
82%D0%BF%D0%BB%D0%B5%D0%B9%D1%81%D0%B0&url=https%3A%2F%2Fvc.ru%2Flife%2F79466-kak-sozdat-marketpleys-tehnicheskiy-likbez&l10n=ru&mime=html&
sign=99c0bc0f5ba037676c539c1946045cca&keyno=0https://vc.ru/services/102294-korobochnye-vs-samopisnye-kak-rise-media-group-vybirala-cms-pod-marketpleys
vc.ruBoxed vs self-made: as Rise Media... — Services on vc.ru20200121T1447065922utf-8Partner boutiques of the marketplace are listed in the rating 
«100 best boutiques in Russia».We do not do cms reviews and do not advertise the created marketplace.<_Passages Type>0rutext/htmlhttps:
//yandexwebcache.net/yandbtm?lang=ru&fmode=inject&tm=1589898908&tld=ru&la=1589492352&text=%D0%B4%D0%B2%D0%B8%D0%B6%D0%BE%D0%BA%20%D0%B
C%D0%B0%D1%80%D0%BA%D0%B5%D1%82%D0%BF%D0%BB%D0%B5%D0%B9%D1%81%D0%B0&url=https%3A%2F%2Fvc.ru%2Flife%2F79466-kak-sozdat-marketpleys-tehnicheskiy-likbez&
amp;l10n=ru&mime=html&sign=99c0bc0f5ba037676c539c1946045cca&keyno=0https://vc.ru/services/128149-kak-my-startovali-marketpleys-v-moemskladevc.ru 
How we started <hlword>marketplace</hlword> in MyWarehouse — Services on vc.ru20200519T1324355398utf-8The marketplace will also help small 
developer companies enter the market and profit, reduce sales and marketing costs.<_Passages Type>0rutext/htmlhttps://yandexwebcache.net/yandbtm?lang
=ru&fmode=inject&tm=1589898908&tld=ru&la=1589492352&text=%D0%B4%D0%B2%D0%B8%D0%B6%D0%BE%D0%BA%20%D0%BC%D0%B0%D1%80%D0%BA%D0%B5%D1%82%D0
%BF%D0%BB%D0%B5%D0%B9%D1%81%D0%B0&url=https%3A%2F%2Fvc.ru%2Flife%2F79466-kak-sozdat-marketpleys-tehnicheskiy-likbez&l10n=ru&mime=html&sign=
99c0bc0f5ba037676c539c1946045cca&keyno=01808https://falcon.web-automation.ru/list/solutions/marketplace---2falcon.web-automation.ruReady <hlword>
engine</hlword> <hlword>marketplace</hlword>products - FALCON SPACE20190523T092141960utf-8Ready-made product marketplace engine. Quickly 
create an initial version of your product platform. See also the Detailed article about the product marketplace with pictures.<_PassagesType>0rutext/
htmlhttps://yandexwebcache.net/yandbtm?lang=ru&fmode=inject&tm=1589898908&tld=ru&la=1589634304&text=%D0%B4%D0%B2%D0%B8%D0%B6%D0%BE%D0%
BA%20%D0%BC%D0%B0%D1%80%D0%BA%D0%B5%D1%82%D0%BF%D0%BB%D0%B5%D0%B9%D1%81%D0%B0&url=https%3A%2F%2Ffalcon.web-automation.ru%2Flist%2Fsolutions%2Fmarketplace
---2&l10n=ru&mime=html&sign=1603968081d509c70200e831bf53fdc4&keyno=0https://web-automation.ru/poryadok-sozdaniya-marketplace/web-automation.
ruOrder of creation <hlword>marketplace</hlword>by steps — Web-automation.ru20170103T2248132271utf-8How to create a marketplace, aggregator, 
or marketplace. Development of the marketplace engineby stages.<_PassagesType>0rutext/htmlhttps://yandexwebcache.net/yandbtm?lang=ru&fmode=inject&
amp;tm=1589898908&tld=ru&la=1589634304&text=%D0%B4%D0%B2%D0%B8%D0%B6%D0%BE%D0%BA%20%D0%BC%D0%B0%D1%80%D0%BA%D0%B5%D1%82%D0%BF%D0%BB%D0%B5%D0%B9%D
1%81%D0%B0&url=https%3A%2F%2Ffalcon.web-automation.ru%2Flist%2Fsolutions%2Fmarketplace---2&l10n=ru&mime=html&sign=1603968081d509c70200e831bf5
3fdc4&keyno=0https://web-automation.ru/chto-takoe-marketplace-i-celi-marketplace/web-automation.ruЧто такое <hlword>marketplace</hlword> and 
what are the goals <hlword>marketplace</hlword> (aggregators)?20180303T1850301705utf-8Marketplace – a platform for interaction between a 
group of buyers and a group of sellers in a particular industry. This may be a narrow industry, such as training for...<_PassagesType>0rutext/htmlhttps:
//yandexwebcache.net/yandbtm?lang=ru&fmode=inject&tm=1589898908&tld=ru&la=1589634304&text=%D0%B4%D0%B2%D0%B8%D0%B6%D0%BE%D0%BA%20%D0%BC%D0
%B0%D1%80%D0%BA%D0%B5%D1%82%D0%BF%D0%BB%D0%B5%D0%B9%D1%81%D0%B0&url=https%BY%2F%2Ffalcon.web-automation.ru%2Flist%2Fsolutions%2Fmarketplace---2&l10n=
ru&mime=html&sign=1603968081d509c70200e831bf53fdc4&keyno=08272https://qna.habr.com/q/645331qna.habr.com Which way to go to create <hlword>
marketplace</hlword>? — Habr Q&A20190703T2256274877utf-82.Sellers pay a monthly fee for using the marketplace (if they offer more than 10 
products for sale). 3. A lot of filters to search for item.<_PassagesType>0rutext/htmlhttps://yandexwebcache.net/yandbtm?lang=ru&fmode=inject&tm
=1589898908&tld=ru&la=1589636864&text=%D0%B4%D0%B2%D0%B8%D0%B6%D0%BE%D0%BA%20%D0%BC%D0%B0%D1%80%D0%BA%D0%B5%D1%82%D0%BF%D0%BB%D0%B5%D0%B9%D1%81%D0%
B0&url=https%3A%2F%2Fqna.habr.com%2Fq%2F645331&l10n=ru&mime=html&sign=cc79c5bdb3d41f62ae5049ec45f3582b&keyno=0https://habr.com/post/478840/
habr.comHow to start the creation <hlword>marketplace</hlword>. Part two / Habr20191205T1235552818utf-8In my last article “How to start 
creating a marketplace. Part one” I wrote about the general issues of creating a marketplace. One of the points was the business model.<_PassagesType
>0rutext/htmlhttps://yandexwebcache.net/yandbtm?lang=ru&fmode=inject&tm=1589898908&tld=ru&la=1589636864&text=%D0%B4%D0%B2%D0%B8%D0%B6%D
0%BE%D0%BA%20%D0%BC%D0%B0%D1%80%D0%BA%D0%B5%D1%82%D0%BF%D0%BB%D0%B5%D0%B9%D1%81%D0%B0&url=https%3A%2F%2Fqna.habr.com%2Fq%2F645331&l10n=ru&mime=html
&sign=cc79c5bdb3d41f62ae5049ec45f3582b&keyno=0https://habr.com/post/335094/habr.comRuby on Rails for the development <hlword>marketplaceа</
hlword> / Хабр20170807T1756364305utf-8Usually, the marketplace gets recognition and status over time, so the seller does not need to further promote their 
point of sale.<_PassagesType>0rutext/htmlhttps://yandexwebcache.net/yandbtm?lang=ru&fmode=inject&tm=1589898908&tld=ru&la=1589636864&
text=%D0%B4%D0%B2%D0%B8%D0%B6%D0%BE%D0%BA%20%D0%BC%D0%B0%D1%80%D0%BA%D0%B5%D1%82%D0%BF%D0%BB%D0%B5%D0%B9%D1%81%D0%B0&url=https%3A%2F%2Fqna.habr.com%2Fq%2F
645331&l10n=ru&mime=html&sign=cc79c5bdb3d41f62ae5049ec45f3582b&keyno=0984https://www.shopolog.ru/metodichka/development/cs-cart-predstavil-
platformu-dlya-sozdaniya-marketpleysov/www.shopolog.ruOverview of the creation platform <hlword>marketplace</hlword> from... :: Shopolog.ru2018080
6T1338161673utf-8Marketplace — oteto is an online store that has a lot of independent sellers The third reason — we have received confirmation from 
opinion leaders that behind the marketplaces...<_PassagesType>0rutext/htmlhttps://yandexwebcache.net/yandbtm?lang=ru&fmode=inject&tm=1589898908&
amp;tld=ru&la=1589612288&text=%D0%B4%D0%B2%D0%B8%D0%B6%D0%BE%D0%BA%20%D0%BC%D0%B0%D1%80%D0%BA%D0%B5%D1%82%D0%BF%D0%BB%D0%B5%D0%B9%D1%81%D0%B0&url=
https%3A%2F%2Fwww.shopolog.ru%2Fmetodichka%2Fdevelopment%2Fcs-cart-predstavil-platformu-dlya-sozdaniya-marketpleysov%2F&l10n=ru&mime=html&sign=cca2
d2363e274f3ec00819d9e09c6be7&keyno=0https://www.shopolog.ru/services/section/marketplaces/www.shopolog.ruКаталог <hlword>marketplaces</hlword> 
- electronic trading systems... :: Shopolog.ru20150226T1454432342utf-8Marketplace as an effective online sales channel. Overview of the features and advantages 
of popular electronic trading platforms.<_PassagesType>0rutext/htmlhttps://yandexwebcache.net/yandbtm?lang=ru&fmode=inject&tm=1589898908&tld=
ru&la=1589612288&text=%D0%B4%D0%B2%D0%B8%D0%B6%D0%BE%D0%BA%20%D0%BC%D0%B0%D1%80%D0%BA%D0%B5%D1%82%D0%BF%D0%BB%D0%B5%D0%B9%D1%81%D0%B0&url=https%3A%
2F%2Fwww.shopolog.ru%2Fmetodichka%2Fdevelopment%2Fcs-cart-predstavil-platformu-dlya-sozdaniya-marketpleysov%2F&l10n=ru&mime=html&sign=cca2d2363e274
f3ec00819d9e09c6be7&keyno=0https://www.shopolog.ru/services/section/marketplaces/?page=2www.shopolog.ruCatalog <hlword>marketplace</hlword> - 
electronic trading systems... :: Shopolog.ru20150313T0951432404utf-8Marketplace as an effective online sales channel. Overview of the features and advantages 
of popular electronic trading platforms.<_PassagesType>0rutext/htmlhttps://yandexwebcache.net/yandbtm?lang=ru&fmode=inject&tm=1589898908&tld=
ru&la=1589612288&text=%D0%B4%D0%B2%D0%B8%D0%B6%D0%BE%D0%BA%20%D0%BC%D0%B0%D1%80%D0%BA%D0%B5%D1%82%D0%BF%D0%BB%D0%B5%D0%B9%D1%81%D0%B0&url=https%3A%
2F%2Fwww.shopolog.ru%2Fmetodichka%2Fdevelopment%2Fcs-cart-predstavil-platformu-dlya-sozdaniya-marketpleysov%2F&l10n=ru&mime=html&sign=cca2d2363e274
f3ec00819d9e09c6be7&keyno=075https://www.nulled.cc/threads/297759/www.nulled.ccCMS for <hlword>marketplace</hlword> | Nulled Warez Scripts20181
004T0300001768utf-8Good day, tell me - are there ready-made solutions for creating a marketplace? Can anyone have experience using it?<_PassagesType>0rutext
/htmlhttps://yandexwebcache.net/yandbtm?lang=ru&fmode=inject&tm=1589898908&tld=ru&la=1589466880&text=%D0%B4%D0%B2%D0%B8%D0%B6%D0%BE%D0%BA%20
%D0%BC%D0%B0%D1%80%D0%BA%D0%B5%D1%82%D0%BF%D0%BB%D0%B5%D0%B9%D1%81%D0%B0&url=https%3A%2F%2Fwww.nulled.cc%2Fthreads%2F297759%2F&l10n=ru&mime=html&
sign=2dc22d1e5eabe3abaaf5b21a233afd67&keyno=0https://www.nulled.cc/threads/304090/www.nulled.cc[Help] - CMS Multi-Vendor для <hlword>Marketplace</
hlword>20190624T2322062986utf-8The minus is that this engine stalled in 2017, it was not very popular, which means that it is more likely to be converted to 
a budget marketplace for a small city.<_PassagesType>0rutext/htmlhttps://yandexwebcache.net/yandbtm?lang=ru&fmode=inject&tm=1589898908&tld=ru&
amp;la=1589466880&text=%D0%B4%D0%B2%D0%B8%D0%B6%D0%BE%D0%BA%20%D0%BC%D0%B0%D1%80%D0%BA%D0%B5%D1%82%D0%BF%D0%BB%D0%B5%D0%B9%D1%81%D0%B0&url=https%3A%2F%2
Fwww.nulled.cc%2Fthreads%2F297759%2F&l10n=ru&mime=html&sign=2dc22d1e5eabe3abaaf5b21a233afd67&keyno=0https://www.nulled.cc/threads/297759/page-2
www.nulled.ccCMS для <hlword>маркетплейса</hlword> | Page 2 | Nulled Warez Scripts20181007T1833221549utf-8This engine did not bring a dollar of profit, 
only a headache.You will announce the budget and for what purposes it will be needed. There is for example a marketplace.<_PassagesType>0rutext/htmlhttps://
yandexwebcache.net/yandbtm?lang=ru&fmode=inject&tm=1589898908&tld=ru&la=1589466880&text=%D0%B4%D0%B2%D0%B8%D0%B6%D0%BE%D0%BA%20%D0%BC%D0%B0%D1
%80%D0%BA%D0%B5%D1%82%D0%BF%D0%BB%D0%B5%D0%B9%D1%81%D0%B0&url=https%3A%2F%2Fwww.nulled.cc%2Fthreads%2F297759%2F&l10n=ru&mime=html&sign=2dc22d1e5ea
be3abaaf5b21a233afd67&keyno=03https://www.comnews.ru/node/119494www.comnews.ruOverview of services to create <hlword>marketplaces</hlword> | ComNews
20190513T0300001577utf-8In the Wake of such popularity of marketplaces, large financial, service or trading platforms, as well as individual businessmen who are 
ready to create their own platform, are thinking about creating their own platform...<_PassagesType>0rutext/htmlhttps://yandexwebcache.net/yandbtm?lang=ru&
amp;fmode=inject&tm=1589898908&tld=ru&la=1589559552&text=%D0%B4%D0%B2%D0%B8%D0%B6%D0%BE%D0%BA%20%D0%BC%D0%B0%D1%80%D0%BA%D0%B5%D1%82%D0%BF%D0%BB%D
0%B5%D0%B9%D1%81%D0%B0&url=https%3A%2F%2Fwww.comnews.ru%2Fnode%2F119494&l10n=ru&mime=html&sign=df87ae76cd9e3001dde50277f650210f&keyno=02475https:
//zen.yandex.ru/media/id/5c420a0786e43c00ad248abe/5cdd1b2f9bca4600b3e2dcf4zen.yandex.ruOverview of services to create <hlword>marketplaces</hlword> | 
Yandex Zen Told the media about their experience in creating marketplaces, which can be useful for beginners and experienced Internet entrepreneurs.20190516T11193
61299utf-8<_PassagesType>0rutext/htmlhttps://yandexwebcache.net/yandbtm?lang=ru&fmode=inject&tm=1589898908&tld=ru&la=1589574912&text=%D0
%B4%D0%B2%D0%B8%D0%B6%D0%BE%D0%BA%20%D0%BC%D0%B0%D1%80%D0%BA%D0%B5%D1%82%D0%BF%D0%BB%D0%B5%D0%B9%D1%81%D0%B0&url=https%3A%2F%2Fzen.yandex.ru%2Fmedia%2Fid%2F5c
420a0786e43c00ad248abe%2F5cdd1b2f9bca4600b3e2dcf4&l10n=ru&mime=html&sign=e42d3b8756abd5db4c2560db5b872ae9&keyno=0https://yandex.ru/collections/card/
5db594b351aa90156e35f020/yandex.ru«CS-Cart Multi-Vendor - professional platform for...»20191030T185358380utf-8...professional platform for creating a 
marketplace (CMS for a marketplace, engine for a marketplace).marketplace (CMS for marketplace, engine for marketplace).<_PassagesType>0rutext/htmlhttps://
yandexwebcache.net/yandbtm?lang=ru&fmode=inject&tm=1589898908&tld=ru&la=1589574912&text=%D0%B4%D0%B2%D0%B8%D0%B6%D0%BE%D0%BA%20%D0%BC%D0%B0%D1%
80%D0%BA%D0%B5%D1%82%D0%BF%D0%BB%D0%B5%D0%B9%D1%81%D0%B0&url=https%3A%2F%2Fzen.yandex.ru%2Fmedia%2Fid%2F5c420a0786e43c00ad248abe%2F5cdd1b2f9bca4600b3e2dcf4&
l10n=ru&mime=html&sign=e42d3b8756abd5db4c2560db5b872ae9&keyno=0https://zen.yandex.ru/media/id/5a2426f69d5cb3b90be07ec7/5d550b2be4f39f00b190ba48zen.yandex.
ru A list of the TOP <hlword>маркетплейсов</hlword> in Russia | Adept... | Yandex Zen In Russia begins a real boom of marketplaces. Many large online 
stores are switching to this format, as well as new players are emerging.20190815T113946924utf-8<_PassagesType>0rutext/htmlhttps://yandexwebcache.net/yandbtm?
lang=ru&fmode=inject&tm=1589898908&tld=ru&la=1589574912&text=%D0%B4%D0%B2%D0%B8%D0%B6%D0%BE%D0%BA%20%D0%BC%D0%B0%D1%80%D0%BA%D0%B5%D1%82%D0%BF%D
0%BB%D0%B5%D0%B9%D1%81%D0%B0&url=https%3A%2F%2Fzen.yandex.ru%2Fmedia%2Fid%2F5c420a0786e43c00ad248abe%2F5cdd1b2f9bca4600b3e2dcf4&l10n=ru&mime=html&sign
=e42d3b8756abd5db4c2560db5b872ae9&keyno=03https://www.trendkey.ru/marketplace-s-nyliawww.trendkey.ruWhat is this <hlword>marketplace</hlword> and how 
to start it from scratch20190523T0300003689utf-8Marketplace from scratch: a checklist for launching a trading platform.Hundreds of different marketplaces are already 
operating in Russia, and e-commerce experts predict growth...<_PassagesType>0rutext/htmlhttps://yandexwebcache.net/yandbtm?lang=ru&fmode=inject&tm=1589
898908&tld=ru&la=1589552384&text=%D0%B4%D0%B2%D0%B8%D0%B6%D0%BE%D0%BA%20%D0%BC%D0%B0%D1%80%D0%BA%D0%B5%D1%82%D0%BF%D0%BB%D0%B5%D0%B9%D1%81%D0%B0&url=
https%3A%2F%2Fwww.trendkey.ru%2Fmarketplace-s-nylia&l10n=ru&mime=html&sign=7b6ad600a310fbb42fc224e451412657&keyno=0'

set @string = replace (@string, '\"' , '"')
set @string = replace (@string, 'encoding="utf-8"' , '')

DECLARE @xml XML;
SET @xml = @string
SELECT @xml;
SELECT
       Tbl.Col.value('@name', 'nvarchar(max)') name
FROM   @xml.nodes('//results/grouping/group/categ') Tbl(Col)

Additional information: 

https://yandex.ru/dev/xml/doc/dg/concepts/get-request-docpage/

https://wiki.rookee.ru/yandeks-xml/

https://semantica.in/blog/ispolzuem-yandeks-xml-na -primere-parsera-snippeta-poiskovoj-sistemy-yandeks.html

 

Note