API - API Scraping

Back


Id	d944d564-b6fa-470d-b5ab-41b341878c5e
Rulename	API - API Scraping
Description	42Crunch API protection against API scraping
Severity	High
Tactics	Reconnaissance Collection
Techniques	T1593 T1119
Required data connectors	42CrunchAPIProtection
Kind	Scheduled
Query frequency	5m
Query period	5m
Trigger threshold	0
Trigger operator	gt
Source Uri	https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/42Crunch API Protection/Analytic Rules/APIAPIScaping.yaml
Version	1.0.1
Arm template	d944d564-b6fa-470d-b5ab-41b341878c5e.json

KQL

let firstRec = apifirewall_log_1_CL
| where TimeGenerated >= ago(5m) 
| project-away Non_blocking_mode_b, Source_Port_d, Destination_Port_d, Query_s, API_ID_g, Request_Header_s, Response_Header_s, Errors_s, Type, UUID_g
| where Instance_Name_s == "Instance_7" and URI_Path_s has "/api/properties?page=" and Status_d == 200;
let rateLimitCount = (toscalar(firstRec | count));
let recCount = iff((rateLimitCount > 100), 1, 0);
firstRec | top recCount by Timestamp_t desc;

YAML

eventGroupingSettings:
  aggregationKind: SingleAlert
triggerThreshold: 0
entityMappings:
- entityType: IP
  fieldMappings:
  - identifier: Address
    columnName: Source_IP_s
- entityType: Host
  fieldMappings:
  - identifier: HostName
    columnName: Hostname_s
- entityType: Account
  fieldMappings:
  - identifier: FullName
    columnName: Instance_Name_s
requiredDataConnectors:
- dataTypes:
  - apifirewall_log_1_CL
  connectorId: 42CrunchAPIProtection
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/42Crunch API Protection/Analytic Rules/APIAPIScaping.yaml
customDetails: 
name: API - API Scraping
relevantTechniques:
- T1593
- T1119
status: Available
version: 1.0.1
queryPeriod: 5m
kind: Scheduled
id: d944d564-b6fa-470d-b5ab-41b341878c5e
query: |
  let firstRec = apifirewall_log_1_CL
  | where TimeGenerated >= ago(5m) 
  | project-away Non_blocking_mode_b, Source_Port_d, Destination_Port_d, Query_s, API_ID_g, Request_Header_s, Response_Header_s, Errors_s, Type, UUID_g
  | where Instance_Name_s == "Instance_7" and URI_Path_s has "/api/properties?page=" and Status_d == 200;
  let rateLimitCount = (toscalar(firstRec | count));
  let recCount = iff((rateLimitCount > 100), 1, 0);
  firstRec | top recCount by Timestamp_t desc;  
description: |
    '42Crunch API protection against API scraping'
queryFrequency: 5m
severity: High
triggerOperator: gt
tactics:
- Reconnaissance
- Collection

ARM