consuming a webservice

Interestingly enough - if you use argumentcollection="#URL#" and you
have too many arguments - it throws an error. So I must use <cfargument
and only pass on argument.

too bad - it would seem to be easier to pass all the urls vars and let
the cfc sort them out. But hey - less server tug this way I guess.

Chris

Chris Luksha wrote:
> I am attempting to create a webservice from one site to be consumed by
> another site. I have gone through various webservices tuts in the
> distant past but I am stuck on this one.
>
> On server A I have the following CFC...
>
> <cfcomponent hint="Returns minimal member data for consumption">
>
> <cffunction name="getMembersbyState" access="public"
> returntype="query" hint="Members by State" description="FInd and return
> member listing by state">
> <cfargument name="state" required="yes" default="">
> <cfset var rsGetResults="">
> <cfquery name="rsGetMembers" datasource="#request.dsn#"
> username="#request.dsnusrnm#" password="#request.dsnpwd#" >
> SELECT member_id, city as member_City, company_name as
> member_Name, dba_name as member_DBA
> FROM members_tbl
> WHERE Active = 1
> AND state = '#argument.state#'
> ORDER BY company_name
> </cfquery>
> <cfreturn rsGetMembers>
> </cffunction>
> </cfcomponent>
>
> Now simply browsing to this page on my local server results in the cfc
> description details. Browsing to in on the server - results in the
> following error...
>
> Could not import the tag library specified by "../administrator/cftags/".
> The following error was encountered:
> D:\inetpub\wwwroot-ct\CFIDE\componentutils\..\administrator\cftags.
> Please ensure that you have specified a valid tag library.
>
> The CFML compiler was processing:
>
> * a cfimport tag beginning on line 3, column 2.
>
>
> The error occurred in
> D:\inetpub\wwwroot-ct\CFIDE\componentutils\login.cfm: line 3
> Called from D:\inetpub\wwwroot-ct\CFIDE\componentutils\Application.cfm:
> line 55
> Called from D:\inetpub\wwwroot-ct\CFIDE\componentutils\Application.cfm:
> line 55
>
> 1 : <cfsilent>
> 2 : <!--- Import L10N Taglib (System Generated) --->
> 3 : <cfimport prefix="admin" taglib="../administrator/cftags/">
> 4 :
> 5 : <!--- Establish page locale, default is english (en). --->
>
>
> Does anyone have any pointers? PLEASE.
>
> I have attempted to map the custom tag path to my cfc folder in the site
> - via the system control panel. ( Using Crystaltech as host)
> Should I be creating a diff. mapping of some kind? I can add a mapping
> instead of a custom tag path but I have never done this thing before so
> I completely lost.
>
> Thanks so much.
> Chris

--
Chris Luksha
Echo Web Services
Making Your Website Resound
603-831-0099
http://www.echowebservices.com/

CAN-SPAM Compliant Email Newsletters - only $.05 per Subscriber
http://www.echowebservices.com/email

<cfinvoke webservice=" http://www.femsa.org/cfc/getMembers.cfc?wsdl"
method="getMembersByState"
returnvariable="rsGetMembers">
<cfinvokeargument name="state" value="#url.state#"/>
</cfinvoke>

<cfinvoke webservice=" http://www.femsa.org/cfc/getMembers.cfc?wsdl"
method="getMembersByState" argumentcollection="#URL#"
returnvariable="rsGetMembers">
</cfinvoke>

Well both of these worked for me, I now have a query of all your IL members.

Ok it finally works... http://firegrantdata.com/consumefemsa.cfm?state=il

will get me the data. Thank you all for the great help. Sorry if I was
being so ignorant the whole time. as it turns out Ian - thank you - AL
returned a blank page simply b/c there was no data to return. Duh!

Thanks Tim as well. I never really knew how to test the cfc directly -
correctly. Now I do.

Thanks so much guys for your patience. (groveling :) Now to embed that
in my brain so I can learn something else this afternoon.

Chris

