Home » SQL & PL/SQL » SQL & PL/SQL » REST API with DDOS protection (ORACLE 12c)
REST API with DDOS protection [message #666633] Fri, 17 November 2017 17:57 Go to next message
mmation
Messages: 2
Registered: November 2017
Junior Member
Hi,

I used to call an API, but now the website add a Cloudflare DDOS protection.

Now, when I call the API, the result is the DDOS protection instead the API result.

API: https: //bittrex.com/api/v1.1/public/getmarketsummaries

my call:
select UTL_HTTP.REQUEST( 'bittrex.com/api/v1.1/public/getmarketsummaries') from dual;

expected:
{"success":true,"message":"","result":[{"Mar.......

With the DDOS protection the API result is the DDOS protection page:
"Checking your browser before accessing bittrex.com."

Can anyone help me to solve this problem?

Regards, Murilo
Re: REST API with DDOS protection [message #666634 is a reply to message #666633] Fri, 17 November 2017 21:04 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
mmation wrote on Fri, 17 November 2017 15:57
Hi,

I used to call an API, but now the website add a Cloudflare DDOS protection.

Now, when I call the API, the result is the DDOS protection instead the API result.

API: https: //bittrex.com/api/v1.1/public/getmarketsummaries

my call:
select UTL_HTTP.REQUEST( 'bittrex.com/api/v1.1/public/getmarketsummaries') from dual;

expected:
{"success":true,"message":"","result":[{"Mar.......

With the DDOS protection the API result is the DDOS protection page:
"Checking your browser before accessing bittrex.com."

Can anyone help me to solve this problem?

Regards, Murilo
>https://bittrex.com/api/v1.1/public/getmarketsummaries
above uses https but below use only HTTP://
>select UTL_HTTP.REQUEST( 'bittrex.com/api/v1.1/public/getmarketsummaries') from dual;
They are NOT the same!
IMO, root cause & fix are external to Oracle & Oracle is the victim; not the culprit.

Re: REST API with DDOS protection [message #666639 is a reply to message #666634] Sat, 18 November 2017 09:47 Go to previous messageGo to next message
mmation
Messages: 2
Registered: November 2017
Junior Member
Hi,

the result is the same.

The result is the DDOS page protection.

I created an ACL too:
BEGIN
--DBMS_NETWORK_ACL_ADMIN.DROP_ACL(acl => 'network_services.xml');
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(acl => 'network_services.xml',description => 'FTP ACL',principal => 'MURILO',is_grant => true,privilege => 'connect');
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl => 'network_services.xml',principal => 'MURILO',is_grant => true,privilege => 'resolve');
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(acl => 'network_services.xml',host => 'bittrex.com');
END;

Regards,
Re: REST API with DDOS protection [message #686901 is a reply to message #666639] Mon, 30 January 2023 07:26 Go to previous message
rxelgin
Messages: 1
Registered: January 2023
Junior Member
Did you ever find a solution to this problem?
Previous Topic: Two Column Join
Next Topic: Get customer with GREATEST amount of purchases
Goto Forum:
  


Current Time: Thu Mar 28 19:19:08 CDT 2024