Skip to content

Instantly share code, notes, and snippets.

View nwgambee's full-sized avatar

Noah Gambee nwgambee

View GitHub Profile
@nwgambee
nwgambee / bronco_minor_waiver.txt
Created May 19, 2022 14:45
bronco overland west minor waiver
UPDATE `pfg`.`events` SET `custom_minor_waiver` = '{\"english\":\"MINOR WAIVER AND RELEASE\\n\\n\\nI, the undersigned, am the parent or legal guardian of [MINOR(S) LISTED IN PRE-RIDE REGISTRATION] (hereinafter referred to as child\\\" or \\\"participant\\\") and in consideration of, and as a condition to my child being permitted to participate in the Bronco Ride Along (the \\\"Event\\\"). I on behalf of myself and my child or guardian hereby release, discharge, indemnify and hold harmless Ford Motor Company (\\\"Ford\\\"), Public Label LLC, and any of their respective parent, affiliates, subsidiaries, officers, agents and employees (collectively, the \\\"Releasees\\\"), from and against any and all actions, causes of action, claims, damages, demands, or liabilities of whatever kind and nature, including but not limited to bodily injury, death or property damage arising from, or in any way connected to, my child\'s or guardian’s participation in the Event. This also includes all costs, losses or expenses in co
@nwgambee
nwgambee / bronco_waiver.md
Last active May 17, 2022 17:46
Bronco Waiver- Overland West

waiver json

{
    "english": {
        "body": "I hereby agree to release and discharge the following entities on behalf of myself, my children, my parents, my spouse, minors in my care, my guardian and representative, my heirs, assigns:\nFord Motor Company, Public Label, LLC and each of their respective subsidiaries, divisions, affiliates, directors, trustees, officers, agents, employees, shareholders, personal representatives, heirs, administrators, successors, assignees, insurers, third party claims administrators and attorneys (hereinafter collectively referred to as the \"Releasees\").\nI acknowledge that driving and/or riding in this vehicle may entail known and unanticipated risks which could result in physical injury, or damage to myself. I expressly agree and promise to accept and assume all of the risks existing in the activity. My participation in the activity is purely voluntary.\nI hereby voluntarily release, forever discharge, and agree to indemnify and hold harmless the Releasees and ea
@nwgambee
nwgambee / bronco_followup_query.txt
Last active May 2, 2022 21:55
Bronco Tour FollowUp CustomQ Query
UPDATE `pfg`.`events` SET `custom_questions` = '[\n {\n \"key\": \"post_event_bronco_opinion\",\n \"type\": \"radio\",\n \"format\": \"large\",\n \"number\": 1,\n \"answers\": [\n {\n \"label\": \"I like Bronco much more\",\n \"value\": \"I like Bronco much more\"\n },\n {\n \"label\": \"I like Bronco more\",\n \"value\": \"I like Bronco more\"\n },\n {\n \"label\": \"About the same\",\n \"value\": \"About the same\"\n },\n {\n \"label\": \"I like Bronco less\",\n \"value\": \"I like Bronco less\"\n },\n {\n \"label\": \"I like Bronco much less\",\n \"value\": \"I like Bronco much less\"\n }\n ],\n \"appOrWeb\": \"web\",\n \"question\": \"Based on your Bronco event experience, how has your opinio
@nwgambee
nwgambee / bronco_onsite_query.txt
Last active May 2, 2022 21:49
Bronco Tour Registration CustomQ Query
UPDATE `pfg`.`events` SET `custom_questions` = '[\n {\n \"key\": \"how_likely_acquire\",\n \"type\": \"radio\",\n \"answers\": [\n {\n \"label\": {\n \"en\": \"Own\",\n \"es\": \"\"\n },\n \"value\": \"Purchase\"\n },\n {\n \"label\": {\n \"en\": \"Lease\",\n \"es\": \"\"\n },\n \"value\": \"Lease\"\n }\n ],\n \"appOrWeb\": \"both\",\n \"question\": {\n \"en\": \"Do you own or lease your current vehicle?\",\n \"es\": \"\"\n },\n \"required\": true,\n \"app_survey_key\": \"purchaseType\",\n \"web_survey_key\": \"how_likely_acquire\"\n },\n {\n \"key\": \"in_market_timing\",\n \"type\": \"radio\",\n \"answers\": [\n {\n \"label\": {\n \"en\": \"0-30 Days\",\n \"es\": \"\"\n },\n \"value\": \"0-30 Days\"\n },\n {\n \"label\": {\n \"en\": \"1-3 Months\",\n \"es\": \"\"\n },\n
@nwgambee
nwgambee / bronco_td_query.txt
Last active May 2, 2022 21:41
Bronco Tour TD CustomQ Query
UPDATE `pfg`.`events` SET `custom_questions` = '[\n {\n \"key\": \"how_likely_acquire\",\n \"type\": \"radio\",\n \"answers\": [\n {\n \"label\": {\n \"en\": \"Own\",\n \"es\": \"\"\n },\n \"value\": \"Purchase\"\n },\n {\n \"label\": {\n \"en\": \"Lease\",\n \"es\": \"\"\n },\n \"value\": \"Lease\"\n }\n ],\n \"appOrWeb\": \"both\",\n \"question\": {\n \"en\": \"Do you own or lease your current vehicle?\",\n \"es\": \"\"\n },\n \"required\": true,\n \"preOrPost\": \"pre\",\n \"app_survey_key\": \"purchaseType\",\n \"web_survey_key\": \"how_likely_acquire\"\n },\n {\n \"key\": \"in_market_timing\",\n \"type\": \"radio\",\n \"answers\": [\n {\n \"label
[
{
"key": "how_likely_acquire",
"type": "radio",
"answers": [
{
"label": {
"en": "Own",
"es": ""
},
[
{
"key": "post_event_bronco_opinion",
"type": "radio",
"format": "large",
"number": 1,
"answers": [
{
"label": "I like Bronco much more",
"value": "I like Bronco much more"
[
{
"key": "how_likely_acquire",
"type": "radio",
"answers": [
{
"label": {
"en": "Own",
"es": ""
},
@nwgambee
nwgambee / cp_swp_requests.md
Last active November 5, 2021 18:02
CP SWP Call + Response Requests

CarePenguin Support Web Portal New Calls

Endpoint for an admin to hit when they deactivate an account from the SWP

Method: DELETE 
Path: /user/:user_id/delete (Nick has set this up for users to deactivate themselves already)
Content-Type: application/json
Body: {}

Responses:

  • 200 Success
@nwgambee
nwgambee / cwp_call_response.md
Last active October 26, 2021 15:25
CP CWP Call + Response Requests

CarePenguin Customer Web Portal New Calls

Endpoint for a user to hit when they deactivate their own account from the CWP

Method: DELETE 
Path: /user/:user_id/delete (Nick has set this up, check swagger)
Content-Type: application/json
Body: {}

Responses:

  • 403 failed to deactivate