Skip to content

Instantly share code, notes, and snippets.

View MatthewJBloom's full-sized avatar

Matt Bloom MatthewJBloom

4 followers · 9 following
  • Formstack
  • United States
View GitHub Profile
@MatthewJBloom
MatthewJBloom / ConnectWise Support Dump
Created October 16, 2019 19:43
g CW Manage
Matthew Bloom 03:23 PM
does that sound like a mistake on the customer's end?
Matthew Bloom 03:23 PM
i would say they are on the correct version of Sell and gave you that information but not the version of CW manage
Chris Perri 03:24 PM
I see
Matthew Bloom 03:24 PM
well, how would you recommend I go about askign them their Manage version?
Matthew Bloom 03:24 PM
@MatthewJBloom
MatthewJBloom / debugCW.md
Created October 29, 2019 14:27 — forked from ZECTBynmo/debugCW.md

Created Test Company

{ id: 28166,
  identifier: 'BRDTEST1',
  name: 'BRD TEST1',
  status: 
   { id: 1,
     name: 'Active',
     _info: { status_href: 'https://api-na.myconnectwise.net/v4_6_release/apis/3.0/company/companies/statuses/1' } },
@MatthewJBloom
MatthewJBloom / NetSuite Raw POST attempt
Created October 25, 2019 15:13
{
"method": "POST",
"url": "https://3312471-sb1.restlets.api.netsuite.com/app/site/hosting/restlet.nl?script=customdeploybedrock_create&deploy=1&compid=3312471_SB1",
"headers": {
"User-Agent": "BedrockData-Connect/dev (+http://www.bedrockdata.com/bots.html)",
"Authorization": "OAuth oauth_consumer_key=\"4c56f177cbb265c6a607469c2187ff7702ac4a4b65bf34ef2154d10e141593a0\", oauth_nonce=\"vFSfWL1KeXsJnGdMmg3qhZkCMxbm5EKt\", oauth_signature=\"cVOKfs4g%2B3r5KQQLw6Ek8mk%2B9Ts%3D\", oauth_signature_method=\"HMAC-SHA1\", oauth_timestamp=\"1572016168\", oauth_token=\"1ef2535df7e5529fd086693c30a410431785a02003e996a5e4bebd47dec7ca5e\", oauth_version=\"1.0\",realm=\"3312471_SB1\"",
"content-type": "application/json"
},
"json": {
"phone": "3141111111",
@MatthewJBloom
MatthewJBloom / gist:69f1333e3d4276580b2bf72b4e04fe06
Created October 30, 2019 17:38 — forked from ZECTBynmo/gist:00cbeea0632ec12e0fb42c680e8a1413
[vagrant@brd-dev ~]$ DEBUG=* sudo coffee ./bedrock_api/app/scripts/call_connector_method_old.coffee
CALLING netsuite create WITH ARGS contact { phone: '3141111111',
firstname: 'Rezart',
title: 'Manager - Data Science',
email: 'rezart.kume@sial.com',
lastname: 'Kume' }
FINAL REQ OPTS {
"method": "POST",
"url": "https://5225069.restlets.api.netsuite.com/app/site/hosting/restlet.nl?script=customscript_bedrock_create&deploy=2&compid=5225069",
"headers": {
@MatthewJBloom
MatthewJBloom / 2vpns 1telnet
Created February 21, 2020 21:13
db3 strugs
Matthew-Bloom:bedrock_sync mbloom$ telnet db3 27017
Trying 172.17.1.117...
^C
Matthew-Bloom:bedrock_sync mbloom$ netstat -rn
Routing tables
Internet:
Destination Gateway Flags Refs Use Netif Expire
default 192.168.0.1 UGSc 117 0 en0
@MatthewJBloom
MatthewJBloom / gist:ff15eb487f74c3ea0623594b918d40ad
Created March 10, 2020 17:02
http://ts0/getInfoLogsQ?cust_id=5cc89bf63a66f988513c6010&dedupe_key=&remote_ref=zoho_rest0%2Fcontact%2F439036000064314051&object_type=contact&last_n_days=1&events=events
2020-03-10T01:12:05.585989+00:00 sync_log CACHE UPDATE zoho_rest0/contact/439036000064314051 'Demo_Completed': '2019-06-22T13:00:00-07:00'
2020-03-10T01:13:18.805670+00:00 sync_log REMOTE UPDATE zoho_rest0/contact/439036000064314051 'Demo_Completed': u'2019-06-22T13:00:00-00:00'
2020-03-10T01:31:12.227146+00:00 remote_update 'hubspot0/contact/8263451' 'properties': {u'demo_completed_date_test': u'1561075200000'}
2020-03-10T01:37:58.696840+00:00 sync_log CACHE UPDATE hubspot0/contact/8263451 {'properties': {'demo_completed_date_test': '1561075200000'}
...new Date(1561075200000)
...Thu Jun 20 2019 20:00:00 GMT-0400 (Eastern Daylight Time)
@MatthewJBloom
MatthewJBloom / gist:bc1af629e3859ce20af7442b5e549da6
Created March 11, 2020 20:54
brdi-198
2020-03-11T18:47:20.154604+00:00 sync_log CACHE UPDATE hubspot0/contact/10342401 {'profile-token': 'AO_T-mMaR0O0m2Yoz-KW4_j9qLS6IATFj70_hA84Z0WRmt0KvK3FQ2KRVHWyr77V8kE5NgFsfg62aIgjIbKiNKV-Cg3fkw_LGlnK_5R6u5reqzgDVe5xRW4A5sbogPixA9FdC_hmnsCr', 'properties': {'lastmodifieddate': '1583943145759', 'jobtitle': 'Kitchen Design Mngr. North & South America'}}
2020-03-11T18:47:20.155036+00:00 cache_update {u'rec': u'hubspot0/contact/10342401', u'changes': {u'profile-token': u'AO_T-mMaR0O0m2Yoz-KW4_j9qLS6IATFj70_hA84Z0WRmt0KvK3FQ2KRVHWyr77V8kE5NgFsfg62aIgjIbKiNKV-Cg3fkw_LGlnK_5R6u5reqzgDVe5xRW4A5sbogPixA9FdC_hmnsCr', u'properties': {u'jobtitle': u'Kitchen Design Mngr. North & South America', u'lastmodifieddate': u'1583943145759'}}}
2020-03-11T19:13:48.400855+00:00 sync_log DROP NDOC RELS hubspot0--contact--10342401 {'Opportunity'}
2020-03-11T19:16:17.466551+00:00 sync_log INDEX hubspot0/contact/10342401 as Contact kliphardt@google.com
2020-03-11T19:21:37.135559+00:00 sync_log AFFECTED hubspot0/deal/424554469 => ['hubsp
@MatthewJBloom
MatthewJBloom / getInfoLogs export
Last active March 17, 2020 16:51
http://ts0/getInfoLogsQ?cust_id=5b562e1041c469c232b0cba7&dedupe_key=&remote_ref=hubspot0%2Fcontact%2F65785401&object_type=contact&last_n_days=9&events=events
{
"_customer": "5b562e1041c469c232b0cba7",
"type": "Contact",
"data": {
"LEAD_CLOSE_DATE": "2020-02-19T02:28:03Z",
"BEDROCK_TRIGGER_SYNC": "Form Submission",
"BEDROCK_TRIGGER_SYNC_DATE": "2019-11-11",
"DESCRIPTION": "Looking to implement a Purchase order / AP system that will be compatible with MYOB",
"INTEREST": [
"Purchase to pay"
@MatthewJBloom
MatthewJBloom / Basware Workflows
Created March 17, 2020 17:01
2020-03-17T03:46:57.639677+00:00 sync_log DENORMALIZE 5e089c1a5df929ffc5cb6ed1
2020-03-17T03:46:58.048296+00:00 sync_log WORKFLOW RULE {'field': 'RECORD_STAGE', 'dataType': 'contact', 'op': 'not:selectcontains', 'agent': 'hubspot0', 'value': 'subscriber'} ['hubspot0/contact/65785401', 'dynamicscrm5/lead/36576ed2-6604-ea11-a811-000d3ab4f64c'] did not match
2020-03-17T03:46:58.054407+00:00 sync_log WORKFLOW RULE {'field': 'EMAIL', 'dataType': 'contact', 'op': 'not:contains', 'agent': 'hubspot0', 'value': 'basware.com'} ['hubspot0/contact/65785401', 'dynamicscrm5/lead/36576ed2-6604-ea11-a811-000d3ab4f64c'] did not match
2020-03-17T03:46:58.054632+00:00 sync_log EVENT workflow {'matched': False, 'recs': ['hubspot0/contact/65785401', 'dynamicscrm5/lead/36576ed2-6604-ea11-a811-000d3ab4f64c'], 'title': 'HubSpot Contacts'}
https://my.bedrockdata.com/v2/agents/hubspot0/?include=schema
"RECORD_STAGE": {
"label": "Lifecycle Stage",
"description": "The qualification of contacts to sales readiness. It can be set thro
@MatthewJBloom
MatthewJBloom / Evologic workflow not matched
Last active March 17, 2020 20:30
https://my.bedrockdata.com/v2/normaldocs/5e6fefa806d58f016e7a85df
{
"_customer": "5a1c1f5505a1ae6f77faf68d",
"type": "Contact",
"rels": {
"Company": [
"hubspot0/company/3186813753",
"autotask1/account/258"
]
},