Anyone working with quotes from Deutsche Börse & CME?
lazarus / 21-General

----------------------------------------------------------------------
Nicole · 2025-04-14 07:35

Here is something which sounds too good to be true (a bad sign, I
know):
https://console.developer.deutsche-boerse.com/

A free API for getting quotes from half Europe and the CME. In other
words, the most important quotes of the world, for free. The quotes
can be addressed by a language,  similar to SQL.

The only disadvantage: It does not work for me.

Yes, I have an API-key but am not sure, how to put it into the url.

What I usually work with is this below (the response is not json here)
The url of the documenation how I read it does not even give a
positive response, if I key it into the browser. I am clueless.

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i // Input:
url mit Datenanbieter und korrektem Anforderungslink, Ooutput: json-
Stringfunction TAktienkurse_holen.GetUrlJsonResponse(Url: string):
string;var  HttpClient: TFPHTTPClient;  Json_Response: string; 
Json_Obj: TJSONObject; begin  HttpClient :=
TFPHTTPClient.Create(nil);     // Sende die Anfrage und erhalte die
Antwort als String    Json_Response := HttpClient.Get(Url);     //
Prüfen, ob die Antwort im JSON-Format vorliegt    Json_Obj :=
TJSONObject(GetJSON(Json_Response));     // Wenn das Parsen
erfolgreich war, gebe die Antwort im JSON-Format zurück    Result :=
Json_Obj.FormatJSON;      HttpClient.Free;  // Stelle sicher, dass das
Objekt freigegeben wird end;

----------------------------------------------------------------------
dseligo · 2025-04-14 09:31

Quote from: Nicole on April 14, 2025, 09:35:44 amYes, I have an API-
key but am not sure, how to put it into the url.

It says (here: https://docs.developer.deutsche-
boerse.com/docs/consumer/getting-started/consume) that:
To call an API, pass the API key as an HTTP header named: X-DBP-APIKEY

So, try following:

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i ...const
APIKey = 'xxxxxxxxxxx';...  HttpClient := TFPHTTPClient.Create(nil); 
HttpClient.AddHeader('X-DBP-APIKEY', APIKey);
You might also want to add couple of try..finally and try..except.

----------------------------------------------------------------------
Nicole · 2025-04-14 10:03

Thank you for your quick reply. This looks great.
Please more slowly for somebody who has no idea of the matter.

What is a
"HttpClient.AddHeader"?

I know, how html is written, with head and body.
I know a little bit, how json works (in the meanwhile).
I know, what a url looks alike and a "&" etc. and there is a response
in my browser.
Of APIs I have very little idea.

This "header" I cannot insert in the grid of my small knowledge.

----------------------------------------------------------------------
dseligo · 2025-04-14 10:14

This is not the header of HTML document, this is the header of HTTP
request.

https://en.wikipedia.org/wiki/List_of_HTTP_header_fields