REST

202

Solutions

416

Contributors

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 have an existing web app hosted on MS Azure, written using VB in Visual Studio.
We haven't been using the REST API in Wordpress, but would like to now, especially to see if we can call Wordpress' UPDATE procedure for when a post is saved.

Currently, values from fields in a SQL Db are transferred to Wordpress' MySQL Db. It works OK, but we think it will be more efficient to call the UPDATE procedure to save each post 'the Wordpress way' after updating each record.

Can anyone supply some sample code for how we would login to Wordpress and update post_id "xxx" for example, ideally written in VB, although C++ might be workable if I can translate it...

Thank you
Tim
0
Concerto's Cloud Advisory Services
LVL 5
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Hey there,

I can scan to the share fine, but when I scan to PC it automatically saves into a subfolder with the current time and date.
I need it to not do this, because REST Filesmart processes files in the scan folder and can't look into deeper subfolders.
It used to work fine with a C5580 but the client has downgraded.

Any ideas?
I'm on site at the moment, so if I can get an answer soon that would be appreciated!!

Thanks
0
Rows 1 to 73  show what I am trying to do.

1. Move the contents  of the row below the call sign in Column B, or in Column C, (the columns are not regular) into Column O, on the the same row as the call sign from the row immediately above.
2 Where there is a suburb in column A, copy this name into each second row below, onto the same row as the call sign in column B, until there is another suburb.

I'll be able to tidy up the rest.

Thanks.
2017-TV-by-suburb-and-call-sign.xlsx
0
Hello ,

Im trying to find a quick easy way to import the results from a Web API into a sql server database , which will run every minute?

the example of the API is the following

https://bittrex.com/api/v1.1/public/getmarketsummaries   

Can anyone advise on this please?

Thanks
0
Hello Experts -

I have found that if I don't Disable Scripting (in Internet Options), that displaying web content in Internet Explorer is extremely slow - making many sites almost unusable.

Generally speaking, they freeze up or the scroll bars get stuck. I often get messages that say "web site is not responding" and iExplorer will then display a "recover webpage" button. The latter just reloads the same page to drag the experience anew.

But there are a few sites that are exceptions, if I idisable scripting as the default behavior via the setting in Internet Options. These sites are worthless without scripting.

So, is there a way I can get iExplorer turned to allow scripting for a few pre-defined sites - leaving scripting disable for all the rest.

Thanks.

Gordon
0
what are advantages of creating a REST service in Web API vs some other technologies in .NET like WCF, ASP .NET MVC etc.
0
What is the equivalent of an in operator in a query for REST API using a filter

Here is a sample URL where I filter for the customer number and I want to filter for multiple values

{{url}}/{{company}}/sales/invoices/?filter={"customer.customerNo": "CASH"}

To query this same data in the database I have

select * from customers where cust_no in ('CASH','ABC','123')
0
Hi,

This what vendor provided to test

Error is :

The remote server returned an error: (401) Unauthorized.

My code

