Payload Reports

gistfile1.txt

{
	"object_types": "attendee",
	  "sort_by": [
  	    {
	      "descending": false,
	      "expression": {
    			"element_id": "ATTENDEE_NAME",
    			"attribute_name": "last_name",
	    		"object_type": "response"
			}
	    },
	    {
	      "descending": false,
	      "expression": {
    			"element_id": "ATTENDEE_NAME",
    			"attribute_name": "last_name",
	    		"object_type": "response"
    		}
	    }
	],
    "fields": [
    	{
    		"header": "Confirmation #",
    		"expression": {
    			"attribute_name": "confirmation_number",
	    		"object_type": "attendee"
    		}
    	},
    	{
    		"header": "First Name",
    		"expression": {
    			"element_id": "ATTENDEE_NAME",
    			"attribute_name": "first_name",
	    		"object_type": "response"
    		}
    	},
    	{
    		"header": "Last Name",
    		"expression": {
    			"element_id": "ATTENDEE_NAME",
    			"attribute_name": "last_name",
	    		"object_type": "response"
    		}
    	},
    	{
    		"header": "Email Address",
    		"expression": {
    			"element_id": "ATTENDEE_EMAIL",
    			"attribute_name": "email_address",
	    		"object_type": "response"
    		}
    	}
    ],
    "filter": {
    	"op": "and",
	    "operands": [
	        {
	            "op": "and",
	            "operands": [
	                {
	                    "left": {
	                        "object_type": "attendee",
	                        "attribute_name": "is_canceled"
	                    },
	                    "op": "equals",
	                    "right": false
	                }
	            ]
	        },
	        {
	            "op": "or",
	            "operands": [
	                {
	                    "left": {
	                        "object_type": "attendee",
	                        "attribute_name": "status"
	                    },
	                    "op": "equals",
	                    "right": "confirmed"
	                },
	                {
	                    "left": {
	                        "object_type": "attendee",
	                        "attribute_name": "status"
	                    },
	                    "op": "equals",
	                    "right": "pending"
	                }
	            ]
	        }
	    ]
    }
}