We help IT Professionals succeed at work.

Web Services

A Web service is a method of communication between two electronic devices over a network. It is a software function provided at a network address over the Web with the service always on as in the concept of utility computing. A web service has an interface described in Web Services Description Language (WSDL). Other systems interact with the Web service in a manner prescribed by its description using SOAP (Simple Object Access Protocol) messages. There are two major classes of Web services: REST-compliant web services, and Arbitrary web services.

I've been asked to push some data to an external web service using Access 2010. After researching this all day, it looks like many suggestions point to using Visual Studio to create a dll that utilizes VS's ability to auto generate the web services protocol code, reference then dll in Access and then call it from my Access 2010 VBA code. The web service code works great when bundled as a standalone exe. However, when I compile it into a dll, reference it within Access and then call it from by Access VBA code, I get the following error:

"Could not find the default endpoint element that references contract 'ServiceReference1.NameOfMyDllClass' in the ServiceModel client configuration section. This might be because no configuration file was found for your application, or because no endpoint element matching this contract could be found in the client element."

After a little more digging, it appears that creating a dll does not include the app.config file that contains this configuration information so I'm guessing my DLL can't find the configuration information it needs to initiate the web service transfer. Most recommendations seem to suggest adding the info in the app.config file to the host's app.config but off course Access does not have anything like that.

With so many recommendations to use dlls that wrap the web services when using Access, it sounds like a great way to go but I must be doing something wrong. Any help to get me pointed in …
0
I need help in setting up a proper multipart/related HTTP request in VBA. If you can PLEASE show me samples in VBA of one.  A picture (Or Code) is worth a thousand words.

Here is my code for sending XML over HTTP currently:

Option Compare Database
Option Explicit

Public Function EbaySenderXmlAddFixedPriceItems()
Dim reader As New MSXML2.XMLHTTP40
    Dim doc As New MSXML2.DOMDocument 'If you want to load the XML Document instead of creating it.
    Dim TokenValue As String
    Dim APICALL As String
    
    '*************************************************************************************************************
    'API Call Name!
    '*************************************************************************************************************
      APICALL = "uploadFile" 'Place the API Call Name here within the parenthesis.
    '*************************************************************************************************************
    'Place Token Value Here Below!
    TokenValue = "TOKEN GOES HERE Like ujhuhuaeuyaeyayuo8i"
    '*************************************************************************************************************
    doc.Load "C:\Users\Station\Documents\Access XML Save Files\uploadFile.xml" 'Document Location of the XML File With Items Being Added
   
   
    '*************************************************************************************************************
    'Set The Headers Up!
    

Open in new window

0
Hi,

what is the difference between remote vs local ejb. When to use which one and advantages, disadvantages, practical uses of each.

I am trying below example and author choose remote here which is not clear
http://www.ejbtutorial.com/j2ee/hello-word-tutorial-for-writing-stateless-session-enterprise-java-bean-ejb
As given below i created java project to access above ejb as jar

i included above ejb jar in build path i still get compilation error while recognizing Addition class and AdditionRemote interface as attached.

please advise on how to fix i9tremoteplease advise
build.png
0

There is also helpful tutorials on BlazeMeter.com for JMeter, you don't have to use BlazeMeter but they do allow you to import your JMeter .jmx file and run tests if that is a route you want to go.

I am reading as above. I wonder what are difference between JMeter Vs BlazeMeter, advantages, disadvantages, practical uses.Please advise
0
Hi,

I am going through below link

http://www.oracle.com/webfolder/technetwork/jsc/xml/ns/javaee/index.html

I was not clear on DTDs and Java version relationship and which one to use in WEB.XML.

Please advise
0
I am trying to debug a permissions problem with a web API I am using.

Two of the rules are here...

-  The batch upload and download processes must be initiated from the machine on which the
Class 1 digital certificate resides. The batch XML document cannot be authenticated if the
upload is not initiated from the machine on which the certificate resides.

- A Class 1 digital certificate must be used utilizing at least 128 bit encryption.


There are rules (about 20)  to use the API and I am wondering if there is a way to create some sort of visual model of them. I can see interesting things that might be useful in tracing the next required step, based on a database of prior events.

IO am thinking about some sort of AI system that tracks the next step based on what other steps have been performed by other registered developers.

 hope to see if there has been this need beforehand and if some tool existed already, or hear suggestions.
0
Hello

I would like to learn more about API's.

I understand there are REST API's, SOAP, web services, GRAPH API's etc.

CONFUSED!

1. What is the difference between an API and a web service

2. What is the difference between REST and SOAP