string result = string.Empty;
            try
            {
                // Create Request
                HttpWebRequest req = (HttpWebRequest)WebRequest.Create(@"https://api.verilocation.com/public/v1/drivers?id=1093609330685010");
                req.Method = "GET";
                // Create Client
                WebClient client = new WebClient();
                req.ContentType ="application/json; charset=utf-8";
               // req.UseDefaultCredentials = true;
               // req.PreAuthenticate = true;
               // req.Credentials = CredentialCache.DefaultCredentials;

                //req.ContentLength=61;


                req.Credentials = new NetworkCredential("xxx", "xxx111");
               
                   req.Headers.Add("Authorization","Bearer  Y2xpdmUuaG9sZGVuQHN0b25laGFyZHkuY28udWs6bDBnMTV0MWM1");
             //   req.Headers.Add("Authorization","Basic Y2xpdmUuaG9sZGVuQHN0b25laGFyZHkuY28udWs6bDBnMTV0MWM1");
                req.ProtocolVersion =HttpVersion.Version11;
            
                WebResponse response = req.GetResponse();
                string responseData = new StreamReader(response.GetResponseStream()).ReadToEnd();
                MessageBox.Show(responseData.ToString());




              // Assign Credentials
               
                
            }
            catch (WebException 

Open in new window

0
I have a query that joins two tables using three fields in Access 2010.  The fields used in the inner joins have identical data types.  When joining to only two of the three fields the query returns five records but when adding the third join nothing is returned.  Of the five records returned, only one is populated for the field CommitteeName in one table and the rest are null.  I can understand why that record is not returned when adding a third join but don't understand why the other four should be excluded.  The data type of the field in both tables is text and Allow Zero Length = Yes.  

I ran the following query to replace all blanks with null in both tables thinking this would solve it but no change in results occurred.
UPDATE tblBoardCommitteeImport1F SET tblBoardCommitteeImport1F.CommitteeName = Null
WHERE (((Nz([tblBoardCommitteeImport1F].[CommitteeName],''))=''));

I'm guessing the problem has to do with null values in the CommitteeName field in one or both tables but am not sure what to try next.  Any advice on how to troubleshoot this further would be appreciated.
0
I have a file "tobesplitted.xls" and it has 10 columns(column A, Column B,....) I need to split that in to two files....first file containing only the column A and the second file containing the rest of the columns...

so i should get two files "splittedfilecolumA.xls" and "Splittedfilerestofcolumns".

I also want to merge two files again "splittedfile(containing Column A and Column A1)" with "Splittefilerestofcolumns.xls".

Hope i have made my requirement clear.

Appreciate if this can be done in unix
0
What does it mean to be "Always On"?
LVL 5
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Hi Experts!

Is it possible to display the queries results on a form NOT a report, I needed this for the purpose of the bank reconciliation in my Ms Access application for example:
(1)      I want to see all the debits as a list in that form after filtering by date
(2)      I want to see all the credits as a list in that form after filtering by date
If this is possible then the rest I will handle it as long as the above can be seen on a form.


Regards

Chris
0
Hi

I am trying to find an example of building a web project in Visual Studio that manipulates the REST/SOAP API
as per https://developer.salesforce.com/docs/atlas.en-us.api_rest.meta/api_rest/intro_what_is_rest_api.htm

I am an ASP.net developer and was hoping to use an ASP.net web app
0
I'm extremely new to programming. I've been tinkering with it on and off for decades but have never written an actual program. That changed yesterday.

Now, I've hit a brick wall.

I do not understand the fundamentals, but I get how code works for the most part.

My question is I have code that looks like this:

Private Sub Crystl32Button_Click(ByVal sender As System.Object, e As EventArgs) Handles Crystl32Button.Click
        For Each P As Process In System.Diagnostics.Process.GetProcessesByName("InHouseApp")
            P.Kill()
            P.WaitForExit()
        Next
        My.Computer.FileSystem.CopyFile("\\remoteserver\software\iha\ocx\crystl32\*.*", "C:\Windows\System32\",
        Microsoft.VisualBasic.FileIO.UIOption.AllDialogs, Microsoft.VisualBasic.FileIO.UICancelOption.DoNothing)
    End Sub

Open in new window


I want to add the functionality of this:

Sub RemoveFileSecurity(ByVal fileName As String, ByVal account As String, _
        ByVal rights As FileSystemRights, ByVal controlType As AccessControlType)

        ' Get a FileSecurity object that represents the 
        ' current security settings.
        Dim fSecurity As FileSecurity = File.GetAccessControl(fileName)

        ' Remove the FileSystemAccessRule from the security settings. 
        fSecurity.RemoveAccessRule(New FileSystemAccessRule(account, _
            rights, controlType))

        ' Set the new access settings.
        File.SetAccessControl(fileName, fSecurity)

    End Sub

Open in new window


This code is supposed to remove the ACL listing of a specific account for a file.

However, I do not know how to add this:

Sub RemoveFileSecurity(ByVal fileName As String, ByVal account As String, _
        ByVal rights As FileSystemRights, ByVal controlType As AccessControlType)

Open in new window


To my button click sub. Whenever I try, it auto-completes and removes the "Sub" I type in. I assume you can't have a Sub within a Sub but what do I modify in order to get the rest of the ACL code to work with the button click? Do I have to modify the button click Sub in order to match the ACL one?

I apologize if I'm not making sense. Again, this is my first real program and I'm not exactly up to par on all the methodologies.
0
I am hitting a wall here and exhausted my researching skills. Looking to the experts here.
In summary, my developer at work created a REST API for me to call via Access/VBA. Below is some sample code I have created to use this API. This API is to call an import utility to import the data I am passing in the request.

I know my authentication is good as well as the URL. I am getting a http status of 200 and a expected JSON response. Also in the API I am passing the ImportSpecification ID that has to exist in the source system. If I change that value to "XYZ" I get an error saying the Import Specification doesn't exist. So that validates the URL in my opinion.

Based on the JSON response, it doesn't appear the body (response) of my message is getting received. Below is my code for reference. I have taken out the necessary sensitive info. What am I missing here?!?!

Dim sURL As String, Request As String
Dim xmlhtp As XMLHTTP60
Set xmlhtp = New XMLHTTP60

Request = "<ImportData xmlns=""urn:Import.DataUtility"" xmlns:xsi=""http://www.w3.org/2001/XMLSchema-instance"">"
Request = Request & "<Data xsi:nil=""false"">"
Request = Request & "<string xsi:nil=""false"" xmlns=""http://schemas.microsoft.com/2003/10/Serialization/Arrays"">##INI=EMP</string>"
Request = Request & "<string xsi:nil=""false"" xmlns=""http://schemas.microsoft.com/2003/10/Serialization/Arrays"">1,DATLATEST</string>"
Request = Request & "<string xsi:nil=""false"" …
0
Hello,
I have written a mock for a REST service using SoapUI free version. The resource path looks like <webservice>/employees which returns all employees in JSON. Now I want to pass a parameter which is a date range, something like <webservice>/employees?from=01-01-2017&to=31-12-2017
This will return only a few employees who joined during the date range. I am not able to find a way to accept parameters in the mock response and not sure how do i check something like if(date == 01-01-2017 to 01-04-2017) { //pass this json text   } else if(date == 08/08/2017 to 31/12/2017) { pass this text }

Any help would be greatly appreciated as I am new to SoapUI
0
I am currently hosting an API as an Azure App service. But I want to move it into my Virtual Machine and run it in IIS.
I already set it up as I would with any website but for some reason the page does not come up. Is there anything in specific I need to do to run the service?
0
So we're a Canadian company, and we had our Exchange 2010 on prem for a long time. An American company bought us out, and we ended up migrating our mailboxes to their newer Exchange 2016. However, we all notice the lag now, and although it's tolerable for some of us who are at major offices with Fiber internet connections, the rest of us are having a myriad of problems with the new setup, everything from inconsistent lag, to DNS and Autodiscover setup being less than ideal, to local Mailbox caches continuously break and forcing to recreate profiles in Outlook every time someone jumps on and off the VPN.

I wanted to explore the option of getting Exchange Online or some other service, and migrating those mailboxes to the Cloud, and having those users connect to the cloud-based mailbox. It makes even more sense to leverage cloud as the people who have these problems the most are mobile and are travelling across North America all the time.

Has anyone had experiences or a setup like this, and if so, can you give any feedback or advice on how to approach it?


Thanks
0
MS Access 2013 - I have a shared database with a form that maximizes on open.  It has an EXIT button with an event property of docmd.quit.  On my computer the EXIT button closes completely out of Access which is what I want; however for all other users, when they click the EXIT button, it only closes the form and leaves the rest of Access open.   I would appreciate any assistance please.
0
Hello,
facing a problem to choose best client side framework for localization with jsp?
I have REST API which i need to consume at client side and display it on jsp will it be safe to use spring mvc for client side?
What is the best practice to integrate client-server ?
0
Vote for the Most Valuable Expert
LVL 7
Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Someone has suggested that I do a client side only rest api implementation using Angular or another MV* frontend framework. However, it is my understanding that client side only is not safe to have sensitive information flowing back and forth to API, like the API KEY.

Is there an external source known to someone here that could be used to fetching credentials and enforcing CORS - cross-origin resource sharing?

Any tips or best practices or advice on this ask would be appreciated.
0
Hello All,

 I am connecting Exchange 2016 server remotely via PS script to manage the Mailbox rules for users, we have close to 1500 users for which we have to create/modify mailbox rules however when i run the script (from non exchange server) which first import the exchange session to powershell and then execute the commands to manage mailbox rules but it fails after running properly for a few users with the message "Get-InboxRule/ New-InboxRule" is not is not recognized as the name of a cmdlet, function, script file, or operable program". i.e it is trying to execute the command before it imports the exchange cmdlet into powershell, please note when i run it for a few users only it will work properly.

i have also provided delay in the PS script just after import exchange session/cmdlets command but it didn't help.

sample PS script code:

$username = "xyz"

$password = get-content D:\password.txt | convertto-securestring

$cred = new-object System.Management.Automation.PSCredential -argumentlist $username, $password

$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri url -Credential $cred

Import-PSSession $Session

Start-Sleep -s 10

Rest commands to Manage Mailbox

 Note- i am using the proper url in -ConnectionUri, here it is not accepting url to be included in body so i am replacing my url with simply a name "url" :)

 

I have to call the script one by one for each user, hence the one time connection to exchange …
0
This plugin appears on a site I created as needing updating. I don't recall ever adding it.  Does anyone know what it is for and should I update it?
0
Hi,
I am testing the deployment of BITLOCKER via GPO.
For the moment I want to just encrypt the fixed drives without using TPM
I have created a TEST OU and moved a single computer to it.
I have created a GPO and edited/activated the following
Computer Configuration>Administrative Templates>Windows Components>BITLOCKER encryption
I have activated the following
Control the use of BITLOCKER on fixed drives:ACTIVE
Configure the encryption on the hardware level on the fixed drives:ACTIVE
Select the recovery method for recovery of fixed drives using BITLOCKER: ACTIVE
The rest is not configured.
Please note that I have the GUI in french so the translation might not be exact.

I have applied the GPO to the TEST OU
run gpupdate /force on the only computed within the OU
Restarted the computer
The GPO does not seem to apply
manage-bde -status and the bitlocker mmc show the the bitlocker DISACTIVE

What am I doing wrong or what do i need to add?
Please help.
Lenovo ThinkPad with running Windows 10

Are there any compatibilty issues with OPAL drives?


GPO Bitlocker
0
I'm looking to consume an external Rest API Json data source into a SharePoint Online list column. I have the enterprise version with BCS.  Anyone had luck with this?
0
I am trying to do something similar to the app specs below.  I'm looking for a sample.  I thought I would use Asp.net Core MVC,  Ajax and SQL server.  I'm looking for a sample that can show me each step.

It's pretty simple.
1. My app has a form with 4 fields. (Vin, Make, Model, Year)
2. I input Vin in field 1 (Vin)
3. I GET from a third party Rest API JSON by passing the Vin to a URI string. The string will pass Vin I input and an API key
4. The API returns (Make, Model, Year)
5. I want to fill the additional form fields with (Make, Model, Year)
6. Finally, I want to save all fields (Vin, Make, Model, Year), to my Database.

I have been searching for an example similar.  I did find the Weather app example, but it's not complete.  It's just part of it.
Weather example: https://www.codeproject.com/Articles/1180283/How-to-Implement-OpenWeatherMap-API-in-ASP-NET-MVC
0

REST

202

Solutions

416

Contributors

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
REST
<
Monthly
>