Try responses.flat | KPA EHS API

Advanced

Parameter	Description	Value
`token`	(Required) Your API Token
`pretty`	(Optional) `true` means the response json will include white space for readability. Default is `false`.
`form_id`	(Required) The id of the form.
`limit`	(Optional) The maximum number of responses to return. Max 1000. Defaults to 100. Use `page` to fetch additional responses.
`page`	(Optional) The page of responses to return. Defaults to 1. The response field `paging.last_page` tells you what the last valid page number is.
`observer_id`	(Optional) Filters responses by the user id of the observer.
`before`	(Optional) Only include responses submitted before the given date. Should be formatted as the number of milliseconds since 1970.
`after`	(Optional) Only include responses submitted after the given date. Should be formatted as the number of milliseconds since 1970.
`updated_before`	(Optional) Only include responses that have been updated before the given date. Should be formatted as the number of milliseconds since 1970.
`updated_after`	(Optional) Only include responses that have been updated after the given date. Should be formatted as the number of milliseconds since 1970.
`format`	(Optional) Choose whether the response should be in `json` or `csv` format. `json` is the default.
`columns`	(Optional) The column names that should be fetched. If no columns are provided then all columns will be returned.
`response_ids`	(Optional) The response ids that should be fetched. May not be an empty array. If this is omitted or empty then all responses are included.
`deleted`	(Optional) false (default): only returns non-deleted responses. true: only returns deleted responses.
`skip_field_id_mapping`	(Optional) CSV format only. false (default): includes field-id to field-title mapping row. true: omits field-id to field-title mapping row.
`skip_field_id_mapping_json`	(Optional) JSON format only. false (default): includes field-id to field-title mapping row. true: omits field-id to field-title mapping row.
`force_date_format`	(Optional) Forces all date formats to conform to: YYYY-MM-DD HH:mm:ss

REQUEST Open GET Request >

POST https://api.kpaehs.com/v1/responses.flat

{
  "token": "MY_TOKEN",
  "pretty": true
}

RESPONSE