cecropin wrote:
> Chris,
>
> I apologize. I must have been a bit sleepy yesterday when I answered this
> question. There are a couple of things going on. The first is that your
> webservice component is working just fine at this time. I'll get back to that
> in a second.
>
> When you use the URL http://www.femsa.org/cfc/getMembers.cfc, it in turn
> redirects you to
> http://www.femsa.org/CFIDE/componentutils/cfcexplorer.cfc?method=getcfcinhtml&na
> me=cfc.getMembers&path=/cfc/getMembers.cfc
> which is where you're really getting the error message. What's happening here
> is that you are actually invoking an out of the box CF application with
> inspects your CFC. The error that you're getting is because CF is unable to
> find the directory D:\inetpub\wwwroot-ct\CFIDE\administrator\cftags. I think
> CFIDE is a virtual directory and either the security settings are so tight that
> the service account running ColdFusion cannot access the administrator/cftags
> directory or there's something wrong w/ the install. For instance I was able
> to locate this resource http://www.femsa.org/CFIDE/images/required.gif, but not
> http://www.femsa.org/CFIDE/administrator/aboutcf.cfm or
> http://www.femsa.org/CFIDE/administrator/cfadmin.css
>
> Getting back to the webservice you should test it like so
> http://www.femsa.org/cfc/getMembers.cfc?method=firstws and
> http://www.femsa.org/cfc/getMembers.cfc?method=members.
>
> The global error handler in your app is not executing, because application.cfm
> from D:\inetpub\wwwroot-ct\CFIDE\componentutils\Application.cfm is being
> executed and that doesn't have an error handler.
>
> Does this make sense so far? At this point it's either a permissions or
> install issue happening when you try to inspect your CFC, but I think this is
> besides the point, because your original question was about your
> getMembersByState webservice. Can you put that function back in and then use
> a method call like
> http://www.femsa.org/cfc/getMembers.cfc?method=getMembersByState&state=IL or
> whatever is appropriate for your service.
>
> Looking at your original code. I only see 2 issues, 1 the access must be
> remote. This was pointed out, and 2 you must use the "arguments" scope w/ an s
> at the end not "argument".
>
> Hope this helps.
>
> -Tim
>

--
Chris Luksha
Echo Web Services
Making Your Website Resound
603-831-0099
http://www.echowebservices.com/

CAN-SPAM Compliant Email Newsletters - only $.05 per Subscriber
http://www.echowebservices.com/email

Hi Ian,

Well I simply asked CT to do it and they did so. So now I simply get
Web service operation "getMembersByState" with parameters {STATE=al}
could not be found.

The page I am running it from is this ...

http://firegrantdata.com/consumefemsa.cfm?state=al

I used the argumentcollection="#URL#" instead of the cfarguments at this
time.

Chris

Ian Skinner wrote:
> Is there a way to force this w/o access to the server? I can ask
> crystaltech to do it for me but I don't have a dedicated server - yet so
> I can't do it myslef.
>
>
> I think there is an undocumented feature to do this through the service
> factory, but I don't know the details.
>
> You can also create a new "web service" by changing the url profile of
> the service. Change some part of this string
> " http://www.femsa.org/cfc/getMembers.cfc?wsdl" and you have a
> "different" web service. I.E. if you change your webservice to
> getMembers2.cfc would be a new web service.

--
Chris Luksha
Echo Web Services
Making Your Website Resound
603-831-0099
http://www.echowebservices.com/

CAN-SPAM Compliant Email Newsletters - only $.05 per Subscriber
http://www.echowebservices.com/email

Is there a way to force this w/o access to the server? I can ask
crystaltech to do it for me but I don't have a dedicated server - yet so
I can't do it myslef.


I think there is an undocumented feature to do this through the service
factory, but I don't know the details.

You can also create a new "web service" by changing the url profile of
the service. Change some part of this string
" http://www.femsa.org/cfc/getMembers.cfc?wsdl" and you have a
"different" web service. I.E. if you change your webservice to
getMembers2.cfc would be a new web service.

Is there a way to force this w/o access to the server? I can ask
crystaltech to do it for me but I don't have a dedicated server - yet so
I can't do it myslef.

