Exchange Rates of Georgia Bank

1C:Enterprise platform integration capabilities and techniques

#1
People who like this:0Yes/0No
Interested
Rating: 10
Joined: Sep 30, 2020
Company: Nortek Bilişim

Hello, I want to take exchange rates of Georgia Bank.But I didn't find URL.What is the XML Url of Georgia Bank?

 
#2
People who like this:0Yes/0No
Administrator
Rating: 23
Joined: Oct 3, 2019
Company:

Hello Mesut,

can you give a link to the website of the bank with which you want to make an exchange?

 
#3
People who like this:0Yes/0No
Active user
Rating: 2
Joined: Aug 28, 2015
Company:

Hello.
Here's the link. Go to this link and you will find all the rates from National Bank of Georgia.

https://www.nbg.gov.ge/rss.php

 
#4
People who like this:0Yes/0No
Interested
Rating: 10
Joined: Sep 30, 2020
Company: Nortek Bilişim

There is a function for Turkey Bank.I have changed Url with Georgia Bank.How can I set date part in the URL.

Function GetValidResult(Val CurrDate)

//   "https://www.tcmb.gov.tr/kurlar/" + str1 + "/" + str2 + ".xml"

While True Do
str1 =  Format(CurrDate ,"DF=yyyyMM");
str2 =  Format(CurrDate ,"DF=ddMMyyyy");

StrFullAddres = "https://www.nbg.gov.ge/rss.php";
XMLFile = GetFilesFromInternet.DownloadFileToTempStorage(StrFullAddres);

If XMLFile.Status Then
BinaryData = GetFromTempStorage(XMLFile.Path);
XML = GetStringFromBinaryData(BinaryData);

mXml = New XMLReader;
mXml.SetString(XML);
Result = XDTOFactory.ReadXML(mXml);
mXml.Close();
DeleteFromTempStorage(XMLFile.Path);
Return Result;
EndIf;

CurrDate = AddDay(CurrDate, -1);
EndDo;
EndFunction

 
#5
People who like this:0Yes/0No
Active user
Rating: 2
Joined: Aug 28, 2015
Company:

You can set date as a parameter:

https://www.nbg.gov.ge/rss.php?date=2020-10-30

 
#6
People who like this:0Yes/0No
Active user
Rating: 2
Joined: Aug 28, 2015
Company:

For more info you can contact their tech support. I guess they'll help you.

 
#7
People who like this:0Yes/0No
Interested
Rating: 10
Joined: Sep 30, 2020
Company: Nortek Bilişim

Okey thank you very much!

 
#8
People who like this:0Yes/0No
Interested
Rating: 10
Joined: Sep 30, 2020
Company: Nortek Bilişim

You said a link about exchanges rate of Georgia Bank.But it is not What I want.I need an address that I can send date parameters and I can take data in order to dates.

I have searched it and also send a email to Georgia Bank but, Both I didn't find it and Georgia Bank has not reply the email.Can you help me please?

 
#9
People who like this:0Yes/0No
Interested
Rating: 10
Joined: Sep 30, 2020
Company: Nortek Bilişim

Hello,

I want to take exchange rate from Georgia Bank using this XML(https://www.nbg.gov.ge/rss.php).And then I want to save its date and rates in an information register.How can I write this code?

 
#10
People who like this:0Yes/0No
Administrator
Rating: 23
Joined: Oct 3, 2019
Company:

Hi Mesut,

you need to parse this XML file - the structure of this file is very simple (please see screenshot 1).

After that you can find the currency you are interested in, for example, the Turkish lira and its rate in relation to the Georgian currency (screen 2).

Aleksandr

Download 1.png (261.08 KB)
Download 2.png (271.14 KB)
 
#11
People who like this:0Yes/0No
Interested
Rating: 10
Joined: Sep 30, 2020
Company: Nortek Bilişim

I dont know how to take rates from XML or parsing.Have you any examples or courses about this topic.

 
#12
People who like this:0Yes/0No
Administrator
Rating: 23
Joined: Oct 3, 2019
Company:

Hello Mesut,

we have posted a small example of how you can get currency rates from the website of the Bank of Georgia:

https://1c-dn.com/blog/parsing-a-site-using-1c/

If you have any questions, please ask.

 
#13
People who like this:0Yes/0No
Interested
Rating: 10
Joined: Sep 30, 2020
Company: Nortek Bilişim

Thank you very much.You must be work very hard.I am going to try to get exchange rates using this link.

 
Subscribe
Users browsing this topic (guests: 1, registered: 0, hidden: 0)
Be the first to know tips & tricks on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.