PerfectForms Forums: Forum: API

PerfectForms Forums: Forum: API - Recent Posts http://www.perfectforms.com/forums/ Forums for the PerfectForms.com Application en Sat, 04 Feb 2012 23:00:27 +0000 Dennis @ PerfectForms on "Archiving Form Instance Data" http://www.perfectforms.com/forums/topic/archiving-form-instance-data#post-2202 Thu, 02 Jun 2011 22:19:30 +0000 Dennis @ PerfectForms 2202@http://www.perfectforms.com/forums/ There is no way to transfer the name of an attachment file with the attachment unless you force the user to put in a separate field. <a href="http://www.perfectforms.com/">Workflow software, </a><a href="http://www.perfectforms.com/">Process software, </a><a href="http://www.perfectforms.com/">Procedure software</a> mbeccaria@paulsmiths.edu on "Archiving Form Instance Data" http://www.perfectforms.com/forums/topic/archiving-form-instance-data#post-2201 Thu, 02 Jun 2011 17:14:56 +0000 mbeccaria@paulsmiths.edu 2201@http://www.perfectforms.com/forums/ When making database connections using the connection agent, can you pass file attachment values in the send parameters section of the action so that I can store the files in the database? And from my previous post: Is there a way to use the methods to return the right assetID so I can use the GetAsset method to download the files I need? What are get and set asset methods supposed to be used for? Dennis @ PerfectForms on "Archiving Form Instance Data" http://www.perfectforms.com/forums/topic/archiving-form-instance-data#post-2200 Thu, 02 Jun 2011 16:28:51 +0000 Dennis @ PerfectForms 2200@http://www.perfectforms.com/forums/ Using the Connection Agent you can programmatically write all instance data to a SQL DB table. mbeccaria@paulsmiths.edu on "Archiving Form Instance Data" http://www.perfectforms.com/forums/topic/archiving-form-instance-data#post-2199 Thu, 02 Jun 2011 15:36:12 +0000 mbeccaria@paulsmiths.edu 2199@http://www.perfectforms.com/forums/ On a related note, how can you see that there is an attachment? I'm able to go through the Visual Studio's demo and see field data in a table but when I try to show an attachment field, no column shows up. Regular data fields do but not attachment fields. Also, I got a form to output to PDF using the GetFormInstancePDF (very cool!). The name of the file is on that PDF form. I also noticed that there is a GetAsset method available but it doesn't say what the assetID is supposed to be or how to retrieve it. I used the GetFormInstanceData method and got some xml that had weird ID strings and no values associated with the file attachments. Is there a way to use the methods to return the right assetID so I can use the GetAsset method to download the files I need? mbeccaria@paulsmiths.edu on "Archiving Form Instance Data" http://www.perfectforms.com/forums/topic/archiving-form-instance-data#post-2198 Thu, 02 Jun 2011 14:34:01 +0000 mbeccaria@paulsmiths.edu 2198@http://www.perfectforms.com/forums/ Dennis, Thank you. I was going to use MySQL but MSSQL is also an option. To be honest, it could be a flat file as we don't have many proposal submissions a year. The idea is that we want a complete local copy of the form instances with all of the field data and the files that were attached to it. The actual file is the proposal submission and is the most important piece. The form is simply the metadata surrounding the workflow (i.e. updates and comments from the different decision makers and their approval, disapproval of the proposal). Again, is there not a way to get the complete form instance information? Thanks, Mike Dennis @ PerfectForms on "Archiving Form Instance Data" http://www.perfectforms.com/forums/topic/archiving-form-instance-data#post-2195 Wed, 01 Jun 2011 18:29:33 +0000 Dennis @ PerfectForms 2195@http://www.perfectforms.com/forums/ Yes, I was referring to all form data except attachments. Attachments CAN be transferred but the filename will not transfer with it. You will see that there is an attachment, but not what it is. What type of database are you populating? mbeccaria@paulsmiths.edu on "Archiving Form Instance Data" http://www.perfectforms.com/forums/topic/archiving-form-instance-data#post-2194 Wed, 01 Jun 2011 16:09:10 +0000 mbeccaria@paulsmiths.edu 2194@http://www.perfectforms.com/forums/ Just to clarify, by "all of the instance data" you are referring to all of the data except that of the file attachments associate with the instance, correct? If that is the case, I would like to ask Perfectforms to add this feature to their product. Having a way to programmatically save all instance data (files included) is a very important and, what I would consider, basic feature. Again, is there ANY strategy or workaround to this issue? Dennis @ PerfectForms on "Archiving Form Instance Data" http://www.perfectforms.com/forums/topic/archiving-form-instance-data#post-2193 Wed, 01 Jun 2011 15:41:04 +0000 Dennis @ PerfectForms 2193@http://www.perfectforms.com/forums/ The only way to access or delete a file attachment is in the instance to which it was attached. PerfectForms does not support migrating or moving attachments. You can use the Connection Agent to programatically write all of the instance data to an outside data source (depending on the type). Here is a link to the page in our help documentation regarding the Connection Agent: <a href="http://www.perfectforms.com/Documentation/manual/html/?lookup_agent.htm" rel="nofollow">http://www.perfectforms.com/Documentation/manual/html/?lookup_agent.htm</a> mbeccaria@paulsmiths.edu on "Archiving Form Instance Data" http://www.perfectforms.com/forums/topic/archiving-form-instance-data#post-2192 Wed, 01 Jun 2011 14:47:32 +0000 mbeccaria@paulsmiths.edu 2192@http://www.perfectforms.com/forums/ We have an off-premise license of perfectforms and we are using the product for a proposal approval processes. When the process is complete and everyone approves, I would like to archive the form data and file attachments to a local database. I am familiar with software development and API's. With that in mind, what is the best strategy to do this? I understand the API xml process but haven't found a lot of information on the GetAsset function and how to download instance file attachments. Thank you. Dennis @ PerfectForms on "AssetID" http://www.perfectforms.com/forums/topic/assetid#post-1716 Fri, 15 Oct 2010 16:43:05 +0000 Dennis @ PerfectForms 1716@http://www.perfectforms.com/forums/ It is not possible to download attachments outside of the instance. MABrown on "AssetID" http://www.perfectforms.com/forums/topic/assetid#post-1703 Fri, 08 Oct 2010 19:18:01 +0000 MABrown 1703@http://www.perfectforms.com/forums/ I am trying to configure an external program to extract form attachments using the API. I am trying to call the GetAsset method, but I don't know how get the value for the assetId parameter. Is it possible to download attachments via the API, and if so, how is it done? Dennis @ PerfectForms on "How can I retrieve a list of form instances?" http://www.perfectforms.com/forums/topic/how-can-i-retrieve-a-list-of-form-instances#post-1677 Mon, 13 Sep 2010 17:17:21 +0000 Dennis @ PerfectForms 1677@http://www.perfectforms.com/forums/ Version 1.18 due out at the end of September has a new api method: GetListOfFormInstances. MABrown on "How can I retrieve a list of form instances?" http://www.perfectforms.com/forums/topic/how-can-i-retrieve-a-list-of-form-instances#post-1634 Mon, 16 Aug 2010 22:49:29 +0000 MABrown 1634@http://www.perfectforms.com/forums/ I have been looking into using the API as a way to extract data from form instances through a Windows application. I have successfully logged into PerfectForms using the application. Now I am trying to retrieve a list of form instances to populate either a datatable or a listbox. I have tried calling the GetList method, but it just returns a list of "Id" numbers. Can I use the GetList method to return the Form Instance ID, or the Form Instance Name? tmrhymer on "API and WSDL not responding" http://www.perfectforms.com/forums/topic/api-and-wsdl-not-responding#post-1544 Wed, 30 Jun 2010 20:56:07 +0000 tmrhymer 1544@http://www.perfectforms.com/forums/ I also get the error: 500 - Internal server error. There is a problem with the resource you are looking for, and it cannot be displayed. I'm just going through the help documentation trying to build the sample project. When i get to the part about adding a service reference, that is not working and when i try to navigate to <a href="http://myserver/api/api.asmx?wsdl" rel="nofollow">http://myserver/api/api.asmx?wsdl</a> i am getting the 500 error. jasoncmcg on "API and WSDL not responding" http://www.perfectforms.com/forums/topic/api-and-wsdl-not-responding#post-1476 Tue, 01 Jun 2010 18:40:53 +0000 jasoncmcg 1476@http://www.perfectforms.com/forums/ It took me awhile to see what you were talking about. Since I cannot get the API to work, I will look at using the 'connections' feature to piece together something that will work. Thanks ajobling on "Advice on secure data retrieval methods" http://www.perfectforms.com/forums/topic/advice-on-secure-data-retrieval-methods#post-1472 Tue, 01 Jun 2010 08:30:41 +0000 ajobling 1472@http://www.perfectforms.com/forums/ To enable the API reference behind the link button please make sure that API option is selected in the account settings. It needs to be enabled in the Settings section and also in your user settings. JB1 on "Advice on secure data retrieval methods" http://www.perfectforms.com/forums/topic/advice-on-secure-data-retrieval-methods#post-1471 Mon, 31 May 2010 21:03:39 +0000 JB1 1471@http://www.perfectforms.com/forums/ Hey Guys I've spent a long time with the videos and the help files, great stuff. What I am interested in is retrieving data captured by forms automatically as needed WITHOUT using a web service, or a database with a web presence. My need is to upload and download information from a local list using local simple automation. I'm attempting the VB Project by following the steps in 'Setting Up a Test Form' via <a href="http://www.perfectforms.com/Documentation/manual/html/index.html?d_connectionsintegration.htm" rel="nofollow">http://www.perfectforms.com/Documentation/manual/html/index.html?d_connectionsintegration.htm</a>'. However, the LINK button does not give me the API reference field at all. Not sure why. Any ideas or advice more than welcome. Thanks JB1 CJ Hines on "API and WSDL not responding" http://www.perfectforms.com/forums/topic/api-and-wsdl-not-responding#post-1467 Wed, 26 May 2010 19:18:21 +0000 CJ Hines 1467@http://www.perfectforms.com/forums/ I would try deleting and retrying the whole connection.. Directions are located here: <a href="http://www.perfectforms.com/Documentation/manual/html/d_connectionsintegration.htm" rel="nofollow">http://www.perfectforms.com/Documentation/manual/html/d_connectionsintegration.htm</a> Let me know what happens afterward. jasoncmcg on "API and WSDL not responding" http://www.perfectforms.com/forums/topic/api-and-wsdl-not-responding#post-1466 Wed, 26 May 2010 17:57:02 +0000 jasoncmcg 1466@http://www.perfectforms.com/forums/ A new api key results in the same. Please note the following: This returns the proper screen: <a href="http://app.perfectforms.com/api/api.asmx" rel="nofollow">http://app.perfectforms.com/api/api.asmx</a> The equivalent path on our server with http returns 403 forbidden access. The equivalent path on our server with https returns 500 Internal server error CJ Hines on "API and WSDL not responding" http://www.perfectforms.com/forums/topic/api-and-wsdl-not-responding#post-1465 Wed, 26 May 2010 17:15:15 +0000 CJ Hines 1465@http://www.perfectforms.com/forums/ Try getting a new API key and use it. jasoncmcg on "API and WSDL not responding" http://www.perfectforms.com/forums/topic/api-and-wsdl-not-responding#post-1464 Wed, 26 May 2010 12:13:03 +0000 jasoncmcg 1464@http://www.perfectforms.com/forums/ Yes, it is enabled with all machines on our network allowed to use it. I am a full user and have my API key. CJ Hines on "API and WSDL not responding" http://www.perfectforms.com/forums/topic/api-and-wsdl-not-responding#post-1463 Tue, 25 May 2010 21:39:22 +0000 CJ Hines 1463@http://www.perfectforms.com/forums/ 1.Have you enabled the API connection on your dashboard yet? Settings tab > Settings > enable API checkbox 2.Then you must enable API for each user you would like (must be full user) Settings tab > Users > (choose user) > check the API checkbox > click Send API key Retrieve key and use as key to set up connection. jasoncmcg on "API and WSDL not responding" http://www.perfectforms.com/forums/topic/api-and-wsdl-not-responding#post-1462 Tue, 25 May 2010 18:46:55 +0000 jasoncmcg 1462@http://www.perfectforms.com/forums/ The main url is setup as an https. (There is no http link for our onsite PF.) Export scheduler says "Unable to connect to PF API using the supplied credentials". Putting ?wsdl on the end of a form api link gives "500 - Internal server error. There is a problem with the resource you are looking for, and it cannot be displayed." Attempting to display the asmx api link in a browser gives the same response as the WSDL. Crossdomain.xml in "C:\Program Files\PerfectForms" has "<?xml version="1.0"?> <!DOCTYPE cross-domain-policy SYSTEM "http://www.macromedia.com/xml/dtds/cross-domain-policy.dtd"> <cross-domain-policy> <allow-access-from domain="*" secure="false"/> <allow-http-request-headers-from domain="*" headers="*" secure="false"/> </cross-domain-policy>" ddejonghe on "Integration with eID" http://www.perfectforms.com/forums/topic/integration-with-eid#post-718 Tue, 01 Sep 2009 15:30:20 +0000 ddejonghe 718@http://www.perfectforms.com/forums/ Has anyone experience with the integration of electronic ID cards for authentication? a potential clinet would like to develop forms that need to be electronically signed through the eId card. see <a href="http://eid.belgium.be/nl/" rel="nofollow">http://eid.belgium.be/nl/</a> (use Google translate page to understand it... or <a href="http://www.roadbyte.be/documents/RoadByte%20eID%20Framework%20NL.pdf" rel="nofollow">http://www.roadbyte.be/documents/RoadByte%20eID%20Framework%20NL.pdf</a> would like to get suggestions on how to integrate this in a perfectforms... Dominique ijobling on "JSF integration" http://www.perfectforms.com/forums/topic/jsf-integration#post-653 Tue, 11 Aug 2009 08:28:44 +0000 ijobling 653@http://www.perfectforms.com/forums/ PerfectForms API allows you to pass data into PerfectForms and extract it from third party applications, but of course it all depends on exactly what it is you are looking to achieve here. Have a look at the user guide on the API and its uses, and maybe this other 'framework' also has its own API that could be of use as well. <a href="http://www.perfectforms.com/Documentation/manual/html/api.htm" rel="nofollow">http://www.perfectforms.com/Documentation/manual/html/api.htm</a> If this isn't helping, you may want to consider contacting our professional services team for assistance with the specific requirements you are seeking here <a href="http://www.perfectforms.com/contact-form.php" rel="nofollow">http://www.perfectforms.com/contact-form.php</a> aditya on "JSF integration" http://www.perfectforms.com/forums/topic/jsf-integration#post-650 Tue, 11 Aug 2009 07:53:02 +0000 aditya 650@http://www.perfectforms.com/forums/ Is there a way to integrate jsf or other frameworks with perfect forms by using its api or any other way. rgatson on "Retrieving attachments in Forms and writing to disk" http://www.perfectforms.com/forums/topic/retrieving-attachments-in-forms-and-writing-to-disk#post-130 Wed, 14 Jan 2009 01:12:00 +0000 rgatson 130@http://www.perfectforms.com/forums/ Hi Dalecan, I don't think this is possible. In the current product, in order to retrieve a file that has been attached, you have to do this from within the form. Thanks. Ray dalecan on "Retrieving attachments in Forms and writing to disk" http://www.perfectforms.com/forums/topic/retrieving-attachments-in-forms-and-writing-to-disk#post-127 Tue, 13 Jan 2009 21:54:57 +0000 dalecan 127@http://www.perfectforms.com/forums/ We are using the File Attachment control and need a way to write the file to disk on the backend. We would prefer to initiate this action inside the Form. Is this possible? Thanks, Dale ScandaLf on "Call GetList() API returns error code 7" http://www.perfectforms.com/forums/topic/call-getlist-api-returns-error-code-7#post-77 Fri, 05 Dec 2008 10:11:54 +0000 ScandaLf 77@http://www.perfectforms.com/forums/ Hi all here are the API error codes: Code Type Description -2 Common The response from the server if not in the right format -1 Common Message code for unknown error 0 Common Message code if everything worked ok 1 Common Message code if the user or password is not valid 2 Common Message code if the user is not authenticated 7 Common Invalid parameters passed to the web service 14 Common The form no longer exists 19 Common The user doesn't have the permission for this action 24 Common Maximum size reached 27 Common The account has expired 29 Common Maximum number of instances reached 32 Common The system has expired 51 API The connection is no longer available 52 API The form instance no longer exists 53 API The API Feature is not enabled for this account 501 Form Services Unable to identify the FormID in the web service name, or the separator between the FormID and the class name is misssing. 502 Form Services The class name is missing. 503 Form Services There is already a control with the same name inside the form. 504 Form Services There is already a control with the same ID inside the form. 505 Form Services The specified value is present more than once in a structure that does not allows values to repeat itself. Such structures are DropDown lists, Multilists etc. 506 Form Services The type of this control new to the IISFilter and it does not know how to handle it. 507 Form Services The SOAP message does not have the right format. It may be corrupt. 508 Form Services The XmlMetaData of the form changed. rgatson on "Call GetList() API returns error code 7" http://www.perfectforms.com/forums/topic/call-getlist-api-returns-error-code-7#post-76 Fri, 05 Dec 2008 01:00:53 +0000 rgatson 76@http://www.perfectforms.com/forums/ Hi Dalecan, I will find out what this error code means and post the results in the forum as soon as I can.