"link,report,report number,date,updated,version,observer,observer-emp-num,duration,latitude,longitude,temperature,wind-speed,weather,lhbrcique8olxa02,nearmissfld-fieldoffice,nearmissfld-lob,nearmissfld-lob-followups,nearmissfld-client,nearmissfld-misscategory,nearmissfld-workingcategory-type,nearmissfld-drivingcategory-type,nearmissfld-drivingcategory-type-followups,nearmissfld-environmentalcategory-type,nearmissfld-environmentalcategory-type-followups,nearmissfld-bodypart,nearmissfld-bodypart-followups,nearmissfld-severity,nearmissfld-severity-followups,nearmissfld-recurrence,nearmissfld-actiontaken,nearmissfld-managementofhazard,nearmissfld-description,nearmissfld-attachments,nearmissfld-attachments-followups,select-working,select-driving,select-environmental,select-low,select-medium,select-high,select-critical,select-rare,select-random,select-frequent,select-accepted,select-stop work,select-communication,select-immediate change,select-gradual change,select-eliminate,select-control,select-protect,select-accept\nLink,Report,Report Number,Date,Updated,Version,Observer,Observer Emp#,Duration (Seconds),Latitude,Longitude,Temperature,Wind Speed,Weather,Employee,Office,Line of Business,Line of Business Follow-ups,Company,Category,Working Category,Driving Category,Driving Category Follow-ups,Environmental Category,Environmental Category Follow-ups,Body Part,Body Part Follow-ups,Severity,Severity Follow-ups,Recurrence,Action,Managment,Description,Photos,Photos Follow-ups,Working,Driving,Environmental,Low,Medium,High,Critical,Rare,Random,Frequent,Accepted,Stop Work,Communication,Immediate Change,Gradual Change,Eliminate,Control,Protect,Accept\nhttp://acme.kpaehs.localhost:3000/forms/responses/view/1154,Near Miss Report,1154,2019-02-12 16:55:13,2019-02-12 16:55:13,1,Derrick Brown,DBROWN,13,35.2057428,-97.4428221,42.98,5.15 mph,clear,Derrick Brown,Atlanta,Assembly,0,Emerson Finishing,Working,Awareness,,0,,0,,0,Low,0,Rare,,,Test,,0,1,0,0,1,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0\nhttp://acme.kpaehs.localhost:3000/forms/responses/view/1152,Near Miss Report,1152,2019-02-02 08:17:46,2019-02-12 15:49:20,4,Rick Pruitt,47606,99,30.317034595300182,-97.70571814667117,80,18 mph,rain,,Atlanta,Electrical,0,Emerson Finishing,Working,Awareness,Awareness/Attitude,0,Spill Release,0,,0,High,0,Accepted,,,This is a sample answer for the paragraph input 4290,,0,1,0,0,0,0,1,0,0,0,0,1,0,0,0,0,0,0,0,0\nhttp://acme.kpaehs.localhost:3000/forms/responses/view/1150,Near Miss Report,1150,2019-02-07 14:20:35,2019-02-12 15:49:20,3,Jason Clark,47552,138,29.717029279631387,-95.31940119835807,47,16 mph,rain,,Houston,Assembly,0,A&B Services,Driving,Housekeeping,Harsh Acceleration/Deceleration,0,Spill Release,0,\"Eye, Body Systems, Knee/Leg\",0,High,0,Rare,,,This is a sample answer for the paragraph input 4224,http://acme.kpaehs.localhost:3000/get-upload?key=modules%2Fcreate-customer%2Ffake-data%2Fclient%2Fresponse-attachments%2Fcracked-metal.jpg,0,0,1,0,0,0,1,0,1,0,0,0,0,0,0,0,0,0,0,0\nhttp://acme.kpaehs.localhost:3000/forms/responses/view/1148,Near Miss Report,1148,2019-02-04 13:26:05,2019-02-12 15:49:20,3,Bridget Goodman,47543,206,29.44447549280965,-98.46784193851614,69,18 mph,fog,,Atlanta,Concrete,0,Emerson Finishing,Driving,Unsafe/Defective Equipment,Awareness/Attitude,0,Improper Containment,0,\"Hand/Finger, Body Systems, Shoulder/Arm\",0,Low,0,Random,Gradual Change,,This is a sample answer for the paragraph input 4156,,0,0,1,0,1,0,0,0,0,1,0,0,0,0,0,1,0,0,0,0\nhttp://acme.kpaehs.localhost:3000/forms/responses/view/1146,Near Miss Report,1146,2019-02-07 00:39:14,2019-02-12 15:49:20,3,Dennis Wolfe,47542,54,30.31293386446263,-97.6838054151103,38,3 mph,wind,,Dallas,Concrete,0,A&B Services,Working,Bites/Stings,Lane Change,0,Improper Containment,0,\"Knee/Leg, Eye\",0,High,0,Accepted,Communication,,This is a sample answer for the paragraph input 4091,,0,1,0,0,0,0,1,0,0,0,0,1,0,1,0,0,0,0,0,0\nhttp://acme.kpaehs.localhost:3000/forms/responses/view/1144,Near Miss Report,1144,2019-02-05 09:56:29,2019-02-12 15:49:20,3,Melinda Nichols,47541,147,29.72892561517524,-95.40468730224588,37,20 mph,fog,,Houston,Concrete,0,Yates Electric,Environmental,Walking/Working Surface,Unsafe Road Conditions,0,Improper Containment,0,Foot/Toe,0,Low,0,Frequent,Gradual Change,,This is a sample answer for the paragraph input 4023,http://acme.kpaehs.localhost:3000/get-upload?key=modules%2Fcreate-customer%2Ffake-data%2Fclient%2Fresponse-attachments%2Froad-washout.jpg,0,0,0,1,1,0,0,0,0,0,1,0,0,0,0,1,0,0,0,0\nhttp://acme.kpaehs.localhost:3000/forms/responses/view/1142,Near Miss Report,1142,2019-02-07 16:57:18,2019-02-12 15:49:20,3,Margarita Chambers,47540,294,30.21261638978011,-97.75684269890837,64,13 mph,rain,,Houston,Concrete,0,Yates Electric,Environmental,Unsafe Action,Animal,0,Failure to Secure,0,\"Body Systems, Shoulder/Arm\",0,Medium,0,Rare,,Protect,This is a sample answer for the paragraph input 3954,http://acme.kpaehs.localhost:3000/get-upload?key=modules%2Fcreate-customer%2Ffake-data%2Fclient%2Fresponse-attachments%2Fcracked-metal.jpg,0,0,0,1,0,1,0,0,1,0,0,0,0,0,0,0,0,0,1,0\nhttp://acme.kpaehs.localhost:3000/forms/responses/view/1140,Near Miss Report,1140,2019-02-12 14:06:35,2019-02-12 15:49:20,4,Jamie Cole,47539,198,29.516774731199828,-98.44745675192227,27,,snow,,Dallas,Assembly,0,A&B Services,Driving,Awareness,Unsafe Speed,0,Unsafe Action,0,\"Neck/Throat, Back\",0,Critical,0,Rare,,Protect,This is a sample answer for the paragraph input\n"

Getting Started

account

acknowledgments

api

attachment

companies

completedtrainings

datalistitems

datalists

dataload

driver-qualifications

equipments

equipmenttypes

fieldoffices

followups

formfolders

forms

grouptrainings

inspections

jobtitles

linesofbusiness

resources

resourcetags

responses

roles

training-employee-status

trainings

users

Enter your JSON request object:

REQUEST Open GET Request >

RESPONSE