Improve company productivity with a Business Account.Sign Up







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

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!
Get your problem seen by more experts
LVL 12
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions


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?
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?
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))
Free Tool: ZipGrep
LVL 12
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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.
seagate 30000gb hard drive shows up as  used 2.25 mb, and free 746 gb in properties.  Where is the rest of the drive.    Am i reading this right?  Drive came out of a Lacie external drive brand new.

Hi Everyone

I have finally got WSUS configured and updating my clients as I want.  I have set critical and security updates to Auto Approval and everything else to install automatically once specifically approved.

Assuming everything is OK with the Test OU I will push out to the rest of the domain.  I havent yet got round to the servers as I wanted to make certain I wasn't rebooting them unexpectedly.

I just have a couple of things that I wanted to clear up.  

1.  Am I right in thinking the Microsoft Updates are released monthly (every 2nd Tuesday) ?

2. Is there any websites or similar that list known problematic updates so I'm not blindly approving things that could cause a problem.  I have had a look at the Microsoft Update website and it appears to show Known Issues that the updates will fix.  We had a problem some time back with an Office update and it took a lot of googling to identify the specific update.

Thanks for reading :)
Our Domain controller seems to have some replication issues.

I've inherited this domain & my daily work with windows domains is very limited.

We have one DC & the rest are showing as Global Catalogs.

For some reason the DC itself has 2 names in the active directory (1. "Backup" - this is the real "computer name" & it's listed as DC on the active directory. 2. "DC" - I'm not sure where this name is configured on the server itself but if you look at our DNS server this name is marked as "Static". this name is listed as a GC at the AD).

If I ran the command repadmin /showrepl at any of the GCs you get this message regarding this "DC": "The target principal name is incorrect".

Please help
Hi Experts,

I need to use an API utility to import objects from a certain vendor site into my database.
and got those links as references.

-      REST API:
-      SOAP API:

Now I would like to know if you can give me some guidance how to start this project.

FYI- I am mainly familiar with MS Access VBA programming language.

Thanks in advance.
I have an apex rest service, which produces a CLOB.

I wanted to output this CLOB through string parameter.

when I try to do this, I am getting "PLSQL value error"

Below is my code, how do I this..

  l_cursor SYS_REFCURSOR;
  v_stmt_str      VARCHAR2(1000);

   if (:status is NULL) then 
      v_stmt_str := 'select FROM_USER_NAME as "from_user_name", to_user_name as "to_user_name",  id as "id", type as "type", subject as "subject", message as "message", thread_id as "thread_id", status as "status", to_char(alert_date, ''YYYY-MM-DD"T"HH24:MI:SS"Z"'') as "alert_date" from user_alert where to_user_name = :username';
      OPEN l_cursor FOR v_stmt_str using :username;
      v_stmt_str := 'select FROM_USER_NAME as "from_user_name", to_user_name as "to_user_name",  id as "id", type as "type", subject as "subject", message as "message", thread_id as "thread_id", status as "status", to_char(alert_date, ''YYYY-MM-DD"T"HH24:MI:SS"Z"'') as "alert_date" from user_alert where to_user_name = :username and status = :status';
      OPEN l_cursor FOR v_stmt_str using :username, :status;
   end if;


  APEX_JSON.write('user_alert', l_cursor);

-- :output_val :=APEX_JSON.get_clob_output;;

Open in new window

output_val is an output parameter which is of string type.
I can not change the fill color on an object (with internals) in Adobe Illustrator CC. What am I forgetting to do? I attached a PDF file. You will see an Owl with yellow feet and yellow nose. The rest of the body looks green. I just want to change the green to yellow. Later; I will make it all black for a film positive. Thank you.
Hi, I am able to write the query and joined that with JAVA Code and it working fine. Now I Would like to highlight few items from the spreadsheet in the Final Outlook mail notification as below Please share your thoughts!!

This final mail output data can be captured from the spreadsheet and print. Kindly do the needful ASAP!!!