Ian Skinner wrote:
> <cfinvoke webservice=" http://www.femsa.org/cfc/getMembers.cfc?wsdl"
> method="getMembersByState"
> returnvariable="rsGetMembers">
> <cfinvokeargument name="state" value="al"/>
> </cfinvoke>
>
>
>
> I just ran this code from my system and I did not get an error, I got an
> empty query. I think your web service is working correctly. I suspect
> you are having difficulty consuming it do to caching issues.
>
> When CF consumes a web service it create a stub that maps the web
> service and it's functions. If the profile of the web service is
> changed, this stub needs to be refreshed.
>
> Go to the Web Services section of the CF administrator under the Data &
> Services section. Delete any Active ColdFusion Web Services that refers
> to this web service url. That should force CF to refresh the stub the
> next time the service is called.

--
Chris Luksha
Echo Web Services
Making Your Website Resound
603-831-0099
http://www.echowebservices.com/

CAN-SPAM Compliant Email Newsletters - only $.05 per Subscriber
http://www.echowebservices.com/email

<cfinvoke webservice=" http://www.femsa.org/cfc/getMembers.cfc?wsdl"
method="getMembersByState"
returnvariable="rsGetMembers">
<cfinvokeargument name="state" value="al"/>
</cfinvoke>



I just ran this code from my system and I did not get an error, I got an
empty query. I think your web service is working correctly. I suspect
you are having difficulty consuming it do to caching issues.

When CF consumes a web service it create a stub that maps the web
service and it's functions. If the profile of the web service is
changed, this stub needs to be refreshed.

Go to the Web Services section of the CF administrator under the Data &
Services section. Delete any Active ColdFusion Web Services that refers
to this web service url. That should force CF to refresh the stub the
next time the service is called.

I was getting a blank page merely b/c I had turned on error handling and
had not actual error page defined yet. I have turned it off and now I
am getting the dreaded

Web service operation "getMembersByState" with parameters {} could not
be found.

YUCK. Also I had another question - I have a basic understanding of
structures and arrays so I thought this might work as a way to call the
cfinvoke but I can't test it until I have resolved the issue above. Can
I call the function using argumentcollection="#URL#" if the state is
defined in the url? But lets worry about the first problem first right :)

Thanks again,
Chris

Chris Luksha wrote:
> Tim - Thank you so much, that at least explained to me what in the world
> I was doing wrong in testing the silly thing. So now I have put back
> the original query function to pull all the data. And using this link
> as you mentioned
> http://www.femsa.org/cfc/getMembers.cfc?method=getMembersByState&state=IL
> works great. You can even still call
> http://www.femsa.org/cfc/getMembers.cfc?method=members and get the silly
> little text.
>
> Now I m probably just not understanding how to call the cfc at this
> point. I thought I had it right but I am getting a blank page when
> calling the cfc from another domain via cfinvoke.
>
> Here is what I am doing...
>
> The cfc states this:
>
> <cffunction name="getMembersByState" access="remote"
> returntype="query" hint="Members by State" description="FInd and return
> member listing by state">
> <cfargument name="state" required="yes" default="">
> <cfset var rsGetMembers="">
> <cfquery name="rsGetMembers" datasource="#request.dsn#"
> username="#request.dsnusrnm#" password="#request.dsnpwd#" >
> SELECT member_id, city as member_City, company_name as
> member_Name, dba_name as member_DBA
> FROM members_tbl
> WHERE Active = 1
> AND state = '#arguments.state#'
> ORDER BY company_name
> </cfquery>
> <cfreturn rsGetMembers>
> </cffunction>
>
> The cfinvoke states this:
>
> <cfinvoke webservice=" http://www.femsa.org/cfc/getMembers.cfc?wsdl"
> method="getMembersByState"
> returnvariable="rsGetMembers">
> <cfinvokeargument name="state" value="al"/>
> </cfinvoke>
>
> <cfoutput query="rsGetMembers">
> #member_name#<br />
> </cfoutput>
>
> Now I would think this should return a list of member names - or at
> least if I used a cfdump - I would see the whole thing. But niether the
> code above, nor a cfdump results in anythin on the page.
>
> Am I missing somehting in how I call the cfc?
>
> Thanks for all the patience and help Tim,
> Chris
>
> cecropin wrote:
>
>> Chris,
>>
>> I apologize. I must have been a bit sleepy yesterday when I answered
>> this question. There are a couple of things going on. The first is
>> that your webservice component is working just fine at this time.
>> I'll get back to that in a second.
>>
>> When you use the URL http://www.femsa.org/cfc/getMembers.cfc, it in
>> turn redirects you to
>> http://www.femsa.org/CFIDE/componentutils/cfcexplorer.cfc?method=getcfcinhtml&na
>>
>> me=cfc.getMembers&path=/cfc/getMembers.cfc
>> which is where you're really getting the error message. What's
>> happening here is that you are actually invoking an out of the box CF
>> application with inspects your CFC. The error that you're getting is
>> because CF is unable to find the directory
>> D:\inetpub\wwwroot-ct\CFIDE\administrator\cftags. I think CFIDE is a
>> virtual directory and either the security settings are so tight that
>> the service account running ColdFusion cannot access the
>> administrator/cftags directory or there's something wrong w/ the
>> install. For instance I was able to locate this resource
>> http://www.femsa.org/CFIDE/images/required.gif, but not
>> http://www.femsa.org/CFIDE/administrator/aboutcf.cfm or
>> http://www.femsa.org/CFIDE/administrator/cfadmin.css
>>
>> Getting back to the webservice you should test it like so
>> http://www.femsa.org/cfc/getMembers.cfc?method=firstws and
>> http://www.femsa.org/cfc/getMembers.cfc?method=members.
>>
>> The global error handler in your app is not executing, because
>> application.cfm from
>> D:\inetpub\wwwroot-ct\CFIDE\componentutils\Application.cfm is being
>> executed and that doesn't have an error handler.
>>
>> Does this make sense so far? At this point it's either a permissions
>> or install issue happening when you try to inspect your CFC, but I
>> think this is besides the point, because your original question was
>> about your getMembersByState webservice. Can you put that function
>> back in and then use a method call like
>> http://www.femsa.org/cfc/getMembers.cfc?method=getMembersByState&state=IL
>> or whatever is appropriate for your service.
>>
>> Looking at your original code. I only see 2 issues, 1 the access must
>> be remote. This was pointed out, and 2 you must use the "arguments"
>> scope w/ an s at the end not "argument".
>>
>> Hope this helps.
>>
>> -Tim
>>
>

