RESTSponsored by Jamf Now





Representational state transfer (REST) is an architectural style that gives a coordinated set of constraints to the design of components in a distributed hypermedia system used to design networked applications. RESTful systems typically communicate over Hypertext Transfer Protocol (HTTP) with the same HTTP verbs (GET, POST, PUT, DELETE, etc.) that web browsers use to retrieve web pages and to send data to remote servers. REST interfaces with external systems using resources identified by Uniform Resource Identifier (URI) that can be operated upon using standard verbs.

Share tech news, updates, or what's on your mind.

Sign up to Post

I am using the following code which sends an email from excel to outlook
Sub Send_Email_Late()

    Dim rng As Range
    Dim OutApp As Object
    Dim OutMail As Object
    Dim Name_Lookup As String


    Set rng = Nothing
    Name_Lookup = ActiveSheet.Range("A3").Value
    On Error Resume Next
    'Only the visible cells in the selection
    'Set rng = Sheets("Sheet 1").Range("B2:B22").SpecialCells(xlCellTypeVisible)'
    'You can also use a fixed range if you want
    Set rng = Sheets("Stationary").Range("B1:O8").SpecialCells(xlCellTypeVisible)  ':B11
    On Error GoTo 0

    If rng Is Nothing Then
        MsgBox "The selection is not a range or the sheet is protected" & _
               vbNewLine & "please correct and try again.", vbOKOnly
        Exit Sub
    End If

    With Application
        .EnableEvents = False
        .ScreenUpdating = False
    End With

    Set OutApp = CreateObject("Outlook.Application")
    Set OutMail = OutApp.CreateItem(0)

    On Error Resume Next
    With OutMail
        '.SentOnBehalfOfName = ""
        .To = ActiveSheet.Range("Cs4").Value
        '.CC = Sheets("Email Data").Range("K2").Value'
        .BCC = ""
        .Subject = "Lateness Email - ENTER DATE"
        .HTMLBody = Name_Lookup & RangetoHTML(rng)
        .Display  'or use .Display
    End With
    On Error GoTo 0

    With Application
        .EnableEvents = True
        .ScreenUpdating = True
    End With
'    MsgBox

Open in new window