CUSTOMER ID                SUCCESS(10) ERROR(10) PENDING(10)
CUSTOMER ID                SUCCESS(10) ERROR(10) PENDING(10)[/i]
Has someone  good experience with the REST API of Exchange Online in a hybrid configuration? A devolpment team wants to build a solution based on the REST API but we are running Exchange 2010. REST API is not supporter in Exchange 2010. Based on this article we think it is possible but we are curious to your experience!

Kind regards,
Free Tool: IP Lookup
LVL 12
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

I have a Windows AD environment and use DFS to sync three locations.   I want to use a MS Access file and have three computers at one site to do updates to the file.  The rest of the users will have a runtime reader to read only the file.   I've done some testing and the reader seams to lock the file as well.  One location reported a completely  mixed up file.   Am I fooling myself thinking this will work ?
I am working with a REST data source.  Single row returns aren't a problem as I can deserialize them using something like:
 JsonConvert.DeserializeObject(Of myInstantiatedClass)(httpResponseContent)

Retrieving a data list isn't a problem either.  But I am unable to deserialize it (using Newtonsoft.Json) into a .NET LIST collection.   A view of the simplified data looks like:

Open in new window

I am using in this project but please feel free to send hints in c#!  I've tried various things including IEnumerate.  Simplifed snippet of the original code looks like this:
Public Class myClass
        Public Property id As String
End Class


 Dim myInstantiatedClass As New List(Of myClass)
        Dim response = Await client.GetAsync(Uri)
        If response.IsSuccessStatusCode Then
            Dim httpResponseContent = Await response.Content.ReadAsStringAsync()
                myInstantiatedClass = JsonConvert.DeserializeObject(Of List(Of InstantiatedClass ))(httpResponseContent)
            Catch jsonException As Newtonsoft.Json.JsonSerializationException
                Dim s As String = jsonException.Message
            End Try
        End If

Open in new window

The error code (using original variable and class names) reads:
"Cannot deserialize the current JSON object (e.g. {""name"":""value""}) into type 'System.Collections.Generic.List`1[BbRestApiExplorer.CourseGradeColumn]' because the type requires a JSON array (e.g. [1,2,3]) to deserialize correctly." 
"To fix this error either change the JSON to a JSON array (e.g. [1,2,3]) or change the deserialized type so that it is a normal .NET type (e.g. not a primitive type like integer, not a collection type like an array or List<T>) that can be deserialized from a JSON object. JsonObjectAttribute can also be added to the type to force it to deserialize from a JSON object." 
"Path 'results', line 1, position 11."

Open in new window

Any thoughts?   Thank you for your time.
I have created a template in Word 2010
It's say 10 pages. Pages 2-9 are identical. See rough sample attached in docx format
I'm wondering if it is possible to have the 1st page different to the rest of the template?
I tried this & it works to an extent but if I say try to move the table on Page 1 to the right of the screen,
it changes pages 2-9!
"On the View tab, select the Print Layout document view.
Double click the header area of the document.
On the Header & Footer Tools Design tab, in the Options group,
select the check box for Different First Page."

Is there some way to have an independant 1st page which I can format independantly?
I dont want to change pages 2-9. Just page 1
Any help would be much appreciated!
A client of ours is still sitting at "Windows Server 2003" for both the "domain and forest" functional levels. They only have 1 x 2008 member server with the rest of the member servers being Server 2012 and Server 2012 R2 editions.

We are having SYSVOL replication issues (I believe that it is still trying to use FRS versus using DFS Replication as it should be. We are also having DNS issues that we believe may be related to this as well.

I want to raise both the domain and forest functional levels, is there a specific order that these need to be done in? Is there a reboot of any kind required? Services that need to be restarted?

I haven't done this in several years so any suggestions are greatly appreciated.

I am building a solution that will display KPI information on a set of large TV screens for our warehouse and we use Netsuite for our ERP. My netsuite developer that we have in house can build a REST API in netsuite that uses Token based authentication to expose the data that i need but i am having trouble finding information on how to connect to this API.
All help is much appreciated.
Regards Joel
I have a static list id in my database, and I am trying to use the rest api to query to get the name to be able to display.  Does anyone know if this is possible?  I see in their API documentation the ability to query a smart list, but I don't see anything about static lists.

Thanks in advance for the help.






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