--
Chris Luksha
Echo Web Services
Making Your Website Resound
603-831-0099
http://www.echowebservices.com/

CAN-SPAM Compliant Email Newsletters - only $.05 per Subscriber
http://www.echowebservices.com/email

Tim - Thank you so much, that at least explained to me what in the world
I was doing wrong in testing the silly thing. So now I have put back
the original query function to pull all the data. And using this link
as you mentioned
http://www.femsa.org/cfc/getMembers.cfc?method=getMembersByState&state=IL
works great. You can even still call
http://www.femsa.org/cfc/getMembers.cfc?method=members and get the silly
little text.

Now I m probably just not understanding how to call the cfc at this
point. I thought I had it right but I am getting a blank page when
calling the cfc from another domain via cfinvoke.

Here is what I am doing...

The cfc states this:

<cffunction name="getMembersByState" access="remote" returntype="query"
hint="Members by State" description="FInd and return member listing by
state">
<cfargument name="state" required="yes" default="">
<cfset var rsGetMembers="">
<cfquery name="rsGetMembers" datasource="#request.dsn#"
username="#request.dsnusrnm#" password="#request.dsnpwd#" >
SELECT member_id, city as member_City, company_name as member_Name,
dba_name as member_DBA
FROM members_tbl
WHERE Active = 1
AND state = '#arguments.state#'
ORDER BY company_name
</cfquery>
<cfreturn rsGetMembers>
</cffunction>

The cfinvoke states this:

<cfinvoke webservice=" http://www.femsa.org/cfc/getMembers.cfc?wsdl"
method="getMembersByState"
returnvariable="rsGetMembers">
<cfinvokeargument name="state" value="al"/>
</cfinvoke>

<cfoutput query="rsGetMembers">
#member_name#<br />
</cfoutput>

Now I would think this should return a list of member names - or at
least if I used a cfdump - I would see the whole thing. But niether the
code above, nor a cfdump results in anythin on the page.

Am I missing somehting in how I call the cfc?

Thanks for all the patience and help Tim,
Chris