3. Where would one use REST and one use SOAP and one use Web Services

4. Anything else useful ;-)

Can someone explain in layman's terms or point me in the right direction?
0
Hi,

I am going through below link
https://www.ibm.com/developerworks/library/ws-whichwsdl.
which wsdl binding style to use which time. i wonder which wsdl element wraps all operations?
 Please advise
0
SRCarrierInfo.CarrierAgentActInfoServiceClient cgsClient = new SRCarrierInfo.CarrierAgentActInfoServiceClient();
cgsClient.GetCarrierWebsiteInformation(); //this is custom class library it will be returned. The name is likes: List<Domain.Carrier>


how can i expose my class library to the public? I use DNN 8 as client to call above object. and I can not reference my custom class library inside of DNN module project.
0
We are reviewing options for deploying Cross Forest, Users and Computers Certificate Auto-Enrollment.  
Which method is preferred over the other?  What are the Pro / Cons between the two options.  We are leaning towards the Web Services method as it appears to be the modern architecture for future proofing our design.
0
Hi,

I am new to jmeter. How to use it. What all different uses of jmeter. How to do soap web services testing using jmeter. please advise
0
I have  a method which insert record into the database using entity framework.
 We are build a Soap based web services. I would like to know how we are going to test
this web service as  project object  as a parameter. Any tool or any way to do that.


public IHttpActionResult PostProject(ProjectDTO project)
        {
            if (!ModelState.IsValid)
            {
                return BadRequest(ModelState);
            }

            Project entity = new Project()
            {
                ProjectNumber = project.ProjectNumber,
                ProjectDescription = project.ProjectDescription,
                CreateDate = DateTime.Now,
                CreateUser = project.CreateUser,
                Latitude = project.Latitude,
                Longitude = project.Longitude,
                ProjectStatus = project.ProjectStatus,
                HoursPerShift = project.HoursPerShift,
                TimeZone = project.TimeZone,
                StandByWBSElementNumber = project.StandByWBSElementNumber,
            };

            db.Projects.Add(entity);

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateException)
            {
                if (ProjectExists(project.ProjectNumber))
                {
                    return Conflict();
                }
                else
                {
                    throw;
                }
            }

Open in new window

0
I am programming a gateway for the current website I am working on .

The callback posting from the gateway requires a web service query to eliminate man in the middle attacks.

When the call back is posted, the following information is sent