Cloud Class® Course: MCSA MCSE Windows Server 2012
LVL 12
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Hi Experts,
I have the following code which loops thru all records of a given table (on Caspio site) and prints out the contents.
Function GetDataFromCASPIO1()
    Dim objHTTP As New WinHttp.WinHttpRequest
    Dim docXML As MSXML2.DOMDocument
    Dim ResponseText As String
    Dim curNode As IXMLDOMNode
    Dim oNodeList As IXMLDOMSelection

    Set docXML = New MSXML2.DOMDocument

    Set objHTTP = New WinHttp.WinHttpRequest
    URL = ""
    objHTTP.Open "POST", URL, False
    objHTTP.SetRequestHeader "Content-Type", "application/x-www-form-urlencoded"

    objHTTP.Send "grant_type=client_credentials&client_id=MyClientID&client_secret=MySecretID"
    ResponseText = Right(objHTTP.ResponseText, Len(objHTTP.ResponseText) - 17)
    access_token = Left(ResponseText, InStr(ResponseText, """") - 1)
    'Debug.Print access_token

    Set objHTTP = New WinHttp.WinHttpRequest
    'objHTTP.setRequestHeader "Content-Type", "application/json"
    URL = ""
    objHTTP.Open "GET", URL, False
    objHTTP.SetRequestHeader "Accept", "application/xml"
    objHTTP.SetRequestHeader "Content-Type", "application/json"
    objHTTP.SetRequestHeader "Authorization", "Bearer " + access_token
    'Debug.Print objHTTP.Status
    'Debug.Print objHTTP.ResponseText
    docXML.loadXML (objHTTP.ResponseText)

    strXPathQuery = "Caspio/Row"
    Set oNodeList = 

Open in new window

can anyone explain how to create REST API using PHP
So I have a block of static ip addresses, im currently using one with my peplink router and I have the rest attached to a switch so I can use them for other applications that need public IP's. From within my lan behind the peplink router I cannot get to one of the public ip's I have attached to a device that is sitting on the public ip side of things on that switch.. I can ping it from with in my lan but I cannot access it. My guess there is a port that is being blocked? 443 is the service port and https is turned on. Any tip or trick on what exectly I need to fwd in my peplink router would be greatly appreciated..
Downloaded a Sample App.  I am using VS2015.  The app doesn't compile.  I am receiving what seems to be a REST error.

CS1503      Argument 2: cannot convert from 'System.Action<System.IO.Stream>' to 'byte[]'      Tradovate.Services      

The error is occurring at

                request.AddFile(param.Value.Name.ToString(), param.Value.Writer,
                                param.Value.FileName.ToString(), param.Value.ContentType.ToString());

In the below code.
using System;
using System.Collections;
using System.Collections.Generic;
using System.Globalization;
using System.Text.RegularExpressions;
using System.IO;
using System.Web;
using System.Linq;
using System.Net;
using System.Text;
using Newtonsoft.Json;
using RestSharp;

namespace Tradovate.Services.Client
    /// <summary>
    /// API client is mainly responsible for making the HTTP call to the API backend.
    /// </summary>
    public partial class ApiClient
        private JsonSerializerSettings serializerSettings = new JsonSerializerSettings
            ConstructorHandling = ConstructorHandling.AllowNonPublicDefaultConstructor

        /// <summary>
        /// Allows for extending request processing for <see cref="ApiClient"/> generated code.
        /// </summary>
        /// <param name="request">The RestSharp request object</param>
        partial void InterceptRequest(IRestRequest request);

        /// <summary>
        /// Allows for extending response processing for <see

Open in new window

I have installed a copy of Magento 2 locally on my computer and what I want to do is to set it up so that I can access the whole thing as a Rest Api.

I have tried some url's like: but I don't get any json.

How can I set this up so I can access the api from my browser url?
Hi all,
I have following powershell script that I use to re-order column, its actually works pretty fine and fast.  There is  few changes that I need to work on this scripts.

1: How do I introduce new column in output file although existing file did not have those column ? I need to add two more column between $data[4], $data[7], $data[6], I also need to add column name header in this new column  since the rest of the column has column header.

$ImportDate = (Get-Date).AddDays(-1).ToString('yyyy-MM-dd')
$DWHFile = "DWH_Import_File_$ImportDate"
$DWHFile1 ="$ImportFile-Convert.csv"
$Import = [System.IO.File]::OpenText("F:\DWH\HRISEMP\$ImportFile")
$DWHdata = New-Object System.IO.StreamWriter "F:\DWH\HRISEMP\Tool\$DWHFile1"
for(;;) {
    $line = $Import.ReadLine()
    if ($null -eq $line) {
    $data = $line.Split(",")
    $DWHdata.WriteLine('{0},{1},{2},{3},{4},{5},{6},{7},{8}', $data[0], $data[8], $data[5], $data[4], $data[7], $data[6], $data[2], $data[1], $data[3])


Open in new window

Hi Experts,
I have written a small application that is linked to Excel files, reads two spreadsheets and does some comparisons.
Those sheets contain SS numbers.
Now I see that some socials are aligned to the right side and some to the left side.
And the problem is that Access only reads the first set of socials, the rest are showing as error.
Since user gets those files from a third party software, no way to figure out why they're like this..
How can I overcome this issue?
I have been asked to stand up a weighted search appliance for a company.  The decision was to use SOLR to create the search tool so they can use the associated REST API for searches and recommendations.

I'm am still beginning in SOLR and have to ask a basic architecture question.  I have a table with 220 elements, 130 Million record strong.  I grow 5 million a year.

Does this become a Hadoop solution?  or can this still be done with a single SOLR engine?  I need to know which direction to start with so I do this right

Thanks much.
I have an HP EliteBook laptop that was getting a new image. This is a G2 laptop. Anyway I started the laptop image in the Microsoft System Center\software center. Selected the name-G2 - ME firmware - install bios - and googleDriveSync. I then selected and downloaded the ME updater. The firmware finished. Then in the bios I selected fast boot, PXE internal nic, PXE internal IPV4 nic, and under secure boot config I selected UEFI native without CSM then under device settings checked the box that said SATA device mode set to AHCI, VTx is checked  and G2 only then saved it. Then the user grabbed it before I could start the rest as I had to make a call to another user. She took the laptop and now it will not boot to any OS and goes to shut down mode. I was told that this would make a brick out of the laptop? Is there no way to get this laptop back to factory settings without a new motherboard being needed? This is really my question.
Cloud Class® Course: Amazon Web Services - Basic
LVL 12
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

Dear experts,

I have purchased a new touchscreen laptop HP Pavilion.

While working on the notepad I have seen that the screen moves upwards without me scrolling. What i mean is I observe this scrolling when I rest my wrist and palm on the screen to begin writing.

How do I ensure it does not scroll involuntarily. Can i lock it?

In the attached video I have simulated my experience through voluntary scrolling. My issue is it scrolls when i just rest my palm and when there is no scrolling.

Kindly guide.

Thank you
Is there a way to search for e-mails / calendar items with a specific word in it like "registered" and remove that line only and keep the rest of the subject
Exchange / Office365
Example : [REGISTERED] - Realsubject
Remove the [REGISTERED] and keep Realsubject

Thanks in advance!

I've set up a group policy which goes into Computer configuration>Admin templates>System>Windows Time Service>Time providers>Enabled both Configure Windows NTP Client, Enable Windows NTP Client and Enable Global configuration settings.

Under Configure Windows NTP Client I have selected Enabled and for NtpServer I have put in 2 DC's which I want the rest of the DC's to sync NTP with.

The hosts example: Core1 and Core2. These are both getting their NTP from:

I want the rest of the DC's in our environment to get their NTP from Core1 and Core2.

Core1 is running WS 2016
Core2 is a cisco switch
The rest of the DC's are running WS 2008 R2

So the problem is some of these dc's are getting the proper NTP servers after a gpupdate /force. I'm getting a few which are not applying the GPO. I've checked the group policy results on these machines and it's neither showing up as Applied or Denied.

 Anyone have any suggestions?
We have a wordpress website based on a template that we purchased years ago.  It has worked fine until recently. (I am not sure when it changed, as I don't check it often.)  My suspicion is that a Wordpress update resulted in the website appearing differently now.

It seems like there might be an issue with things that would normally appear grouped several to a row are now appearing with only one item per row.  For example, on this page - - there should be some pictures of featured projects under the title "FEATURED PROJECTS", but nothing seems to show.

Another example of the new problem is on the page all the Directors should fit on one row, and all the rest of the design professional should fit on one or maybe two rows, rather than only one person per row...

Thanks for any help that you can provide!
If i have a rest controller in spring boot how can I validate the contract that comes in if certain values of the parameters need to have certain values??? ANy code examples are appreciated!
I have an MS Access application that is hosted on a Remote Server.  One of the features I need to add is the ability to dial phone numbers and have looked at several solutions (as some of you know).  One of the solutions seems ideal as it will dial the required number and then call the users desk-phone (a common practice).  The service provider has a RESET API toolkit available, which looks ideal - but sadly, I have never worked with REST.  

So my question is this.  Will I be able to make a REST API call via VBA/Access as well as pull in the results  (connection time, engaged etc).
Hi Experts

Sorry people may be I mislead you. All what I want is how to include a productID range within Dsum

Dsum(“Closing”,”QryOpFinalstocks”,” [ProductID] = “ & Forms![<formname>]![<controlName>]& “ And [Warehouse ID] = “& Forms![<formname>]![<controlName>]& “ And [PPDate] <= “#& Forms![<formname>]![<controlName>]& “ #” )

I need that so that the selected code from the form query are picked correctly

How do we insert a product ID range in the above code??????????????


On excel, is there a way to lock certain cells, so the information in them can not be accidentally deleted while allowing the rest of the page to be modified?
Question: Is about Microsoft Windows Server 2016 Essentials, to save money can I run this with my main Firewall (software)?  I know there is a limit of 25 users and 50 devices, but I would only have 2 actual logins to maintain the box, the rest of the users would just be passing through the firewall.  Would this work? Is it licence complaint?
Cloud Class® Course: Python 3 Fundamentals
LVL 12
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.


I am a complete novice with REST APIs but have managed to connect to one using SOAPUI.

My next step is that I need to perform a similar connection using a powershell script.

So I need to connect using a Post method.

1. Obtain the authorization value
2. Use the value obtained as part of the authorization request as a "Request parameter" to make a Post call by using a pre-defined variable.
3. Use a further parameter to specify the data format i.e. json
Hi! I have a Crosstab showing the totals of my companies at my report footer. The problem is: I don't want the crosstab to be cut in half at the end of the paper, and to throw the rest of the information to next page. Is there anyway for me to set the cross tab to go to the other page automatically?

Thanks in advance
Will different Cryptographic Hashes (of same type)  return different values? I need to run a JavaScript version of a SHA-256 hash against some data client side. We will also have a rest api service running that needs to duplicate and produce the same hashes. I've read where certain version of a SHA-256 hash return different values based on who developed it and the platform. So how do we get around this? Also any recommendations for a specific version of SHA-256? The files will be small, 200-400 bytes each.

We have one machine which cannot see the rest on the domain under the network tab in File Explorer.

We have checked Network Sharing is enabled, it can ping/browse the machines which are not showing up, it is on the correct range and is using the correct DNS, DHCP, and Gateway. I have tried setting these details to static and it is the same.  

It is running Windows 10 (as are all the client PCs) so we have tried the network reset option. And finally a system restore.

I still cannot see the other machines in this tab. We have recently started looking after this client and one of the things I have looked at is that they use a proxy server. This is configured and sent out to the machine under group policy. The policy has applied when I run a gpresult /r and the internet connects fine. I did notice when I dialled in and looked under Ethernet on the W10 network settings that it said action needed under the adapter. It needed the user credentials for the proxy. I entered these and it returned to say connected. I have not had this since after several reboots and the above troubleshooting steps.

Any help would be appreciated.

In a stored procedure we have a query that has worked in the past but no longer does on after we upgraded servers. The new server is SS2016.  It still works on our older 2012SQL Server.  Any type of options / settings that may have been that jump out at you? Or any reason at all whey we are suddenly encountering this.

Older version:

        AND ISNUMERIC(drug.GCN_SEQNO) > 0

Note: the data  from g.GCN_SEQNO is all numeric. The data in the drug.GCN_SEQNO is a char field because it has one value = 'UNKNOWN'. The rest of the data is numeric format.

When we changed to a CASE statement or Try_cast, it works fine. So we solved for it, but just not sure why its not an issue.
Updated versionL

WHERE g.GCN_SEQNO = try_cast(drug.GCN_SEQNO as numeric(28,0))
Our company is moving some components to our internal cloud and I am working in a project and one of the task is to expose an existing legacy java class as soap web service. Can anyone please help me stir in the right direction? How can  I write a soap Producer on existing new class and methods? Should I write a new class and extend this class or should I write a subclass? What is the best  way  to approach  this?I  am new  to integration projects. The company is using  Mule  Esb as an integration solution? Also how Mule esb fitst together  with all this?I am new to  Mule  esb.

RESTSponsored by Jamf Now





Representational state transfer (REST) is an architectural style that gives a coordinated set of constraints to the design of components in a distributed hypermedia system used to design networked applications. RESTful systems typically communicate over Hypertext Transfer Protocol (HTTP) with the same HTTP verbs (GET, POST, PUT, DELETE, etc.) that web browsers use to retrieve web pages and to send data to remote servers. REST interfaces with external systems using resources identified by Uniform Resource Identifier (URI) that can be operated upon using standard verbs.

Top Experts In