Skip to main content

Connecting Excel to ServiceNow

I published a post to the ServiceNow community forum where I showed a procedure to create a query in Excel that pulls information from ServiceNow via the REST API.

https://community.servicenow.com/message/979582

Comments

Popular posts from this blog

Mike Rowe Says Don't Follow Your Passion

With a zingy catch line, Mike Rowe explodes some myths about "working people" in this talk on Fora.tv, " Mike Rowe on Discovery, Realization and Lamb Castration ." Some surprising insights. Lamb castration the way the Humane Society recommends (with rubber bands) is more painful for the lamb than the way the shepherds actually do it (with a knife). "Following your passion" is not a mandatory ingredient for a happy work life. People with "dirty jobs" are very well balanced and happy. Safety first is a slogan that doesn't always make sense for the people doing the job. His example about the crab fishing rig was a good example. The captain said, "OSHA? We've got Ocean. I'm not here to make you safe. I'm here you make you rich. If you want to get home alive, that's your job."

Hammers and Nails: Technology Push Design

"We need to refine our requirements first, before we look at tools." This is a common phrase that I hear. While I sympathize with the sentiment, I think it is frequently wasteful. I suspect that we'd get to the right requirements faster by looking at tools already available in a given problem space. Pushing the concept further, is it foolish to find a cool technology and then look for ways that that technology can apply to current problem spaces?  What if you don't even recognize you have a problem space? Without a constant search and openness, we'll miss many serendipitous opportunities. Here is BYU professor Larry Howell discussing this issue. I often enjoy doing something ... that is sometimes controversial. In this approach, rather than starting with a need, you start with a new technology and you search to identify a need that it can fulfill. This second more controversial approach is called "technology push design."   You can imagine t

The "True Cost" Phantom in Project Cost Tracking

I want to know if I should wear a coat when I go out the door on an unpredictable spring morning. The temperature from the weather app on my phone isn't going to match exactly the temperature just outside my front door, but it will be close enough to make the decision. If the question at hand is whether or not I should wear a coat, it would be a costly mistake to set up an elaborate system of thermometers around my property to try increase the precision of my measurement of the temperature. The added expense wouldn't yield any better decisions about whether to wear a coat, so why bother? We are interested in tracking the relative costs of the various projects we undertake in our organization. We must admit up front that we will never be able to measure the precise cost of each of our projects. Consider the following things you could include in the "true cost" measurement of a project. Where will you draw the line? An engineer reads an article on the bus that give