Skip to content

Instantly share code, notes, and snippets.

🌋
We're hiring!

Paul Cothenet pcothenet

🌋
We're hiring!
Block or report user

Report or block pcothenet

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View keybase.md

Keybase proof

I hereby claim:

  • I am pcothenet on github.
  • I am pcothenet (https://keybase.io/pcothenet) on keybase.
  • I have a public key ASCT1VpLS_NyxrEKtbvA23DkoWiy9OsobxQNF73zlyM3igo

To claim this, I am signing this object:

View hubspot token
const params = {
clientId: hubspot_app.clientId,
clientSecret: hubspot_app.clientSecret,
redirectUri: `${hubspot_app.redirectUri}?state=${tenant}`,
refreshToken: refresh_token
}
const hubspot = new Hubspot(params)
if (refresh_token) {
return hubspot.refreshAccessToken()
@pcothenet
pcothenet / coverage.md
Last active Jan 14, 2017
madkudu.js tests
View coverage.md
File % Stmts % Branch % Funcs % Lines Uncovered Lines
lib/ 71.52 50.94 60.36 73.89
cookie.js 94.87 90 100 94.59 80,115
entity.js 100 92.5 100 100
form.js 23.57 6.06 2.86 24.44 ... 271,277,278
group.js 100 100 100 100
index.js 69.23 66.67 100 75 38,39,40
madkudu.js 87.3 65.88 96.43 93.57 ... 251,417,418
memory.js 100 100 100 100
View segment_button.js
! function t(e, n, r) {
function i(t) {
if (n[t]) return n[t].exports;
if (e[t]) return o(t, i);
throw new Error('cannot find module "' + t + '"')
}
function o(i, o) {
var u = n[i] = {
exports: {}
View group_unload.md
UNLOAD ("SELECT contact_key, account_key, account_attribute_1, account_attribute_1 FROM [your_table]")
TO 's3://madkudu-data-in-[your_org_id]/group/group.csv'
CREDENTIALS 'aws_access_key_id=[your_access_key];aws_secret_access_key=[your_secret_key]'
DELIMITER '~'
ADDQUOTES
ESCAPE
MANIFEST
GZIP
ALLOWOVERWRITE
View track_unload.md
UNLOAD ("SELECT event_text, event_timestamp, contact_key, event_attribute_1, event_attribute_2 FROM [your_table]")
TO 's3://madkudu-data-in-[your_org_id]/track/track.csv'
CREDENTIALS 'aws_access_key_id=[your_access_key];aws_secret_access_key=[your_secret_key]'
DELIMITER '~'
ADDQUOTES
ESCAPE
MANIFEST
GZIP
ALLOWOVERWRITE
View identify_unload.md
UNLOAD ("SELECT contact_key, email, attribute_1, attribute_2 FROM [your_table]")
TO 's3://madkudu-data-in-[your_org_id]/identify/identify.csv'
CREDENTIALS 'aws_access_key_id=[your_access_key];aws_secret_access_key=[your_secret_key]'
DELIMITER '~'
ADDQUOTES
ESCAPE
MANIFEST
GZIP
ALLOWOVERWRITE
@pcothenet
pcothenet / s3_put_object_identify.md
Last active Oct 20, 2015
s3 put-object identify
View s3_put_object_identify.md
aws s3api put-object --bucket madkudu-data-in-XXXX --key identify/contact_file_name.csv --body ./Documents/contacts.csv
@pcothenet
pcothenet / s3_put_object.md
Last active Oct 20, 2015
s3api put-object
View s3_put_object.md
aws s3api put-object --bucket madkudu-data-in-XXXX --key destination_file_name.csv --body ./Documents/file_to_upload.csv
View account_firmographics.md
SELECT 
  c.contact_id,
  c.email,
  af.*
FROM 
  contacts AS c
INNER JOIN 
  contacts_to_accounts AS c2a
ON c.contact_id = c2a.contact_id
You can’t perform that action at this time.