cecropin wrote:
> Chris,
>
> I apologize. I must have been a bit sleepy yesterday when I answered this
> question. There are a couple of things going on. The first is that your
> webservice component is working just fine at this time. I'll get back to that
> in a second.
>
> When you use the URL http://www.femsa.org/cfc/getMembers.cfc, it in turn
> redirects you to
> http://www.femsa.org/CFIDE/componentutils/cfcexplorer.cfc?method=getcfcinhtml&na
> me=cfc.getMembers&path=/cfc/getMembers.cfc
> which is where you're really getting the error message. What's happening here
> is that you are actually invoking an out of the box CF application with
> inspects your CFC. The error that you're getting is because CF is unable to
> find the directory D:\inetpub\wwwroot-ct\CFIDE\administrator\cftags. I think
> CFIDE is a virtual directory and either the security settings are so tight that
> the service account running ColdFusion cannot access the administrator/cftags
> directory or there's something wrong w/ the install. For instance I was able
> to locate this resource http://www.femsa.org/CFIDE/images/required.gif, but not
> http://www.femsa.org/CFIDE/administrator/aboutcf.cfm or
> http://www.femsa.org/CFIDE/administrator/cfadmin.css
>
> Getting back to the webservice you should test it like so
> http://www.femsa.org/cfc/getMembers.cfc?method=firstws and
> http://www.femsa.org/cfc/getMembers.cfc?method=members.
>
> The global error handler in your app is not executing, because application.cfm
> from D:\inetpub\wwwroot-ct\CFIDE\componentutils\Application.cfm is being
> executed and that doesn't have an error handler.
>
> Does this make sense so far? At this point it's either a permissions or
> install issue happening when you try to inspect your CFC, but I think this is
> besides the point, because your original question was about your
> getMembersByState webservice. Can you put that function back in and then use
> a method call like
> http://www.femsa.org/cfc/getMembers.cfc?method=getMembersByState&state=IL or
> whatever is appropriate for your service.
>
> Looking at your original code. I only see 2 issues, 1 the access must be
> remote. This was pointed out, and 2 you must use the "arguments" scope w/ an s
> at the end not "argument".
>
> Hope this helps.
>
> -Tim
>

--
Chris Luksha
Echo Web Services
Making Your Website Resound
603-831-0099
http://www.echowebservices.com/

CAN-SPAM Compliant Email Newsletters - only $.05 per Subscriber
http://www.echowebservices.com/email

Chris,

I apologize. I must have been a bit sleepy yesterday when I answered this question. There are a couple of things going on. The first is that your webservice component is working just fine at this time. I'll get back to that in a second.

When you use the URL http://www.femsa.org/cfc/getMembers.cfc, it in turn redirects you to http://www.femsa.org/CFIDE/componentutils/cfcexplorer.cfc?method=getcfcinhtml&name=cfc.getMembers&path=/cfc/getMembers.cfc
which is where you're really getting the error message. What's happening here is that you are actually invoking an out of the box CF application with inspects your CFC. The error that you're getting is because CF is unable to find the directory D:\inetpub\wwwroot-ct\CFIDE\administrator\cftags. I think CFIDE is a virtual directory and either the security settings are so tight that the service account running ColdFusion cannot access the administrator/cftags directory or there's something wrong w/ the install. For instance I was able to locate this resource http://www.femsa.org/CFIDE/images/required.gif, but not http://www.femsa.org/CFIDE/administrator/aboutcf.cfm or http://www.femsa.org/CFIDE/administrator/cfadmin.css

Getting back to the webservice you should test it like so
http://www.femsa.org/cfc/getMembers.cfc?method=firstws and http://www.femsa.org/cfc/getMembers.cfc?method=members.

The global error handler in your app is not executing, because application.cfm from D:\inetpub\wwwroot-ct\CFIDE\componentutils\Application.cfm is being executed and that doesn't have an error handler.

Does this make sense so far? At this point it's either a permissions or install issue happening when you try to inspect your CFC, but I think this is besides the point, because your original question was about your getMembersByState webservice. Can you put that function back in and then use a method call like
http://www.femsa.org/cfc/getMembers.cfc?method=getMembersByState&state=IL or whatever is appropriate for your service.

Looking at your original code. I only see 2 issues, 1 the access must be remote. This was pointed out, and 2 you must use the "arguments" scope w/ an s at the end not "argument".

Hope this helps.

-Tim