Retrieve all spam form submit jobs for a single form

get

/api/REST/2.0/data/form/{formId}/formSpamData

Retrieves all spam form submissions for a form specified by the formId. This API endpoint is released under our Controlled Availability program. You can request access to this feature by submitting a request to My Oracle Support.

Request

Supported Media Types
Path Parameters
Query Parameters
  • Maximum number of entities to return. Must be less than or equal to 1000 and greater than or equal to 1.
  • Specifies which page of entities to return (the count parameter defines the number of entities per page). If the page parameter is not supplied, 1 will be used by default.
  • The earliest date time for which the request will retrieve data, expressed in Unix time.
Back to Top

Response

Supported Media Types

400 Response

Bad request. See Status Codes for information about other possible HTTP status codes.

401 Response

Unauthorized. See Status Codes for information about other possible HTTP status codes.

403 Response

Forbidden. See Status Codes for information about other possible HTTP status codes.

404 Response

The requested resource was not found. See Status Codes for information about other possible HTTP status codes.

500 Response

The service has encountered an error. See Status Codes for information about other possible HTTP status codes.
Back to Top

Examples

The following examples demonstrate how to retrieve spam form submissions using an HTTP request and cURL. For more information on requests, see API requests.

HTTP request examples

Retrieve all spam form submissions for the form with ID 3:


GET /api/REST/2.0/data/form/3/formSpamData
Content-Type: application/json 
			

Response:


{
  "elements": [
    {
      "type": "FormSpamData",
      "id": "1223",
      "blockReason": "invalidtoken",
      "fieldValues": [
        {
          "type": "FieldValue",
          "name": "elqFormName",
          "value": "UntitledForm-1609416910232"
        },
        {
          "type": "FieldValue",
          "name": "elqSiteId",
          "value": "12345"
        },
        {
          "type": "FieldValue",
          "name": "elqFormSubmissionToken",
          "value": "h0icHRkXyVs8CnaO8h2BHfBESgGMJeZdSLntLnqxCP3ofOLGLs5RGRyUEoOuu_rLwyRY1QpBC6gJM6tEHRg3olKXLMWixUjf52SaE.9qlRHe7PppOXrKtgDnz2Ug"
        },
        {
          "type": "FieldValue",
          "name": "elqCampaignId",
          "value": "1234"
        },
        {
          "type": "FieldValue",
          "name": "firstName",
          "value": "John"
        },
        {
          "type": "FieldValue",
          "name": "lastName",
          "value": "Smith"
        },
        {
          "type": "FieldValue",
          "name": "emailAddress",
          "value": "john.smith@oracle.com"
        },
        {
          "type": "FieldValue",
          "name": "address1",
          "value": ""
        },
        {
          "type": "FieldValue",
          "name": "LP",
          "value": "4905"
        }
      ],
      "formSubmissionSource": "post",
      "submittedAt": "1609419578"
    }
  ],
  "page": 1,
  "pageSize": 1000,
  "total": 1
}
			

Retrieve spam form submissions where the form submissions were blocked because of an authentication mismatch issue:


GET /api/REST/2.0/data/form/3/formSpamData?search=blockreason=authhashmismatch
Content-Type: application/json 
			

Response:


{
  "elements": [
    {
      "type": "FormSpamData",
      "id": "1236",
      "blockReason": "authhashmismatch",
      "fieldValues": [
        {
          "type": "FieldValue",
          "name": "firstName",
          "value": "John"
        },
        {
          "type": "FieldValue",
          "name": "lastName",
          "value": "Smith"
        },
        {
          "type": "FieldValue",
          "name": "emailAddress",
          "value": "john.smith@oracle.com"
        },
        {
          "type": "FieldValue",
          "name": "elqFormName",
          "value": "UntitledForm-1536934056562"
        },
        {
          "type": "FieldValue",
          "name": "elqSiteId",
          "value": "426809016"
        }
      ],
      "formSubmissionSource": "get",
      "submittedAt": "1610023989"
    },
    {
      "type": "FormSpamData",
      "id": "1235",
      "blockReason": "authhashmismatch",
      "fieldValues": [
        {
          "type": "FieldValue",
          "name": "firstName",
          "value": "John"
        },
        {
          "type": "FieldValue",
          "name": "lastName",
          "value": "Smith"
        },
        {
          "type": "FieldValue",
          "name": "emailAddress",
          "value": "john.smith@oracle.com"
        },
        {
          "type": "FieldValue",
          "name": "elqFormName",
          "value": "UntitledForm-1536934056562"
        },
        {
          "type": "FieldValue",
          "name": "elqSiteId",
          "value": "426809016"
        }
      ],
      "formSubmissionSource": "get",
      "submittedAt": "1610022883"
    }
  ],
  "page": 1,
  "pageSize": 1000,
  "total": 2
}
			

Retrieve all spam form submissions for the form with ID #3, since January 1st, 2021:


GET /api/REST/2.0/data/form/3/formSpamData?startAt=1609462800
Content-Type: application/json 
			

Response:


{
  "elements": [
    {
      "type": "FormSpamData",
      "id": "1236",
      "blockReason": "authhashmismatch",
      "fieldValues": [
        {
          "type": "FieldValue",
          "name": "firstName",
          "value": "John"
        },
        {
          "type": "FieldValue",
          "name": "lastName",
          "value": "Smith"
        },
        {
          "type": "FieldValue",
          "name": "emailAddress",
          "value": "john.smith@oracle.com"
        },
        {
          "type": "FieldValue",
          "name": "elqFormName",
          "value": "UntitledForm-1536934056562"
        },
        {
          "type": "FieldValue",
          "name": "elqSiteId",
          "value": "426809016"
        }
      ],
      "formSubmissionSource": "get",
      "submittedAt": "1610023989"
    },
    ...
  ],
  "page": 1,
  "pageSize": 1000,
  "total": 5
}
			

cURL example

Here is the first example in cURL given an instance with the name APITest, username API.User, and pod of 3.


curl --user "APITest\API.User" --request GET https://secure.p03.eloqua.com/api/REST/2.0/data/form/3/formSpamData
			
Back to Top