NickDeckerDevs

function upload_table($table_id, $csv_file_name) {
    $accessToken = $_SESSION['accessToken'];
    // /hubdb/api/v1/tables/:tableId/import
    $url = "https://api.hubapi.com/hubdb/api/v1/tables/$table_id/import";
	  $postBody = [
        "file" => "@$csv_file_name;type=text/csv",
        "config" => [
            "resetTable" => true,
            "skipRows" => 1,
            "format" => 'csv',

NickDeckerDevs

/* 
 * table_id - This is the ID of the table/database we are updating
 * $csv_file_name - This is the full path of the CSV file ($csv_file_name = __DIR__.'/import/2017-05-01-FL.csv')
 */

function upload_table($table_id, $csv_file_name) {
    $accessToken = $_SESSION['accessToken'];
    $url = "https://api.hubapi.com/hubdb/api/v1/tables/$table_id/import";
    $csv_file = new CURLFile($csv_file_name,'text/csv');
    $config_json = '{"resetTable":true,"skipRows":1,"format":"csv","columnMappings":[{"source":1,"target":1},{"source":2,"target":2},{"source":3,"target":3},{"source":4,"target":4},{"source":5,"target":5},{"source":6,"target":6},{"source":7,"target":7},{"source":8,"target":8},{"source":9,"target":9},{"source":10,"target":10},{"source":11,"target":11},{"source":12,"target":12},{"source":13,"target":13}]};type=application/json';

NickDeckerDevs

<?php

function getRegionsArray() {
    $regionsArray = [];
    $regionsData = getClinicData('select DISTINCT STATE_ID, REGION_1, REGION_2, REGION_3, STATE from dbo.CLINICS_DATA WHERE INCLUDEINSEARCH = 1 ORDER BY STATE_ID');
    foreach($regionsData as $location) {
        // d($location);
        $state = $location['STATE_ID'];
        if(!array_key_exists($state, $regionsArray)) {
            $regionsArray[$state] = [];

NickDeckerDevs

<?php
/**
 * Template Name: Locations
 */
// $_GET = filter_input_array(INPUT_GET, FILTER_SANITIZE_STRING);
$locationQuery = 'All Clinics';
$locationsArray = [];
$clinic = false;
$searchValue = isset($_GET['location']) ? $_GET['location'] : '';
if(isset($_GET['location'])) {

NickDeckerDevs

<?php // ==== FUNCTIONS ==== //

require_once( trailingslashit( get_stylesheet_directory() ) . 'Kint.class.php' );
// Load the configuration file for this installation; all options are set here
if ( is_readable( trailingslashit( get_stylesheet_directory() ) . 'functions-config.php' ) )
  require_once( trailingslashit( get_stylesheet_directory() ) . 'functions-config.php' );

// Load configuration defaults for this theme; anything not set in the custom configuration (above) will be set here
require_once( trailingslashit( get_stylesheet_directory() ) . 'functions-config-defaults.php' );

NickDeckerDevs

(function(e){var t=!1,i=!1,n={isUrl:function(e){var t=RegExp("^(https?:\\/\\/)?((([a-z\\d]([a-z\\d-]*[a-z\\d])*)\\.)+[a-z]{2,}|((\\d{1,3}\\.){3}\\d{1,3}))(\\:\\d+)?(\\/[-a-z\\d%_.~+]*)*(\\?[;&a-z\\d%_.~+=-]*)?(\\#[-a-z\\d_]*)?$","i");return t.test(e)?!0:!1},loadContent:function(e,t){e.html(t)},addPrefix:function(e){var t=e.attr("id"),i=e.attr("class");"string"==typeof t&&""!==t&&e.attr("id",t.replace(/([A-Za-z0-9_.\-]+)/g,"sidr-id-$1")),"string"==typeof i&&""!==i&&"sidr-inner"!==i&&e.attr("class",i.replace(/([A-Za-z0-9_.\-]+)/g,"sidr-class-$1")),e.removeAttr("style")},execute:function(n,s,a){"function"==typeof s?(a=s,s="sidr"):s||(s="sidr");var r,d,l,c=e("#"+s),u=e(c.data("body")),f=e("html"),p=c.outerWidth(!0),g=c.data("speed"),h=c.data("side"),m=c.data("displace"),v=c.data("onOpen"),y=c.data("onClose"),x="sidr"===s?"sidr-open":"sidr-open "+s+"-open";if("open"===n||"toggle"===n&&!c.is(":visible")){if(c.is(":visible")||t)return;if(i!==!1)return o.close(i,function(){o.open(s)}),void 0;t=!0,"left"===h?(r={left:

NickDeckerDevs

<form>
    <p>You can type a name into the field below and it will change your browser path upon clicking Change URL button. I have defaulted with a value in the input to make testing quicker.</p>
    <label>New URL: </label>
    <input type="text" id="name" value="Nicholas Decker">
    <input type="button" id="change-url" value="Change URL">
</form>

<script>
    $(document).ready(function() {
        $('#change-url').on('click', function() {

NickDeckerDevs

{% image "social_image" label='Select an image for the social preview', src='http://cdn2.hubspot.net/hub/428357/file-2117441560-jpg/img/dev-bg-compressed.jpg', export_to_template_context=True %}     

<meta property="og:image" content="{{ widget_data.social_image.src }}">
<meta name="twitter:image" content="{{ widget_data.social_image.src }}">

NickDeckerDevs

<script>
  jQuery(window).load(function() {
    var checkbox = jQuery('.mktoFormRow').eq(3).html();
    jQuery('.mktoButtonRow').before(checkbox)
    jQuery('.mktoFormRow').eq(3).remove();
  });
</script>

NickDeckerDevs

/* 
 * this is a quick and dirty way of grabbing content from a website page and 
 * putting it into hubspot. The best way would be to (php) curl into each page, 
 * parse the web page using a regular expression for the 
 *               /<article(*.?)<\/article>/
 * add them into your php object, then looping through that php object and 
 * using the hubspot API to create and update the pages
 *
 * Ideally you could just loop through the XLS file (or csv if you prefer)
 * That way you could have some of the other data in the XLS file. But you