tickets

Creates, updates, deletes, gets or lists a tickets resource.

Overview

Name	tickets
Type	Resource
Id	godaddy.abuse.tickets

Fields

The following fields are returned by SELECT queries:

get_ticket_info

Name	Datatype	Description
closed	boolean	Is this abuse ticket closed?
closedAt	string (iso-datetime)	The date the abuse ticket was closed
createdAt	string (iso-datetime)	The date the abuse ticket was created
domainIp	string	The domain or IP the suspected abuse was reported against
reporter	string	The shopper id of the person who reported the suspected abuse
source	string	The single URL or IP the suspected abuse was reported against
target	string	The company the suspected abuse is targeting
ticketId	string	Abuse ticket ID
type	string	The type of abuse being reported

get_tickets

Name	Datatype	Description

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get_ticket_info	select	ticket_id		Return the abuse ticket data for a given ticket id
get_tickets	select		type, closed, sourceDomainOrIp, target, createdStart, createdEnd, limit, offset	List all abuse tickets ids that match user provided filters
create_ticket	insert			Create a new abuse ticket
_get_tickets	exec		type, closed, sourceDomainOrIp, target, createdStart, createdEnd, limit, offset	List all abuse tickets ids that match user provided filters

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
ticket_id	string	A unique abuse ticket identifier
closed	boolean	Is this abuse ticket closed?
createdEnd	string (iso-datetime)	The latest abuse ticket creation date to pull abuse tickets for
createdStart	string (iso-datetime)	The earliest abuse ticket creation date to pull abuse tickets for
limit	integer (integer-positive)	Number of abuse ticket numbers to return.
offset	integer (integer-positive)	The earliest result set record number to pull abuse tickets for
sourceDomainOrIp	string (host-name-or-ip-address)	The domain name or ip address abuse originated from
target	string	The brand/company the abuse is targeting. ie: brand name/bank name
type	string	The type of abuse.

SELECT examples

get_ticket_info

Return the abuse ticket data for a given ticket id

SELECT
closed,
closedAt,
createdAt,
domainIp,
reporter,
source,
target,
ticketId,
type
FROM godaddy.abuse.tickets
WHERE ticket_id = '{{ ticket_id }}' -- required
;

get_tickets

List all abuse tickets ids that match user provided filters

SELECT
*
FROM godaddy.abuse.tickets
WHERE type = '{{ type }}'
AND closed = '{{ closed }}'
AND sourceDomainOrIp = '{{ sourceDomainOrIp }}'
AND target = '{{ target }}'
AND createdStart = '{{ createdStart }}'
AND createdEnd = '{{ createdEnd }}'
AND limit = '{{ limit }}'
AND offset = '{{ offset }}'
;

INSERT examples

create_ticket

Create a new abuse ticket

INSERT INTO godaddy.abuse.tickets (
data__info,
data__infoUrl,
data__intentional,
data__proxy,
data__source,
data__target,
data__type
)
SELECT 
'{{ info }}',
'{{ infoUrl }}',
{{ intentional }},
'{{ proxy }}',
'{{ source }}',
'{{ target }}',
'{{ type }}'
;

Manifest

# Description fields are for documentation purposes
- name: tickets
  props:
    - name: info
      value: string
      description: |
        Additional information that may assist the abuse investigator. ie: server logs or email headers/body for SPAM
    - name: infoUrl
      value: string
      description: |
        Reporter URL if housing additional information that may assist the abuse investigator
    - name: intentional
      value: boolean
      description: |
        Do you believe this is intentional abuse by the domain holder?
      default: false
    - name: proxy
      value: string
      description: |
        The Proxy information required to view the abuse being reported. ie: Specific IP used, or country of IP viewing from
    - name: source
      value: string
      description: |
        The URL or IP where live abuse content is located at. ie: https://www.example.com/bad_stuff/bad.php
    - name: target
      value: string
      description: |
        The brand/company the abuse is targeting. ie: brand name/bank name
    - name: type
      value: string
      description: |
        The type of abuse being reported.
      valid_values: ['A_RECORD', 'CHILD_ABUSE', 'CONTENT', 'FRAUD_WIRE', 'IP_BLOCK', 'MALWARE', 'NETWORK_ABUSE', 'PHISHING', 'SPAM']

Lifecycle Methods

_get_tickets

List all abuse tickets ids that match user provided filters

EXEC godaddy.abuse.tickets._get_tickets 
@type='{{ type }}', 
@closed={{ closed }}, 
@sourceDomainOrIp='{{ sourceDomainOrIp }}', 
@target='{{ target }}', 
@createdStart='{{ createdStart }}', 
@createdEnd='{{ createdEnd }}', 
@limit='{{ limit }}', 
@offset='{{ offset }}'
;