$gtpay_tranx_id = $_POST['gtpay_tranx_id']//Transaction id
$gtpay_tranx_status_code = $_POST['gtpay_tranx_status_code']//'==> 00
$gtpay_tranx_curr = $_POST['gtpay_tranx_curr']//'==> NGN
$gtpay_tranx_status_msg = $_POST['gtpay_tranx_status_msg']//'==> Approved by Financial Institution
$gtpay_tranx_amt = $_POST['gtpay_tranx_amt']//'==> 140000.00
$gtpay_cust_id = $_POST['gtpay_cust_id']//'==> destiny@icecoolcontracts.mx
$gtpay_echo_data = $_POST['gtpay_echo_data']//'==> Transaction ID:AS20170222150106;ClientName: Destiny Amana [Icecool Contracts Limited]: Purchase of Basic Plus
$site_redirect_url = $_POST['site_redirect_url']//'==> /gtpayresponse.asp
$gtpay_gway_name = $_POST['gtpay_gway_name']//'==> webpay
$gtpay_tranx_hash = $_POST['gtpay_tranx_hash']//'==> CDFB59FDBCE4DCCC7A1348EFF165AC2AA1438356FE042D0DCD5F39DD4DF3F7F4C79BDCF586B858626748CCD0D79B6A39D9A1532949FA5FB7C4E4CBAD3774D335
$gtpay_verification_hash = $_POST['gtpay_verification_hash']//'==> 7CBC424420E73377B6BB1B93979CED3D2A7C53576B13EC61B8F271CCF0025B1EFB4553592382559667560D8FCD3405FA2DC53AF18B6938AE55A67F37AB11F1F1
$gtpay_full_verification_hash = $_POST['gtpay_full_verification_hash']//'==> …
0
I am trying to access an online CRM 2016 organization to create a report using Visual Studio 2012.  The format I used in CRM 2015 (https://apolloconsulting.api.crm.dynamics.com/XRMServices/2011/Organization.svc) apparently has changed:

I found a post that discusses this but I am still not able to access to the organization.  

I need someone to make me smarter on how to access an CRM 2016 using the organization service.

Thanks
0
Hi experts,

I have an asmx webservice built in c# and dot net 3.5.It is getting called by three different clients.For one client, one of the methods need to have an additional parameter added.And i need to achieve this without breaking the method call for other two clients.
What is the best way to do this?If an example can be given it would be great.

Thanks,
0
I get the following exception:

Server Error in '/' Application.

The type 'MyDomain.ServiceTier.APX.SalesForceService.SalesForceService', provided as the Service attribute value in the ServiceHost directive, or provided in the configuration element system.serviceModel/serviceHostingEnvironment/serviceActivations could not be found.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: The type 'MyDomain.ServiceTier.APX.SalesForceService.SalesForceService', provided as the Service attribute value in the ServiceHost directive, or provided in the configuration element system.serviceModel/serviceHostingEnvironment/serviceActivations could not be found.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[InvalidOperationException: The type 'MyDomain.ServiceTier.APX.SalesForceService.SalesForceService', provided as the Service attribute value in the ServiceHost directive, or provided in the configuration element system.serviceModel/serviceHostingEnvironment/serviceActivations could not be found.]
   System.ServiceModel.Activation.ServiceHostFactory.CreateServiceHost(String …
0
Morning, EE!

I've got an interview this morning and the potential employer describes the contract to my recruiter like this:

SQL injection remediation
Retrofit for existing web services
PDO Library
Almost entirely backend
Front end is JavaScript

I want to bounce off, whoever is willing to contribute this am, my thoughts and ask for any additional things that you might see which would constitute a healthy addition to the conversation.

First off, Prepared Statements - being able to prevent SQL Injection by running your SQL w/o any data attached to it and binding your incoming criteria using positional or named placeholders.

Asking about their current database configuration. There's a lot of .NET mentioned, so I'm assuming they're using a SQL database. Do they have some Stored Procedures in place? Is there an approach that allows for a "retrofit" that accommodates already existing code / infrastructure so you're not having to reinvent the wheel?

I know enough about PDO to appreciate the Database Abstraction Layer and the Prepared Statements, but what else would I want to be sensitive to, given the job description, as far as what they mention in terms of "retrofitting?"

The phrase "web services" was mentioned. I don't know if that's a generic term to describe already existing web structure or they're referring to an API that's communicating via XML (https://www.tutorialspoint.com/webservices/what_are_web_services.htm). What kind of situation would that …
0
I need to launch a service at localhost. How?

Do I need an external program or what is the one with VS?
0
We have created a stored procedure and it is sitting on the db server.  We have tested the server locally and against the server directly using the same data as we are sending in the API and the data loads correctly.  When we use the API nothing is being loaded.  Our parameter in the SP is a XML parameter.  We are not getting any errors returned.  We have try and catches, begins and ends in the SP and it's getting to the return without issue.  But like I said nothing is being loaded.  Are we missing something?
singlerow.txt
0
We have server with windows 2008 R2 and IIs. We have 2 problems.

1.-If we call a domain from outside like http://www.domain.com works but if we call like https://www.domain.com 
To try to fix the problem we tried this command:

netsh firewall set portopening TCP 443 “SSL

Open in new window


Then we checked the rule "SSL" and "World Wide Web Services (HTTPS Traffic-In)" enabled in the firewall and there are working in firewall Inbound rules only. But not work We tried from outside and inside the same server:

telnet 127.0.0.1 443 from same server
telnet ourIP 443 from outside and inside server
telnet ourdomain 443 from outside and inside server

Not work how can we enable that or what is required to run the pages like https?

2.-Is strange but we have a lot of pages in IIs pointing to binding 80 and if we try to access that page from same server calling from browse website or trying directly on any browser we have the results:

This site can’t be reached www.ourdmain.com server DNS address could not be found.

If we try to access the site like point one with HTTP from outside the server in other words from Internet works of course HHTPS not work from outside like point 1. Byt what could be the problem that specific this domain not work from inside the server? The strange is we have a lot of more domains and is just specific that domain only. What we did a week ago was install Active Directory and we created just a Forward Zone calling exactly like the domain but …
0
Hi Experts,

I want to build a webservice that :
1) get the url of a site 'n'  to spider
2) download the JSON to parse
3) parse the JSON and update MySQL
4) write log "OK" or "KO"
4) jump to Site 'n+1'
5) etc...

Sites 'n' are stored in a table

If site n has erreor, jump to site n+1, etc...

I am really new to this... it's the first time i develop a webservice

My Database is MySQL, the code can be in VB.net or in PHP

Can someone please help me to achieve this project.
0
I asked this as a group discussion in the Access TA and only got one response, so I'l putting it out as a question.

