Data extraction process of the central bank according to the date and currency type received with the mail body

Hi @ertan_ay1,

Can you try going directly to the date range instead of selecting a date on this page?
Then you can pull this table with datascraping and filter the rows you want.

I am sharing an example, use the format in this example.

https://www.tcmb.gov.tr/kurlar/[year][month]/[day][month][year].xml
https://www.tcmb.gov.tr/kurlar/202206/14062022.xml

Additionally, you can use the API. I am sharing the link so you can follow it.

https://evds2.tcmb.gov.tr/help/videos/EVDS_Web_Servis_Kullanim_Kilavuzu.pdf

Regards,
MY

2 Likes

Yes, I understand you, but I did it with the api that should be, I need to do it in a visual way anyway

If you have to do it visually, go straight to the date.

1 Like

@muhammedyuzuak yes, but what happens if the date changes in the other mail?

Hi @muhammedyuzuak ,

this is working for current month only, not working for pervious month like below mentioned

https://www.tcmb.gov.tr/kurlar/202205/03052022.xml

Thanks,
RajKumar

2 Likes

This is an example. I shared the link format by date above.

First you will list the mails.

Then you will loop this list. you will pull the date in the loop you take. and in this link you will write in the appropriate places as day, month, year.

If you have problems with these steps, please let me know.

1 Like

@RajKumarDuraiFAS @muhammedyuzuak In the process, it is necessary to select the date on the site and click on the instrument panel to view the rates, so I cannot perform data scraping.

it’s not ok to do it with xml

Hi @RajKumarDuraiFAS,

Thank you for the warning. Even if you enter this date manually, it will give a warning.

The Republic of Turkey closes the exchange rate sharing on public holidays. That’s why you can’t get results with any way (API, UI or xml etc.) from here.

Regards,
MY

Hi @ertan_ay1,

Is this project a homework or are you trying to find a solution? Because this way is more suitable and correct than the other.

If it is your homework and you are asked to do it this way, you can use dynamic click activity for each value you receive from the mail, as shared above.

Dynamically define the values ​​you have, first the year, then the month, and the last day, into the ananames.

Regards,
MY

yes i have to
–so I need to create three different variables as day month year, right?

I don’t think this is true sir

@RajKumarDuraiFAS It has to be something like I’ve prepared.

Hi @ertan_ay1 ,

tcmb-Com.zip (250.0 KB)

kindly check this workflow.

Thanks,
Raj

1 Like

@RajKumarDuraiFAS doing the same again, sir,
Thanks for be interested
but it has to be a stream like I did, not input dialog format