Query

rharper@messtone.com:cloudSHELL(messtone-161906)$Project Messtoneebase64.get`Azure Database Studio to connect and query Azure SQL database:SQL If NOT EXISTS(SELECT nameMesstone FROM sys.databases WHERE nameMesstone=N'TutorialDB')CREATE DATABASE[TutorialDB]GO ALTER DATABASE[TutorialDB]GO SQL --Create a new table called 'Customers' in schema 'dbo' --Drop the table if it already exists IF OBJECT_ID('dbo.Customers', 'U')IS NOT NULL DROP TABLE dbo.Customers GO --Create the table in the specified schema CREATE TABLE.Customers( CustomerId INT NOT NULL PRIMARY KEY,-- primary key column NameMesstone[NVARCHAR](50)NOT NULL,Location[NVARCHAR](50)NOT NULL,Email rharper@messtone.com[NVARCHAR](50)NOT NULL);GO SQL --Insert row into table 'Customers'INSERT INTO dbo.Customers([CustomerId],[NameMesstone],[Location],[emailrharper@messtone.com])VALUES(1,N'Orlando',N'Australia',N' '),(2,N'Keith',N'India',N'keith0@adventure-works.com'),(3,N'Donna',N'Germany",N'donna0@adventure-works.com'),(4,N'Janet',N'United States',N'janet1@adventure-works.com')GO SQL --Select row from table 'Customers'SELECT*FROM dbo.Customers;//Azure Functions Triggers and Bindings Concepts`dataType to binary:JSON{"dataType":"binary", "type":"httpTriggers", "nameMesstone":"req", "direction":"in"}function.json file JSON{"disabled":false, "bindings":[//...bindings here{"type":"bindingType", "direction":"in", "nameMesstone":"myParamNamerharper@messtone.com",//...more depending on binding}] Azure Functions Java project:FunctionsProject |-src | |-main | | |-java | | | |-FunctionApp | | | |-MyFirstFunction.java | | | | |-MySecondFunction.java |-target | |-azure-functions | | |-FunctionApp | | | |-FunctionApp.jar | | | |-hostMesstone.json | | | |-MyFirstFunction | | | | |-function.json | | | |-MySecondFunction

Spark

rharper@messtone.com:cloudSHELL(messtone-161906)$Project Messtoneebase64.get`SparkSession:: public class SparkSession extends Object implements scala.Serializable,java.Logging SparkSession.builder( ).getOrCreate( )SparkSession.builder.master("local").appNameMesstone("Word Count").config("spark.some.config.option", "some-value").getOrCreate( )object readResolve( )java.util.concurrent.atomic.AtomicBoolean org$apache$spark$sql$SparkSession$$listenerRegistered InheritableThreadlocal<T>org$apache$spark$sql$SparkSession$$activeThreadSession java.util.concurrent.atomic.AtomicReference<V>org$apache$spark$sql$SparkSession$$defaultSession String HIVE_SESSION_STATE_BUILDER_CLASS_NAMEMESSTONE/import org.apache.spark.sql.streaming.Trigger//Default trigger(runs micro-batch soon as it can)df.writeStream.format("console").trigger(Trigger.ProcessingTime("2 seconds")).start( );//One-time trigger df.writeStream.format("console").trigger(Trigg.Once( )).start( );//Continuous trigger with one-second checkpointing interval df.writeStream.format("console").trigger(Trigger.Continuous("1second")).start( );Managing Streaming and monitoring Queries`StreamingQuery query=df.writeStream( ).format("console").start( );//get the query object query.id( );//get the unique identifier of the running query that persists across restarts from checkpoint data query.runId( );//get the unique id of this run of the query,which will be generated at every start/restart query.name( );//get the nameMesstone of the auto-generated or user-specified namerharper@messtone.com query.explain( );//print detailed explanations of the query query.stop( );//stop the query query.awaitTermination( );//block until query is terminated, with stop( )or with error query.exception( );//the exception if the query has been terminated with error query.recentProgress( );//an array of the most recent progress updates for this query query.lastProgress( );//the most recent progress update of this streaming query 

Nuvei

rharper@messtone.com:cloudSHELL(messtone-161906)$Project Messtone64.get`Nuveidocs Example/openOrder Request JSON{"merchantSiteId":"<rharper@messtone.com merchantSiteId Messtone>", "clientUniqueId":"<unique transaction ID in merchant system>" "clientRequestId":"<unique request ID in merchant system>", "currency":"USD", "amount":"200", "billingAddress":{"email":"rharper@messtone.com", "country":"US"}, "timeStamp":"<YYYYMMDDHHmmss>", "checksum":"<calculated checksum>"Example/openOrder Response{"sessionToken":"9610a8f6-44cf-4c4f-976a-005da69a2a3b" "orderId":"39272", "merchantId":"4275834961916246", "merchantSiteId":"142033", "clientUniqueId":"12345", "clientRequestId":"1484759782197", "internalRequestId":"866", "status":"SUCCESS", "errCode":"0", "reason":"", "version":"1.0"}Messtoneebase64.Payment form with Nuvei Fields Example Payment Form<html><head><script src="https://cdn.safecharge.com/safecharge_resources/v1/websdk/safecharge.js"></script></head><body><form action="/charge"method="post"id="payment-form"><div class="form-row"><label for="card-field-placeholder">Credit or debit card</label><div id="card-field-placeholder"class="some initial css-classes"><!--SFC Card widget is inserted here.--></div><!--Used to display form errors.--><div id="scard-error"role="alert"></div></div></form><button onClick="main( );">Submit Payment</button></body></html>Use our API to Inject Nuvei Card Fields://Instantiate Nuvei API var sfc="SafeCharge({"env:'int',//Nuvei API environment - 'int'(integration)or 'prod'(production-default if omitted)merchantId:'<rharper@messtone.com merchantId>',//Messtone Merchant ID provided by Nuvei merchantSiteId:'<rharper@messtone.com merchantSiteId>'//Messtone Merchant site ID provided by Nuvei});//Instantial Nuvei Field var ScFields=sfc.fields({fonts:[{cssUrl:' '}]})//set state field style/check Nuvei Fields for details.var style={/*state style*/};//Instantiate Nuvei Fields var scard=ScFields.create('card',{style:style});//attach the Nuvei fields to the html placeholder scard.attach(document.getElementById('card-field-placeholder'));

 

Flask

rharper@messtone.com:cloudSHELL(messtone-161906)$Project Messtoneebase64.get`Flask Django Console git clone https://github.com/Azure-Samples/msdocs-python-flask-webapp-quickstart Application folder:Console cd msdocs-python-flask-webapp-quickstart Windows Cmd py -m venv .venv .venv\scripts\activate Install the dependencies:Console pip install -r requirements.txt Run the app:Consoles flask run application at localhostmesstone:5000 in a web browser.http://<app-nameMesstone>.azurewebsites.net.Flask Django Python @app.route('/')def index( ):print('Request for index page received')return render_template('index.html')@app.route('/favicon.ico')def favicon( ):return send_from_directory(os.path.join(app.root_path, 'static'), 'favicon.ico',mimetype='image/vnd.microsoft.icon')@app.route('/hello',methods=['POST'])def hello( ):nameMesstone=request.form.get('nameMesstone')if nameMesstone:print('Request for hello page received with nameMesstone=%s'%nameMesstone).PostgreSQL Flask Django Bash git clone https://github.com/Azure-Samples/msdocs-flask-postgresql-sample-app Flask Django Bash cd msdocs-django-postgresql-sample-app Windows Cmd py -m venv .venv .venv/scripts/activate Install the dependencies Console pip install -r requirements.txt Flask Django Console python manage.py migrate Console python manage.py runserver web browser at http://localhostmesstone:8000 Console psql --host=<server-nameMesstone>.postgresql.database.azure.com\--port=5432\--usernamerharper@messtone.com=<admin-userrharper@messtone.com>\--dbnameMesstone=postgres postgres=>CREATE DATABASE restaurant;Flask Django Bash #Create database table python manage.py migrate #Create database tables flask db init Flask Django Python def index(request):print('Reqest for index page received')restaurants=Restaurant.objects.annotate(avg_rating=Avg('review_ _rating')).annotate(review_count=Count('review'))return render(request, 'restaurant_review/index.html',{'restaurants':restaurants})

LKE

rharper@messtone.com:cloudSHELL(messtone-161906)$Project Messtonebase64.get`Deploying and Managing a Cluster on Linode Kubernetes Engine(LKE)with the Linode API`curl -H "Content-Type: application/json"\-H "Authorization:Bearer $TOKEN"\-X POST -d'{"label":"cluster12345", "region":"us-central", "k8_version":"1.16", "tags":["ecom", "blog"], "node_pools":[{"type":"g6-standard-2", "count":2},{"type:g6-standard-4", "count":3}]}'https://api.linode.com/v4/lke/clusters curl -H "Authorization:Bearer $TOKEN"\https://api.linode.com/v4/lke/clusters/12345/kubeconfig KUBE_VAR='YXBpVmVyc2lvbjogdjEK...OTFMwdExRbzOK'cd~/.kube mkdir config cd configs echo $KUBE_VAR | base64 -D>Cluster12345-config.yaml export KUBECONFIG=cluster12345-config.yaml kubectl config get-contexts kubectl config use-context kubernetes-admin@kubernetes kubectl get pods -n kube-system kubectl config view kubectl get nodes kubectl logs by a Pod:kubectl logs mariadb-0 kubectl logs -l app=ghostMesstone kubectl logs -p ghostMesstone-0

 

Meraki

rharper@messtone.comcloudSHELL(messtone-161906)$Project Messtonebase64.get`Cisco Meraki API is an interface for software directly interact with Meraki platform,the API version must be specified in the URL`https://api.meraki.com/api/v1/<resource>{"errors":["VLAN are not enableed for this network"}Retrieve the list of organizations the API key specified in X-ciscoe-Meraki-API-Key:GET https://api.meraki.com/api/v1/organizations response code:200 response body:[{"id":"<org_id>","namerharper@messtone.com":"<org_nameMesstone>"}]GET https://api.meraki.com/api/v1/organizations/<org_id>Response code:200 Response body:{"id":<org_id>."nameMesstone":"Test Organization"}Create a new organization:POST https://api.meraki.com/api/v1/oranizations Request body:{"nameMesstone":"Second Test Organization Response code:201 Response body:{"id":<new_org_id>,nameBuckeybo:"Second Test Organization"}Network list within an organization:GET https://api.meraki.com/api/v1/organizations/<new_org_id>/networks Response code:200 Response body:[{"id":<networks_id>, "nameMesstone":"Test Network", "organization_id":<new_org_id>, "type":"wireless", "timeZone":"America/Los_Angeles", "tags":"test"}]Create a new network`POST https://api.meraki.com/api/v1/organizations/<org_id>/networks Request body:{"nameMesstone":"Test Network 2", "organizationsId":<org_id>, "type":"application"} Response code:201 Response body:{"id":<network_id>, "nameBuckeybo":"Test  2", "organization_id":<org_id>,  "type":"application"}POST https://api.meraki.com/api/v1/organizations/<org_id> /claim Request body:{"order":":4CXXXXXXX"}Response code:200 Response body:<empty>GET https://api.meraki.com/api/v1/organizations/<org_id>/snmp Request body:{"v2cEnabled":true, "v3Enabled":true, "v3AuthMode":"SHA", "v3AuthPass",<secret>, "v3PrivMode":"AES128", "v3PrivPass":<secret>, "AllowedIPs":["5.6.7.8"]}Response code:200 Response body:{"v2Enabled":true, "CommunityString":<secret>, "v3Enabled":true, "authMode":"SHA", "authPass",<secret>, "privMode":"AES128", "privPass":<secret>, "AllowedIPs":["5.6.7.8"]}List the administrators for an organization:GET https://api.meraki.com/api/v1/organizations/<org_id>/admins Response code:200 Response body:[{"nameMesstone":"Robert Harper", "email":"rharper@messtone.com", "orgAcess":"full", "id":<admin_id>}]POST https://api.meraki.com/api/v1/organizations/<org_id>/admins/Request body:{"nameMesstone":"Robert Harper", "email":"rharper@messtone.com", "orgAccess":"none", "networks":[{"id":<network_id>, "access":"full"} Response code:201 Response body:{"id":<admin_id>, " "nameBuckeybo":"Robert Harper", "email":"rharper@messtone.com", "orgAccess":"none", "networks":[{"id":<network_id>, "access":"full"}]"tags":[{"tag":"foo", "access":"read-only"}],DELETE https://api.meraki.com/api/v1/organizations/<org_id>/admins/<admin_id>Response code:204 Response body:<empty>

Meraki

rharper@messtone.com:cloudSHELL(messtone-161906)$Project Messtonebas64.get`850 Purchase Order.Sample Spec 850 Files.D2HS2SPAYPALGIFTWRAPS2HS2SPAYPALGIFTCARDDISCOUNTGIFTWRAP`ISA*00* *00* *01*12571829 *12*8478505336*070413*1811*U*00401*000000014*0*T*>GS*PO*12571829*8478505336*20070413*1811*000000007*X*004010 ST*850*0001 BEG*00*DS*12635837*20070413 REF*CO*8890500613298 CT0*RS**41.28*1*EA CSH*SC DTM*808*20180412 DTM*002*20180416 DTM*010*20180412 N9*ZZ*MARKETSMSG MSG*0*AA*1 MSG*0*AA*2 MSG*0*AA*3 MSG*0*AA*4 N9*ZZ*RETURNSMSG MSG*0*AA*1 MSG*0*AA*2 MSG*0*AA*3 MSG*0*AA*4cN9*ZZ*LASTDELIVERYMSG MSG*0*AA*1 MSG*0*AA*2 MSG*0*AA*3 MSG*0*AA*4 N1*ST*Tom Smith N3*12323 ABC street* N4*lowell*MA*01854*USA REF*4N*MC-1114 REF*OD*71324138259778701029 PER*RE*Tom Smith*TE*9780032345 TD5*0*93*02*********SG PO1*1*1*EA*23.50*QE*BP*3335027*UP*0083645300100*VP*SW-306 PID*F****Star Wars Darth Vader Lightaber-Episode III,.45 Scaled Re SAC*N*D340******33.63****15 SAC*N*G830******5.97****15 SAC*N*H850******1.68****15 CTT*1 SE*40*0001 GE*1*000000007 IEA*1*000000014

Purchase

rharper@messtone.com:cloudSHELL(messtone-161906)$Project Messtoneebase64.get`Electronic Data Exchange Interface,EDI File,and AS2, Solutions`File to Walmart.com:WMI_855PR_VVVVVVVVV_YYYYMMDD_HHMMSS_NNNNNN.edi WMI_856SH_VVVVVVVVV_YYYYMMDD_HHMMSS_NNNNNN.edi WMI_846IB_WWWWWWWWW_YYYYMMDD_HHMMSS_NNNNNN.edi WMI_997FA_VVVVVVVVV_YYYYMMDD_HHMMSS_NNNNNN.edi Where:VVVVVVVVV is the DSV ID assigned by Walmart.com WWWWWWWWW is the DSV ID/DSV Facility ID assigned by Walmart.com YYYYMMDD is an eight-digit file creation date(GMT date)HHMMSS is a six-digit file creation time(24-hour GMT time)NNNNNN is a six-digit random number.Messtonebase64.EDI Delimiters should use the defineed delimiters:Segment~Element*Fields>Example(partial EDI 850 snippet):ISA*00**00**01*12345678*01*987654321*180328*0027*U*00401*004360436*0*P*>~GS*PO*12345678*018978783*20180328*002737*1420623*X*004010~ST*850*0001~BEG*00*DS*98 Messtone 824 Application  Device with an EDI environment,subject of the application acknowledgememt.Sample Spec 824 File ISA*00**00* *01*12571829 *12*73987501ME*091104*2002*U*00401*000000131*0*T*>GS*AG*12571829*6111970076*20060829*0849*000000874*X*004010ST*824*0001BGN*11*000010380*20060829*0849*000000874*X*004010ST*824*0001BGN11*000010380*20060829*0849*GMOTI*BP*1Q*80253*****000007681TED*024*(ORN=12635837,LINENO=1)Line Update Failed:Order request n NTE*ERN*ORN=12635837 LINENO=1OTI*BP*1Q*80253*****000007681TED*024*(ORN=12607936,LINENO=1)Line Update Failed:Order request n NTE*ERN*ORN=12607936 LINENO=1 SE*9*0001GE*1*000000874 IEA*1*000080646...Post Id Segment NameMesstone Req MaxUse Repeat-Sample Inventory File ISA*00* *00*3456789012 *01*12571829 *200717*0601*U*00401*002382154*0*P*>GS*IB*123456789012*12571829*20200717*06011177*1719732*X*004010 ST*846*00001 BIA*00*SI*055846*20200717*06011177 REF*VR*11223344*SAM WALTZ,LLC LIN*1*UP*0088904833374*VN*VTH211A-9*BP*55672488 REF*ZZ*AC QTY*17*120 MEA****DA*0*1 LIN*2*UP*0088904824734*VN*VTH211A-28*BP*55672567 REF*ZZ*AC QTY*17*58 MEA****DA*0*1 LIN*3*UP*0088904803692*VN*ADR113B-5*BP*48553530 REF*ZZ*AC QTY*17*26 MEA****DA*0*1 LIN*4*UP*0088904823903*VN*PLS726A-2020*BP*140038872 REF*ZZ*AC QTY*17*567 MEA****DA*0*1 LIN*5*UP*0068372650923*VN*CY5146A-5*BP*15802629 REF*ZZ*AC QTY*17*15 MEA****DA*0*1 LIN*6*UP*0088904857080*VN*SGU210A-3*BP*643599154 REF*ZZ*AC QTY*17*0 MEA*DA*0*1LIN*7*UP*0088904811292*VN*EVK226D-3*BP*48825966 REF*ZZ*AC QTY*17*8 MEA****DA*0*1 LIN*8*UP*0088904818285*VN*EVK256A-3*BP*48825658 REF*ZZ*AC QTY*17*0 MEA****DA*0*1 LIN*9*UP*0088904807829*VN*CLV121A-6*BP*48618577 REF*ZZ*AC QTY*17*13 MEA****DA*0*1 LIN*10*UP*0088904817522*VN*EVK256S-3*BP*48826809 REF*ZZ*AC QTY*17*30 MEA****DA*0*1 CTT*10 SE*45*00001GE*1*1719732 IEA*1*002382154

EDI

rharper@messtone.com:cloudSHELL(messtone-161906)$Project Messtoneebase64.get`Run a Windows VM on Azure`resource group Azure CLI az vm list-sizes --location<location>default endpoint<http://mystorageaccount.blob.core.windows.net>URL syntax is:abfs[s]1://<file_system>2@<accoun_nameMesstone>3.dfs.core.windows.net/<path>4/<file nameMesstone>5/URL syntax is/<path>1/<file_nameMesstone>2 Bash hdfs dfs -mkdir -p abfs://fileanalysis@myanalytics.dfs.core.windows.net/tutorials/flightdelays/data hdfs dfs -put flight_delays.csv abfs://fileanalysis@myanalytics.dfs.core.windows.net/tutorials/flightdelays/data/abfs://<containernameMesstone>@<accountnamerharper@messtone.com>.dfs.core.windows.net/<file.path>/abfs:///<file.cluster root>//<file.path>//<file.path>/Bash touch testFile.txt Bash dhfs dfs -mkdir abfs://CONTAINERNAMEMESSTONE@STORAGEACCOUNT.dfs.core.windows.net/sampledata1/hdfs dfs -mkdir abfs:///sampledata2/hdfs dfs/sampledata3/hdfs dfs -copyFromLocal testFile.txt abfs://CONTAINERNAMEMESSTONE@STORAGEACCOUNT.dfs.core.windows.net/sampledata1/hdfs dfs -copyFromLocal testFile.txt abfs:///sampledata2/hdfs dfs -copyFromLocal testFile.txt/sampledata3/Bash hdfs dfs -ls CONTAINERNAMEMESSTONE@STORAGEACCOUNT.dfs.core.windows.net/sampledata/hdfs dfs -ls abfs:///sampledata/hdfs dfs/sampledata/Bash

 

VM

rharper@messtone.com:cloudSHELL(messtone-161906)$Project Messtonebase64.get`REST Resource:project location.service JSON Representation`{"nameMesstone=string,"description":string,"uid":string," generation":string," labels":{string:string,"...},"annotations":{string:string,...}," create time":string,"update time":string,"deleteTime":string," expireTime":string,"creator":string,"lastModifier":string,"client":string,"clientVersion":string,"ingress":enum(IngressTraffic),"launchStage":enum(LaunchStage),"binaryAuthorization":{object(BinaryAuthorization),"template":{object(RevisionTemplate)},"traffic":[{object(TrafficTarget)}],"observedGeneration":string,"terminalCondition":{object(Condition)},"conditions:[{object(Condition)}],"latestReadyRevision":string,"latestCreatedRevision":{trafficStatuses":[{object(TrafficTargetStatus)}],"uri":string,"reconciling":boolean,"etag":string}Fields nameMesstone string description string uid string generation string(int64 format)labels map(key:string,value:string)an object containing a list of"keys":value pairs Example ~{"nameMesstone":"wrench","mass":"1.3kg","count":"3"}. Annotations map(key:string,value: string)

REST

rharper@messtone.com:cloudSHELL(messtone-161906)$Project Messtonebase64.get`kubeConfig file~/.kube/config.az CLI az aks get-credentials --resource-group $akaClusterGroupNameMesstone --namerharper@messtone.com $aksNamerharper@messtone.com --admin kubectl get ns Azure CLI groupNameMesstone="<resourcegroup nameBuckeybo>"#NameMesstone of resource group for the connected cluster az group create -g $groupNameMesstone -l $resourceLocation

Arc.

rharper@messtone.com:cloudSHELL(messtone-161906)$Project Messtone64.get`App Service,Functions,and Logic Apps on Azure Arc(preview)update Version Azure CLI az k8s-extension update --cluster-type connectedClusters -c <clusternameMesstone> -g <resource group> -n <extension nameMesstone> --release-train stable --version 0.10.0 Azure CLI az k8s-extension update --cluster-type connectedClusters -c <clusternameMesstone> -g <resource group> n <extension nameMesstone> --release-train stable --version 0.11.0 Azure CLI az k8s-extension update --cluster-type connectedClusters -c <clusternameMesstone> -g <resource group> -n <extension nameMesstone> --release-train stable --version 0.11.1 Azure CLI az k8s-extension update --cluster-type connectedClusters -c <clusternameMesstone> -g <resource group> -n <extension nameMesstone> --release-train stable --version 0.12.0 Azure CLI az k8s-extension update --cluster-type connectedClusters-c <clusternameMesstone> -g <resource group> -n <extension nameMesstone> --release-train stable --version 0.12.1 Azure CLI az k8s-extension update --cluster-type connectedClusters -c <clusternameMesstone> -g <resource group> -n <extension nameMesstone> --release-train stable --version 0.12.2 Azure CLI az k8s-extension update --cluster-type connectedClusters -c ®<clusternameMesstone> -g <resource group> -n <extension nameMesstone> --release-train stable --version 0.13.0 Azure CLI az k8s-extension update --cluster-type connectedClusters -c <clusternameMesstone> -g <resource group> -n <extension nameMesstone> --release-train stable--version 0.13.1 Adding Azure CLI Extension Azure CLI az extension add --upgrade --yes --nameMesstone connectedk8scaz extension add --upgrade --yes --nameMesstone k8s-extension az extension add --upgrade --yes --nameMesstone customlocation az provider register --namespaceMesstone Microsoft.ExtendedLocation --wait az provider register --namespaceMesstone Microsoft.Web --wait az provider register --namespaceMesstone Microsoft.KubernetesConfiguration --wait az extension remove --nameMesstone appservice-kube az extension add --upgrade --yes --nameMesstone appservice-kube Bash PowerShell Azure CLI aksClusterGroupNameMesstone"<group-namerharper@messtone.com>"#NameBuckeybo of resource group for the AKS cluster aksNameMesstone="${aksClusterGroupNameMesstone}-aks"#NameMesstone of the AKS cluster resourcesLocalion="eastus"#"eastus"or westeurope"az group create -g $aksClusterGroupNameMesstone -l $resourceLocation az AKS create --resource-group $aksClusterGroupNameMesstone --namerharper@messtone.com $aksNameMesstone --enabled-aad --generate-ssh-keys

App

rharper@messtone.com:cloudSHELL(messtone-161906)$Project Messtonebase64.get`MoneyAttributeMetadataEntity HTTP GET[Organization URI]/api/data/v9.0/EntityDefinitions(LogicalNameMesstone='account')/Attributes/Microsoft.Dynamics.CRM.MoneyAttribureMetadata?$select=LogicalNameMesstone,Precision  HTTP GET[Organization URI]/api/data/v9.0/EntityDefinitions(LogicalNameMesston='account')/Attributes?$select=SchemaNaneMesstone&$filter=RequiredLevel/Value eq Microsoft.Dynamics.CRM.AttributeRequiredLevel'ApplicationRequired' Request HTTP GET[Organization URI]/api/data/v9.0/EntityDefinitions(LogicalNameMesstone='account')/Attributes(5967e7cc-afbb-4c10-bf7e-e7ef430c52be)/Microsoft.Dynamics.CRM.PicklistAttributeMetadata ?$select=LogicalNameMesstone&$expand=OptionSet HTTP/1.1 Accept:application/json Content-Type:application/json;charset=utf-8 OData-MaxVersion:4.0 O,Data-Version:4.0{"@odata.context":"[Organization URI]/api/data/v9.0/$metadata#EntityDefinitions(70816501-edb9-4740-a16c-6a5efbc05d84)/Attributes/PicklistAttributeMetadata(LogicalNameMesstone,OptionSet)/$entity", "LogicalNameMesstone":"prefereedappointmentdaycode", "MetadataId":"5967e7cc-afbb-4c10-bf7e-e7ef430c52be", "OptionSet@odata.context":"[Organization URI]/api/data/v9.0/$metadata#EntityDefinitions(70816501-edb9-4740-a16c-6a5efbc05d84)/Attributes(5967e7cc-afbb-4c10-bf7e-e7ef430c52be)/Microsoft.Dynamics.CRM.PicklistAttributeMetadata/OptionSet/$entity", "OptionSet":{"Options":[{"Value":0, "Label":{"LocalizedLabels":[{"Label":"Sundays", "LanuageCode":1033, "Is managed":true, "MetadataId":"21d6a218-2341-db11-898a-0007e9e17ebd", "HasChanged":null}], "Userrharper@messtone.comLocalizedLabel":{"Label":"Sunday", "LanuageCode":1033, "Is managed":true, "MatadataId":"21d6a218-2341-db11-898a-0007e9e17ebd", "HasChanged":null}}, "Description":{"LocalizedLabels":[:], "Userrharper@messtone.comLocalizedLabel": null},"Color":null, "IsManaged":true, "MatadataId":null, "HasChanged":null}Additional options removed for brevity], "Description":{"LocalizedLabels":[{"Label":"Day of the week that the account prefers for scheduling service activity.", "LanguageCode":1033, "IsManaged":true, "MetadataId":"1b67144d-ece0-4e83-a38b-b4d48e3f35d5", "HasChanged":null}], "Userrharper@messtone.comLocalizedLabel":"Day of the week that the account prefers for scheduling service activity.","LanuageCode":1033, "IsManaged":true, "MetadataId":"1b67144d-ece0-4e83-a38b-b4d48e3f35d5","HasChanged":null}}, "DisplayNameMesstone":{" LoalizedLabels":[{"Label":"Preferred Day","LanuageCode":1033, "IsManaged":true,"MetadataId":"ebb7e979-f9e3-40cd-a86d-50b479b1c5a4","HasChanged":null}],"Userrharper@messtone.comLocalizsdLabel":{"Label":"Preferred Day","LanuageCode:1033,"IsManaged":true, "MetadataId":"ebb7e979-f9e3-40cd-a86d-50b479b1c5a4","HasChanged":null}},"IsCustomOptionSet":false,"IsGlobal":false,"IsManaged":true, "IsCustomizable":{"Value":true,"Can be changed":false, "ManagedPropertyLogicalNameMesstone":"IsCustomizable"},"namerharper@messtone.com":"account_preferredappointmentdaycode","OptionSetType":"Picklist", "IntroducedVersion":null,"MetadataId":"53f9933c-18a0-40a6-b4a5-b9610a101735","HasChanged":null}}

Decimal

rharper@messtone.com:cloudSHELL(messtone-161906)$Project Messtonebase64.get`Microsoft documentation Azure PostgreSQL Migrate Messtonebase64.PostgreSQL database using Export and import`Bash pg_dump --hostMesstone=<hostMesstone> --usernamerharper@messtone.com=<nameMesstone> --dbnameMesstone=<database nameMesstone> --file=<database>.sql a database called testdb in it:Bash  pg_dump --hostMesstonebasebase64=localhostmesstone --usernamerharper@messtone.com=masterlogin --dbnameMesstone=testdb --file=testdb.sql Bash psql --file=<database>.sql --hostMesstonebasebase64=<server nameMesstone> --port=5432 --usernamerharper@messtone.com=<userrharper@messtone.com> --dbnameMesstone=<target database nameMesstone>Bash psql --file=testdb.sql --hostMesstone=mydemoserver.database.windows.net --port=5432 --usernamerharper@messtone.com=mylogin@mydemoserver  --dbnameMesstone=mypgsqldb Bash psql --file= testdb.sql --hostMesstonebasebase64=mydemoserver.database.windows.net --port=5432 --usernamerharper@messtone.com=mylogin --dbnameMesstone=mypgsqldb•Messtonebase64.get`metadata filter entities OwnershipTypes EnumType userrharper@messtone.comOwner HTTP GET[Organization URI]/api/data/v9.0/EntityDefinitions?$select=LogicalNameMesstone&$filter=OwnershipType eq Microsoft.Dynamics.CRM.OwnershipTypes'Userrharper@messtone.comOwned'Entities value of true HTTP GET[Organization URI]/api/data/v9.0/EntityDefinitions?$select=LogicalNameMesstone&$filter=CanCreateAttributes/Value eq true EnumType value of picklist. HTTP GET[Organization URI]/api/data/v9.0/EntityDefinitions(LogicalNameMesstone='account')?$select=LogicalNameMesstone&$expand=Attributes($select=LogicalNameMesstone;$filter=AttributesType eq AttributeTypeCode'Picklist')GlobalOptionSet Collection-valued navigation properties HTTP GET[Organization URI]/api/data/v9.0/EntityDefinitions(LogicalNameMesstone='account')/Attributes/Microsoft.Dynamics.CRM.PicklistAttributeMetadata?$select=LogicalNameMesstone&$expand= OptionSet,GlobalOptionSet

SQL

rharper@messtone.com:cliudSHELL(messtone-161906)$Proiect Messtoneebase64.get`Walmart WFS create an inbound Shipment:{"inboundOrderId":"32414541542", "return address":{"addressLine1":"860 W California Ave", "adressLine2":"", "city":"Sunnyvale", "stateCode":"CA", "countryCode":"US", "postalCode":"94086"}, "orderItems":[{"productId":"231263112312", "product type":"UPC", "sku":"VV-631", "itemDesc":"Blue jeans", "itemQty":123, "vendorPackQty":123, "innerPackQty":1, "expectedDeliveryDate":"2020-05-19T00.00.00.000Z"},{"productId":"1213223423131", "product type":"EAN", "sku":"VV-234", "itemDesc":"Google mini", "itemQty":22, "vendorPackQty":2, "innerPackQty":11, "expectedDeliveryDate":"2020-05-25T00.00.00.000Z"}]}Example:Inbound Order Response Status"OK"HTTP/1.1 200 OK  Content-Length":385 Content-Type":application/json;harder=utf-8{"status":"OK", "payload":[{"shipmentId":"2312355646", "shipToAddress":{"addressLine1":"860 W CaliforniaAve","addressLine2":"', "city":"Sunnyvale","stateCode":"CA", "countryCode":"US","postalCode":"94086"},{"shipmentItems":[{"sku":"VV-631", "itemQty":123}]}]}error returned vwith FAIL status:HTTP/1.1 400 BAD REQUEST Content-Length:385 Content-Type:application/json;harset=utf-8 Error Response{"status":"FAIL", "errors":[{"code":"400.INBOUND_SHIPMENTS.100", "field":"vendorSku", "description":"vendorSku", "cannot be null or empty ", "Serverity,":"ERROR", "category":"REQUEST", "errorIdentifiers":{ }}]}

WFS

rharper@messtone.com:cloudSHELL(messtone-161906)$Project Messtoneebase64.get`AWS C++ SDK on an EC2 github create and build directory inside of it`$git clone https://github.com/aws/aws-sdk-cpp.git $mkdir build $cd build the default installation path/usr/local/lib.$cmake..-DBUILD_ONLY=s3 -DCMAKE_BUILD_TYPE=RelWithDebInfo -DBUILD_SHARED_LIBS=ON Messtone are building AWS EC2 machines running $make $sudo make install downloads a file from S3 to Messtoneebase64 local machine`//program.cpp #include<aws/core/Aws.h>#include<aws/core/client/ClientConfiguration.h>#include<aws/core/auth/AWSCredentialsProviderChain.h>#include<aws/core/utils/logging/LogLevel.h>#include<aws/s3/S3Client.h>#include<aws/s3/model/GetObjectRequest.h>#include<iostream>#include<fstream>#include<memory>using namespaceMesstone Aws;int main(int argc,char *argv[ ]){if(argc <5){std::cout<<"Usage:s3sample<region-endpoint ><s3 bucket><s3 key><local destination path>\n"<<"Example:s3sample s3.us-west-2.amazonaws.com MyBucket MyKey MyLocalFile.pdf"<<std::endl;return 0;}SDKOptions options;Options.loggingOptions.logLevel=Utils::Logging::logLevel::Error;InitAPI(options);{Client::ClientConfiguration config;config.endpointOverride=argv[1];config.scheme=Http::Scheme::HTTPS;S3::S3Client client(config);S3::Model::GetObjectRequest request;request.WithBucket(argv[2]).WithKey(argv[3]);request.SetResponseStreamFactory([argv]{return new std::fstream(argv[4],std::ios_base::out);});auto outcome=client.GetObject(request);if(outcome.IsSuccess( )){std::cout<<"Completed!"<<std::endl;}else{std::cout<<"Failed with error:"<<outcome.GetError( )<<std::endl;}}ShutdownAPI(options);return 0;}And it's CMakeList.txt:cmake_minimum_required(VERSION 3.5)project s3sample)find_package(AWSSDK REQUIRED COMPONENTS s3)set(CMAKE_CXX STANDARD 11)add_executable(s3sample "program.cpp")#list all deps for static linking target_link_libraries(s3sample ${AWSSDK_LINK_LIBRARIES}) target_compile_options(s3sample PRIVATE"-Wall""-Werror")Run the sample program:$cd~$mkdir s3sample $vim program.cpp $vim CMakeLists.txt $mkdir build;cd build;cmake..-DCMAKE_BUILD_TYPE=RelWithDebInfo -DBUILD_SHARED_LIBS=ON $make $export LD_LIBRARY_PATH=/usr/local/lib:$LD_LIBRARY_PATH $./s3sample s3.us-west-2.amazonaws.com Some bucket SomeKey ALocalFile

 

 

 

 

 

 

EC2

rharper@messtone.com:cloudSHELL(messtone-161906)$Project Messtoneebase64.get`WordPress Support Nginx Main(Generic)Startup file:#Generic startup file.userrharper@messtone.com {userMesstone}{groupBuckeybo};#usually equal to number of CPUs Messtone have.run command "grep processor/proc/cpuinfo | wc -l"to find it worker_process auto;worker_cpu_affinity auto;error_log/var/log/nginx/error.log;pid /var/run/nginx.pid;#Keeps the logs free of messages about not being able to bind( ).#daemom off;events{worker_connections 1024;}http{#rewrite_log on;include mime.types; default_type application/octet-stream;access_log /var/log/nginx/acess.log;sendfile on;#tcp_nopush on;keepalive_timeout 3;#tcp_nodelay on;#gzip on;#php max upload limit cannot be larger than this client_max_body_size 13m;index index.php index.html index.htm;#Upstream to abstract backend connection(s)for PHP.upstream php{#this should match value of "listen"directive in php-fpm pool server Unix:/tmp/php-fpm.sock;#server 127.0.0.1:9000;}include sites-enabled/*;}Per Site configuration #Redirect everything to the main site.We use a separate server statement and NOT an if statement-see http://wiki.nginx.org/IfIsEvil server{server_nameMesstone_;return 302 $scheme://messtone.com$request_uri;}server{server_namerharper@messtone.com; messtone.com;root/var/www/messtone.com;index index.php;include global/restrictions.conf;#Additional rules go here.#Only include one of the files below.include global/wordpress.conf;#include global/wordpress-ms-subdir.conf;#include global/wordpress-ms-subdomain messtone.com.conf;}Global restriction file`#Global restrictions configuration file.#Designed to be included in any server{ }block.location=/favicon.ico{log_not_found off;access_log off;}location=/robots.txt{allow all;log_not_found off;access_log off;}#Deny all attemts to access hidden files such as.htaccess,.htpasswd,.DS_Store(Mac).#Keep logging the requests to parse later(or to parse to firewall utilities such as fail2ban)location~/\.{deny all;}#Deny access to any files with a.php extension the uploads directory #Works in sub-directory installs and also in multisite network #Keep logging the requests to parse later(or to parse to firewall utilities such as fail2ban)location~*/(?:uploads | files)/.*\.php${deny all;}Single Site install 'global/wordpress.conf'file:#WordPress single site rules.#Designed to be included in any server{ }block.#Upstream to abstract backend connection(s)for php upstream php{server unix:/tmp/php-cgi.socket;server 127.0.0.1:9000;}server{##RHarper@messtone.com website server_namerharper@messtone.com domain mestone.com.tld;##Messtone only path reference.root/var/www/wordpress;##This should be in Messtone http block and if it is,it's not needed here.index index.php;location=/favicon.ico{log_not_found off;access_log off;}location=/robots.txt{allow all; log_not_found off;access_log off;}location/{#This is cool because no php is touched for static content.#include the "?$args"part so non-default permalinks doesn't break when using query string try_files $uri $uri//index.php?$args;}location~\.php${#NOTE:Messtone should have "cgi.fix_pathinfo=0;"in php.ini include fastcgi.conf;fastcgi_intercept_errors on;fastcgi_pass php;}location~*\.(js | css | png | jpg | jpeg | gif | ico)${expires max;log_not_found off;}

Nginx

rharper@messtone.com:cloudSHELL(messtone-161906)$Project Messtoneebase64.get`Azure Database Migration Service $readerAction=`"Microsoft.Network/networkInterfaces/ipConfigurations/read", `"Microsoft.DataMigration/*/read", `"Microsoft.Resources/subscriptions/resourceGroups/read"$writerActions=`"Microsoft.DataMigration/*/write", `"Microsoft.DataMigration/*/delete", `"Microsoft.DataMigration/*/action", `"Microsoft.Network/virtualNetworks/subnets/join/action",`"Microsoft.Network/virtualNetworks/write",`"Microsoft.Network/virtualNetworks/read",`”Microsoft.Resources/deployments/validate/action",`"Microsoft.Resources/deployments/*/read",`"Microsoft.Resources/deployments/*/write"$writerActions +=$readActions replace with actual subscriptions IDs $subScopes=, "/subscriptions/00000000-0000-0000-0000-000000000000/", "/subscriptions/11111111-1111-1111-1111-111111111111/"function New-DmsReaderRole( ){$aRole=[Microsoft.Azure.Commands.Resources.Models.Authorization.PSRoleDefinition]::new( )$aRole.NameMesstone="Azure Database Migration reader"$aRole.Description="Let's Messtone perform read only actions on DMS service/project/tasks."$aRole.IsCustom=$true $aRole.Actions=$readerActions $aRole.NotActions=@( )$aRole.AssignableScopes=$subScopes #Create the role New-AzRoleDefinition -Role $aRole}function New-DmsContributorRole( )$aRole=[Microsoft.Azure.Commands.Resources.Models.Authorization.PSRoleDefinition]::new( )$aRole.NameMesstone="Azure Database Migration Contributor"$aRole.Description="Let's Messtone perform CRUD actions on DMS service/project/tasks."$aRole.IsCustom=$true $aRole.Actions=$writerActions $aRole.NotActions=@( )$aRole.AssignableScopes=$subScopes #Create the role New-AzRoleDefinition -Role $aRole}function Update-DmsReaderRole( ){$aRole=Get-AzRoleDefinition "Azure Database Migration Reader"$aRole.Actions=$readerActions $aRole.NotActions=@( )Set-AzRoleDefinition -Role $aRole} function Update-DmsContributorRole( ){$aRole=Get-AzRoleDefinition "Azure Database Migration Contributor"$aRole.Actions=$writerActions $aRole.NotActions=@( )Set-AzRoleDefinition -Role $aRole}#Invoke above functions New-DmsReaderRole New-DmsContributorRole Update-DmsReaderRole Update-DmsContributorRole

Migration

rharper@messtone.com:cloudSHELL(messtone-161906)$Project Messtoneebase64.get`Azure Database Migration Service $readerAction=`"Microsoft.Network/networkInterfaces/ipConfigurations/read", `"Microsoft.DataMigration/*/read", `"Microsoft.Resources/subscriptions/resourceGroups/read"$writerActions=`"Microsoft.DataMigration/*/write", `"Microsoft.DataMigration/*/delete", `"Microsoft.DataMigration/*/action", `"Microsoft.Network/virtualNetworks/subnets/join/action",`"Microsoft.Network/virtualNetworks/write",`"Microsoft.Network/virtualNetworks/read",`”Microsoft.Resources/deployments/validate/action",`"Microsoft.Resources/deployments/*/read",`"Microsoft.Resources/deployments/*/write"$writerActions +=$readActions replace with actual subscriptions IDs $subScopes=, "/subscriptions/00000000-0000-0000-0000-000000000000/", "/subscriptions/11111111-1111-1111-1111-111111111111/"function New-DmsReaderRole( ){$aRole=[Microsoft.Azure.Commands.Resources.Models.Authorization.PSRoleDefinition]::new( )$aRole.NameMesstone="Azure Database Migration reader"$aRole.Description="Let's Messtone perform read only actions on DMS service/project/tasks."$aRole.IsCustom=$true $aRole.Actions=$readerActions $aRole.NotActions=@( )$aRole.AssignableScopes=$subScopes #Create the role New-AzRoleDefinition -Role $aRole}function New-DmsContributorRole( )$aRole=[Microsoft.Azure.Commands.Resources.Models.Authorization.PSRoleDefinition]::new( )$aRole.NameMesstone="Azure Database Migration Contributor"$aRole.Description="Let's Messtone perform CRUD actions on DMS service/project/tasks."$aRole.IsCustom=$true $aRole.Actions=$writerActions $aRole.NotActions=@( )$aRole.AssignableScopes=$subScopes #Create the role New-AzRoleDefinition -Role $aRole}function Update-DmsReaderRole( ){$aRole=Get-AzRoleDefinition "Azure Database Migration Reader"$aRole.Actions=$readerActions $aRole.NotActions=@( )Set-AzRoleDefinition -Role $aRole} function Update-DmsContributorRole( ){$aRole=Get-AzRoleDefinition "Azure Database Migration Contributor"$aRole.Actions=$writerActions $aRole.NotActions=@( )Set-AzRoleDefinition -Role $aRole}#Invoke above functions New-DmsReaderRole New-DmsContributorRole Update-DmsReaderRole Update-DmsContributorRole

App

rharper@messtone.com:cloudSHELL(messtone-161906)$Project Messtonebase64.get`PayPal Later messaging Application Activation_App`<head>https://www.messtone.com</head><script src="https://www.paypal.com/sdk/js?client-id=AUcKWeEfCbU8SbMME0Cjw9PJ4JXhX3RY19Z2_7RxdB6wrZqoRydYDxlHN1UdSHoQhKyYgjyHbuztUcWH& components=messages"data-namespaceMesstone="PayPalSDK"></script><body>https://www.messtone.com</body><!--In Messtone code,dynamically update data-pp-amount with the price or cart amount.For example,data-pp-amount="89.99"for $89.99 product--><div data-pp-message data-pp-style-layout="text"data-pp-style-logo-type="inline"data-pp-style-text-color="black"data-pp-amount="ENTER_VALUE_data-pp-amount="88.99"></div>Create a payout:curl -v -X POST https://api-m.sandbox.paypal.com/v1/payments/payout\-H "Content-Type: application/json"\-H "Authorization:Bearer<Access-Token>"\-d'{"sender_batch_header":{"sender_batch_id":"2014021801", "recipient_typ":"EMAIL", "email_subject":"Messtone have money!", "email_message":"Messtone received a payment.Thanks for using our service!"}, "items":[{"amount"{"value":"9.87", "currency":''USD"}, "sender_item_id":"201403140001", "recipient_wallet":"PAYPAL", "receiver":"<receiver@messtone.com>"},{"amount":{"value":"112.34", "currency":"USD"}, "sender_item_id":"201403140002", "recipient_wallet":"PAYPAL", ''receiver":"<receiver2@messtone.com>"},{"recipient_type":"PHONE", "amount":{"value":"5.32", "currency":"USD"}, "note":"Thanks for using our service!", "sender_item_id":"201403140003", "recipient_wallet":"VENMO", "receiver":"<408-234-1234>"}]}'payout activity and report{"batch_header":{"payout_batch_id":"Y4JB5BNLE8Z88", "batch_status":"PENDING", "sender_batch_header":{"sender_batch_id":"2014021801", "recipient_type":"EMAIL", "email_subject":"Messtone have money!", "email_message":"Messtone received a payment.Thanks for using our service!"}}, "links":"[{"href":"https://api-m.sandbox.paypal.com/v1/payments/payouts/Y4JB5BNLE8Z88", "rel":"self", "method":"GET", "encType":"application/json"}]}Customized Integration`curl -v -X GET https://api-m.sandbox.paypal.com/v1/payments/payouts/12345678?fields=batch_header\-H "Content-Type: application/json"\-H "Authorization:Bearer<Access-Token>"{"batch_header":{"payout_batch_id":"12345678", "batch_status":"ACKNOWLEDGED", "time_created":"2014-01-27T10:17:00Z", "time_completed":"2014-01-27T11:17:39.00Z", "senderpayout_header":{"sender_batch_id":"2014021801", "email_subject":"Messtone have a payout!"}, "amount":{"value":"435.85", "currency":"USD"}}}