I'm looking at a couple of different Windows Hosting providers to host a couple of servers for a client.   One would be a domain controller, another a TS Server, and potentially a 3rd for File sharing.   Right now, they have an Access app that is JET/ACE based, and the TS Server will host the Back Ends for that as well as the Front Ends for each user.

Main concerns of course are up-time and security.  Cost is a factor, but not the critical thing.    So far, I've been looking at:

Rackspace
Liquid Web
Infinitely Virtual
In Motion
ID Zoom

  Are there any others out there that I should be looking at?   Any experience with any of the above?   I'm not looking so much for details, but just a general "yes, and I've never had a problem".   or "forget it!"

 I have limited experience in this area (namely Infinitely Virtual who has been pretty good overall) as 95% of my clients are on-prem still.  So I'm looking for some basic input of who's used what with Access and any good/bad experiences.

Jim.
0
Hi Expert Team,
We have problem with our web site. Web site is on IIS WSS 3.0 and there is web interface with SAP. A web service ( using SOAP) return Base64String, but if after 100 s there is not respond - web site display blank page.
I made this test:
-Within SOAPUI  I  submitted a request to same endpoint URL. SOAP UI return time out. Than I set In SOAPUI -> Preferences -> HTTP Settings -> Socket Timeout  to 360000 ms.  After this set the web service return Base64 String in SOAPUI. Fine!
- I decided to set execution time out in IIS Manager. I made this changes:
        * In web.config  of webservice site ( Application pool) i have made replace:
Existing line
<httpRuntime maxRequestLength=”51200″ />
Replacement line
<httpRuntime executionTimeout=”999999″ maxRequestLength=”51200″ />

In same file set:
 <compilation
   debug="false"
../>
 *  In  IIS i have increased  Connection Limits -> connection time-out from 120 to 360 s

But it is not enough. The site returns again blank page after time of 100 s.

We have 2 web servers in load balancing. I have made test to load web site from a one web server and call the web service - but the result is the same - blank page after 100 s

Please Help me to resolve this issue!

Thanks in advance!
0
Hi Experts,

In my RPG program I have the following parameters:
     DCL-PI *N;                  
       INPUT llikeDs(tmpl001);      
       OUTPUT likeDs(resp);
     end-pi;                    

The OUTPUT parm has 2 fields in the structure:
Dcl-ds Resp qualified;
  Number Char(15);
  Error Char(128);    
End-ds;              

On this moment both elements will be shown in the XML response
 <OUTPUT>
               <ERROR/>
               <NUMBER>12345</NUMBER>
</OUTPUT>

I like to skip the <ERRROR> element when it's not used, how to do that?
0
I have the following function to retrieve an xml string from a web service (which works fine).
Does anyone know how to do the c# equivalent - new to c# and stuck!!

Public Function apwGetCHS() As String
        Dim serviceURL As String = "https://mywebsite.com/provider/proxy/caseExport/"
        Dim paramsSB As New StringBuilder
        Dim ReturnString As String = ""

        'create the parameterised string for the URL
        paramsSB.Append("CHSUserName=myusername")
        paramsSB.Append("&CHSOrganisationID=org")
        paramsSB.Append("&CHSPassword=password")
        paramsSB.Append("&CHSCRN=crn")

        Dim params As String = paramsSB.ToString

        Dim xmldoc As Object
        Dim oxmlHttp As Object

        oxmlHttp = CreateObject("WinHttp.WinHttpRequest.5.1")
        oxmlHttp.Open("POST", serviceURL, False)
        oxmlHttp.setRequestHeader("Content-Type", "application/x-www-form-urlencoded")
        oxmlHttp.send(params)


        'msgbox "ok"
        If oxmlHttp.status = 200 Then

            '     icmd = "alert('" & oxmlHTTP.statusText & "')"
            '     
            xmldoc = CreateObject("Microsoft.XMLDOM")
            xmldoc.loadXML(oxmlHttp.responseText)
            Try
                If FilePath(23) = "" Then
                Else
                    xmldoc.Save("testxml.xml")
                End If
            Catch ex As Exception

            End Try

        Else
            'log the error
        End If

        Return ReturnString

Open in new window

0

Web Services

A Web service is a method of communication between two electronic devices over a network. It is a software function provided at a network address over the Web with the service always on as in the concept of utility computing. A web service has an interface described in Web Services Description Language (WSDL). Other systems interact with the Web service in a manner prescribed by its description using SOAP (Simple Object Access Protocol) messages. There are two major classes of Web services: REST-compliant web services, and Arbitrary web services.

Top Experts In
Web Services
<
Monthly
>