Re: Web Service Get Operation
Lyle, Thank you for this information. I will pass it along and see what happens. Regards, Roger Nall Manager, SA Remedy Desk Phone: 972-464-3712 Mobile: 973-652-6723 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: Thursday, September 24, 2009 10:49 PM To: arslist@ARSLIST.ORG Subject: Re: Web Service Get Operation That depends on how he's calling the web service in .NET. He's probably getting back an array, an ArrayList (or something equivalent), or he's working with the XML directly (less likely). In any of those scenarios, it should be trivial to determine how many records are returned. An array and an ArrayList (or equivalent) have properties that will tell you how many records are in the list. Even if an Enumerator is returned, you don't actually need to know how many elements are in the list to process them. You just keep looping until the Enumerator gets to the end of the list. Find out how he's calling the web service and what data type is being returned from the web service call. That will help answer the question. Lyle -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Nall, Roger Sent: Thursday, September 24, 2009 9:04 PM To: arslist@ARSLIST.ORG Subject: Re: Web Service Get Operation Fred, Thanks for this information. I have received a question from the .NET developer that I am unable to answer. If anyone can give me a hand with this I would appreciate it. Hi Roger, How would I loop through all the values? It doesn't give me the count of records it's returning. I need this to loop through all the values. Thanks, Rajal -Original Message- From: Nall, Roger Sent: Thursday, September 24, 2009 12:17 PM To: Verma, Vikas; Patel, Rajal Cc: Armstrong, Sandra Subject: FW: Web Service Get Operation Vikas/Rajal, I have modified the web service. There is a new operation called OpGetList and OpGetListResponse. I think you will see what you need now. Vikas, Here is some more information. It looks like I can do what you were asking for with regards to the Get List option. Now all I have to do is figure out how this is done in Remedy. As for the Create and Set you will need to invoke the web service for each record. I will get back to both of you later. Roger Nall Manager, SA Remedy Desk Phone: 972-464-3712 Mobile: 973-652-6723 Roger Nall Manager, SA Remedy Desk Phone: 972-464-3712 Mobile: 973-652-6723 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Wednesday, September 23, 2009 5:16 PM To: arslist@ARSLIST.ORG Subject: Re: Web Service Get Operation Questions in order (almost)... Yes the Create operation will have to be called for each individual record they want to create. The difference between Get and Get List is Get returns 1 record and Get List returns a set of records. You will want to use a Get List to return the list of records for a qualification. I recommend you structure your result in the following manner: Root Grouping Element (whatever you want to call it) Field 1 Field 2 Field 3 Field 4 Field 5 Field 6 Field 7 Map the form to the Grouping Element instead of Root and set the MaxOccurs to unbounded. The reason for the Grouping Element is that you can only have 1 Root element in an XML so this way you will return multiple rows. Yes the Set operation will have to be called for each individual record they want to create. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Nall, Roger Sent: Wednesday, September 23, 2009 4:43 PM To: arslist@ARSLIST.ORG Subject: Web Service Get Operation ** Hello All, ARS 7.1 patch4 Win2003 SQL2000 I have created a web service for another system to consume. There are three operations in the web service; Create, Set, Get. This web service will be called from a .net web page. Users can create on or many records at a time from the web page. Can I assume that the web service will have to be called for each record? When using the Get operation users will need to get list of records that are assigned to them. I have created one element in the Input for the Get. This element I have called Qualification. The web site will pass me the User Name and Password of the user and the qualification i.e.; 'Assigned To' = "user". There are seven fields in the output of the Get operation. The developer on the .net side is having trouble getting the data back. He seems to think he will need to call the web service seven times for each record that exists. He bases this on the fact that when he tried to use the web service to retrieve
Re: Web Service Get Operation
That depends on how he's calling the web service in .NET. He's probably getting back an array, an ArrayList (or something equivalent), or he's working with the XML directly (less likely). In any of those scenarios, it should be trivial to determine how many records are returned. An array and an ArrayList (or equivalent) have properties that will tell you how many records are in the list. Even if an Enumerator is returned, you don't actually need to know how many elements are in the list to process them. You just keep looping until the Enumerator gets to the end of the list. Find out how he's calling the web service and what data type is being returned from the web service call. That will help answer the question. Lyle -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Nall, Roger Sent: Thursday, September 24, 2009 9:04 PM To: arslist@ARSLIST.ORG Subject: Re: Web Service Get Operation Fred, Thanks for this information. I have received a question from the .NET developer that I am unable to answer. If anyone can give me a hand with this I would appreciate it. Hi Roger, How would I loop through all the values? It doesn't give me the count of records it's returning. I need this to loop through all the values. Thanks, Rajal -Original Message- From: Nall, Roger Sent: Thursday, September 24, 2009 12:17 PM To: Verma, Vikas; Patel, Rajal Cc: Armstrong, Sandra Subject: FW: Web Service Get Operation Vikas/Rajal, I have modified the web service. There is a new operation called OpGetList and OpGetListResponse. I think you will see what you need now. Vikas, Here is some more information. It looks like I can do what you were asking for with regards to the Get List option. Now all I have to do is figure out how this is done in Remedy. As for the Create and Set you will need to invoke the web service for each record. I will get back to both of you later. Roger Nall Manager, SA Remedy Desk Phone: 972-464-3712 Mobile: 973-652-6723 Roger Nall Manager, SA Remedy Desk Phone: 972-464-3712 Mobile: 973-652-6723 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Wednesday, September 23, 2009 5:16 PM To: arslist@ARSLIST.ORG Subject: Re: Web Service Get Operation Questions in order (almost)... Yes the Create operation will have to be called for each individual record they want to create. The difference between Get and Get List is Get returns 1 record and Get List returns a set of records. You will want to use a Get List to return the list of records for a qualification. I recommend you structure your result in the following manner: Root Grouping Element (whatever you want to call it) Field 1 Field 2 Field 3 Field 4 Field 5 Field 6 Field 7 Map the form to the Grouping Element instead of Root and set the MaxOccurs to unbounded. The reason for the Grouping Element is that you can only have 1 Root element in an XML so this way you will return multiple rows. Yes the Set operation will have to be called for each individual record they want to create. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Nall, Roger Sent: Wednesday, September 23, 2009 4:43 PM To: arslist@ARSLIST.ORG Subject: Web Service Get Operation ** Hello All, ARS 7.1 patch4 Win2003 SQL2000 I have created a web service for another system to consume. There are three operations in the web service; Create, Set, Get. This web service will be called from a .net web page. Users can create on or many records at a time from the web page. Can I assume that the web service will have to be called for each record? When using the Get operation users will need to get list of records that are assigned to them. I have created one element in the Input for the Get. This element I have called Qualification. The web site will pass me the User Name and Password of the user and the qualification i.e.; 'Assigned To' = "user". There are seven fields in the output of the Get operation. The developer on the .net side is having trouble getting the data back. He seems to think he will need to call the web service seven times for each record that exists. He bases this on the fact that when he tried to use the web service to retrieve one record he only saw the first column in the output. He has asked me if there is any way to pass all of the data in one record in one element in the web service. As I am not that familiar with this technology so I am not sure how to answer him. When using the Set operation they will be 'approving' several records at a time from a web site. Again, I assume they will have to call the web serv
Re: Web Service Get Operation
Fred, Thanks for this information. I have received a question from the .NET developer that I am unable to answer. If anyone can give me a hand with this I would appreciate it. Hi Roger, How would I loop through all the values? It doesn't give me the count of records it's returning. I need this to loop through all the values. Thanks, Rajal -Original Message- From: Nall, Roger Sent: Thursday, September 24, 2009 12:17 PM To: Verma, Vikas; Patel, Rajal Cc: Armstrong, Sandra Subject: FW: Web Service Get Operation Vikas/Rajal, I have modified the web service. There is a new operation called OpGetList and OpGetListResponse. I think you will see what you need now. Vikas, Here is some more information. It looks like I can do what you were asking for with regards to the Get List option. Now all I have to do is figure out how this is done in Remedy. As for the Create and Set you will need to invoke the web service for each record. I will get back to both of you later. Roger Nall Manager, SA Remedy Desk Phone: 972-464-3712 Mobile: 973-652-6723 Roger Nall Manager, SA Remedy Desk Phone: 972-464-3712 Mobile: 973-652-6723 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Wednesday, September 23, 2009 5:16 PM To: arslist@ARSLIST.ORG Subject: Re: Web Service Get Operation Questions in order (almost)... Yes the Create operation will have to be called for each individual record they want to create. The difference between Get and Get List is Get returns 1 record and Get List returns a set of records. You will want to use a Get List to return the list of records for a qualification. I recommend you structure your result in the following manner: Root Grouping Element (whatever you want to call it) Field 1 Field 2 Field 3 Field 4 Field 5 Field 6 Field 7 Map the form to the Grouping Element instead of Root and set the MaxOccurs to unbounded. The reason for the Grouping Element is that you can only have 1 Root element in an XML so this way you will return multiple rows. Yes the Set operation will have to be called for each individual record they want to create. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Nall, Roger Sent: Wednesday, September 23, 2009 4:43 PM To: arslist@ARSLIST.ORG Subject: Web Service Get Operation ** Hello All, ARS 7.1 patch4 Win2003 SQL2000 I have created a web service for another system to consume. There are three operations in the web service; Create, Set, Get. This web service will be called from a .net web page. Users can create on or many records at a time from the web page. Can I assume that the web service will have to be called for each record? When using the Get operation users will need to get list of records that are assigned to them. I have created one element in the Input for the Get. This element I have called Qualification. The web site will pass me the User Name and Password of the user and the qualification i.e.; 'Assigned To' = "user". There are seven fields in the output of the Get operation. The developer on the .net side is having trouble getting the data back. He seems to think he will need to call the web service seven times for each record that exists. He bases this on the fact that when he tried to use the web service to retrieve one record he only saw the first column in the output. He has asked me if there is any way to pass all of the data in one record in one element in the web service. As I am not that familiar with this technology so I am not sure how to answer him. When using the Set operation they will be 'approving' several records at a time from a web site. Again, I assume they will have to call the web service for each record. Finally, can someone explain the difference between the Get and Get List operation? Thanks in advanced for any help. Regards, Roger Nall Manager, SA Remedy Desk Phone: 972-464-3712 Mobile: 973-652-6723 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Web Service Get Operation
Still I would recomend using a layer in between -- Jarl 2009/9/24 Nall, Roger : > Thanks for the information. This is an integration with a custom application > in Remedy. > > Roger Nall > Manager, SA Remedy > Desk Phone: 972-464-3712 > Mobile: 973-652-6723 > > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of Subash Biswas > Sent: Thursday, September 24, 2009 9:27 AM > To: arslist@ARSLIST.ORG > Subject: Re: Web Service Get Operation > > Roger: > Are you implementing the web service on top of HPD, CHG, AST..? If yes > I would recommend using an intermediate layer in between; like a temp > table that your external client (.NET web page) has access to. > One time a bug in external (consumer) code generated over 3K entries > in the temp table in a day; all of which were ignored and not pushed > over to the parent Change Control Module.You can build all kinds of > validations on the temp table to restrict parent updates. In our case > the temp table doubles up for the Change & Asset modules. Get & > GetList methods can also be implemented on the same temp table > provided the output mapping is a small set of fields. > > -Subash > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Web Service Get Operation
Thanks for the information. This is an integration with a custom application in Remedy. Roger Nall Manager, SA Remedy Desk Phone: 972-464-3712 Mobile: 973-652-6723 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Subash Biswas Sent: Thursday, September 24, 2009 9:27 AM To: arslist@ARSLIST.ORG Subject: Re: Web Service Get Operation Roger: Are you implementing the web service on top of HPD, CHG, AST..? If yes I would recommend using an intermediate layer in between; like a temp table that your external client (.NET web page) has access to. One time a bug in external (consumer) code generated over 3K entries in the temp table in a day; all of which were ignored and not pushed over to the parent Change Control Module.You can build all kinds of validations on the temp table to restrict parent updates. In our case the temp table doubles up for the Change & Asset modules. Get & GetList methods can also be implemented on the same temp table provided the output mapping is a small set of fields. -Subash ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Web Service Get Operation
Roger: Are you implementing the web service on top of HPD, CHG, AST..? If yes I would recommend using an intermediate layer in between; like a temp table that your external client (.NET web page) has access to. One time a bug in external (consumer) code generated over 3K entries in the temp table in a day; all of which were ignored and not pushed over to the parent Change Control Module.You can build all kinds of validations on the temp table to restrict parent updates. In our case the temp table doubles up for the Change & Asset modules. Get & GetList methods can also be implemented on the same temp table provided the output mapping is a small set of fields. -Subash ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Web Service Get Operation
Fred, As always thank you very much. Now all I have to do is figure out how create the Get List operation. Regards, Roger Nall Manager, SA Remedy Desk Phone: 972-464-3712 Mobile: 973-652-6723 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Wednesday, September 23, 2009 5:16 PM To: arslist@ARSLIST.ORG Subject: Re: Web Service Get Operation Questions in order (almost)... Yes the Create operation will have to be called for each individual record they want to create. The difference between Get and Get List is Get returns 1 record and Get List returns a set of records. You will want to use a Get List to return the list of records for a qualification. I recommend you structure your result in the following manner: Root Grouping Element (whatever you want to call it) Field 1 Field 2 Field 3 Field 4 Field 5 Field 6 Field 7 Map the form to the Grouping Element instead of Root and set the MaxOccurs to unbounded. The reason for the Grouping Element is that you can only have 1 Root element in an XML so this way you will return multiple rows. Yes the Set operation will have to be called for each individual record they want to create. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Nall, Roger Sent: Wednesday, September 23, 2009 4:43 PM To: arslist@ARSLIST.ORG Subject: Web Service Get Operation ** Hello All, ARS 7.1 patch4 Win2003 SQL2000 I have created a web service for another system to consume. There are three operations in the web service; Create, Set, Get. This web service will be called from a .net web page. Users can create on or many records at a time from the web page. Can I assume that the web service will have to be called for each record? When using the Get operation users will need to get list of records that are assigned to them. I have created one element in the Input for the Get. This element I have called Qualification. The web site will pass me the User Name and Password of the user and the qualification i.e.; 'Assigned To' = "user". There are seven fields in the output of the Get operation. The developer on the .net side is having trouble getting the data back. He seems to think he will need to call the web service seven times for each record that exists. He bases this on the fact that when he tried to use the web service to retrieve one record he only saw the first column in the output. He has asked me if there is any way to pass all of the data in one record in one element in the web service. As I am not that familiar with this technology so I am not sure how to answer him. When using the Set operation they will be 'approving' several records at a time from a web site. Again, I assume they will have to call the web service for each record. Finally, can someone explain the difference between the Get and Get List operation? Thanks in advanced for any help. Regards, Roger Nall Manager, SA Remedy Desk Phone: 972-464-3712 Mobile: 973-652-6723 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Web Service Get Operation
Questions in order (almost)... Yes the Create operation will have to be called for each individual record they want to create. The difference between Get and Get List is Get returns 1 record and Get List returns a set of records. You will want to use a Get List to return the list of records for a qualification. I recommend you structure your result in the following manner: Root Grouping Element (whatever you want to call it) Field 1 Field 2 Field 3 Field 4 Field 5 Field 6 Field 7 Map the form to the Grouping Element instead of Root and set the MaxOccurs to unbounded. The reason for the Grouping Element is that you can only have 1 Root element in an XML so this way you will return multiple rows. Yes the Set operation will have to be called for each individual record they want to create. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Nall, Roger Sent: Wednesday, September 23, 2009 4:43 PM To: arslist@ARSLIST.ORG Subject: Web Service Get Operation ** Hello All, ARS 7.1 patch4 Win2003 SQL2000 I have created a web service for another system to consume. There are three operations in the web service; Create, Set, Get. This web service will be called from a .net web page. Users can create on or many records at a time from the web page. Can I assume that the web service will have to be called for each record? When using the Get operation users will need to get list of records that are assigned to them. I have created one element in the Input for the Get. This element I have called Qualification. The web site will pass me the User Name and Password of the user and the qualification i.e.; 'Assigned To' = "user". There are seven fields in the output of the Get operation. The developer on the .net side is having trouble getting the data back. He seems to think he will need to call the web service seven times for each record that exists. He bases this on the fact that when he tried to use the web service to retrieve one record he only saw the first column in the output. He has asked me if there is any way to pass all of the data in one record in one element in the web service. As I am not that familiar with this technology so I am not sure how to answer him. When using the Set operation they will be 'approving' several records at a time from a web site. Again, I assume they will have to call the web service for each record. Finally, can someone explain the difference between the Get and Get List operation? Thanks in advanced for any help. Regards, Roger Nall Manager, SA Remedy Desk Phone: 972-464-3712 Mobile: 973-652-6723 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Web Service Get Operation
Hello All, ARS 7.1 patch4 Win2003 SQL2000 I have created a web service for another system to consume. There are three operations in the web service; Create, Set, Get. This web service will be called from a .net web page. Users can create on or many records at a time from the web page. Can I assume that the web service will have to be called for each record? When using the Get operation users will need to get list of records that are assigned to them. I have created one element in the Input for the Get. This element I have called Qualification. The web site will pass me the User Name and Password of the user and the qualification i.e.; 'Assigned To' = "user". There are seven fields in the output of the Get operation. The developer on the .net side is having trouble getting the data back. He seems to think he will need to call the web service seven times for each record that exists. He bases this on the fact that when he tried to use the web service to retrieve one record he only saw the first column in the output. He has asked me if there is any way to pass all of the data in one record in one element in the web service. As I am not that familiar with this technology so I am not sure how to answer him. When using the Set operation they will be 'approving' several records at a time from a web site. Again, I assume they will have to call the web service for each record. Finally, can someone explain the difference between the Get and Get List operation? Thanks in advanced for any help. Regards, Roger Nall Manager, SA Remedy Desk Phone: 972-464-3712 Mobile: 973-652-6723 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"