Jump to content

Search the Community

Showing results for tags 'API'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Caspio Bridge
    • Caspio Apps for Ukraine
    • General Questions
    • Caspio JavaScript Solutions
    • Tables, Views and Relationships
    • Import/Export and DataHub
    • DataPages
    • Deployment
    • Security, Authentications, Roles, SAML
    • Styles and Localizations
    • Parameters
    • API and Integration
    • Calculations and aggregations
    • User JavaScript and CSS Discussions

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start




Website URL






  1. Is there a way that I can create an automated notification of Usage Stats, eg Deployed Data Pages per App, MB used etc. Perhaps via the API? Ultimately, I would like to send an email to our Finance team with these stats each month.
  2. Hi, can I use select table using caspio Api to external java script?
  3. I am creating a web service profile to be used in working with the API. Looking at the documentation on the below link I should get a WSDL URL and a Pass Key. However the actual screen to create profiles does not have either of those fields, and instead has Client ID and Client Secret. Are these terms interchangeable, and if not, where do I get the URL and Pass Key from? http://howto.caspio.com/managing-your-account/internal-users-groups-and-api-profiles/creating-a-web-services-api-profile/
  4. When updating a record using the REST API, I encounter the following error: "Code":"TriggerRuntimeError","Message":"Data change cannot be performed due to triggered action failed. Please contact administrator." The table has a triggered action to send an email anytime a record is updated or inserted. The really strange part is that everything works perfectly fine when using chrome. The error is only thrown in mozilla and only thrown when updating a record. Inserting a record works as expected. I am using php & curl to make the requests.
  5. Hello! I was wondering if anyone had any trouble when refreshing their access tokens? I successfully authenticated my users through RESTful API, but now have trouble using the POST call advised from the how to guide on the website. Any feedback is greatly appreciated!
  6. Hi, is there any way to download the data from a Tabular Report Datapage via the API? Or even export it?
  7. I have a client that has asked if they can create an .sde connection directly with my caspio database rather than utilizing the API. Below is the detailed request. This is the point in s question - "we'd need an accessible endpoint directly into your database, or at least have port forwarding set up." Is this possible? The SDE file creation needs the following information: database_platform - takes a few different platforms, the most notable being ORACLE, POSTGRESQL, and SQL_SERVER instance - The reachable address and port number we can use to connect from our ArcGIS server to your Database. This is the hard one - we'd need an accessible endpoint directly into your database, or at least have port forwarding set up. Username - the database username we'd use to connect This user would have read-only privileges only on the tables where we have data stored. Password - Password for above database user database - Only needed if running on a POSTGRESQL server, the name of the database
  8. Greetings Caspio users, My goal is to send an email to my customers, that notifies them that if they are ready for the next step in the workflow, they simply need to click on a "URL". Once done, the API must update specific verbiage within a specific Value in the Table. I believe this can be done through the REST API? Appreciate any guidance offered. Thank you! P.S. Already have my Bearer Key created and can successfully view data by using the great instructions CASPIO has available
  9. Hello Caspio Community! Let me explaining my scenario firstly please. Currently I'm stuck on how to authenticate REST API calls in a secure manner. I have a new app stood up and ready to launch (this app is/well always be locked behind Caspio Login) . However, before I launch this app I was wondering if I could use "document.cookie()" user token to make API calls instead of the bearer token that I have been using for development. If I could use a user token instead of an API key I would feel much more secure. Thank you for taking time out of your day to read this! I look forward to reading your replies!
  10. Currently trying to find if anyone has already implemented on a Form (DataPage>submission form) a barcode scanner to automatically populate that field rather than have the person attempt to type in 20 characters without error. Of course if there is an app it will have to support API, but any insight is appreciated.
  11. Hello everybody, Has anybody ever tried to integrate CheKin in Caspio? Can you share your experiences?
  12. Thank you for reviewing my question, which deals with Cloudinary's image management integration: I have successfully setup a Caspio Web Services profile and verified it with Caspio Bridge Rest API, resulting in Code 200 response body. Please note that I am learning as I go and do not have a background in tech, so I appreciate anything you can offer me. In light of my lack of experience, I feel that I am wasting a good amount of time learning concepts related to API from sources outside of Caspio, something that was reconfirmed after watching Ned Pajic's YouTube video, "How to Generate an API Token", whereby watching that video was the best 5 minutes I have spent doing something in a long time. Thank you, Ned, for reconfirming through your video that all of the answers are contained within Caspio services and, as I have also discovered, within the Caspio Community. I have already purchased Integromat and Zapier and used these services succesfully, but I have decided that I don't want to use these features for the application I am developing because I would like for my clients to be able to use the Cloudinary widget in conjunction with the forms I have developed within Caspio. Submitted forms are given a unique ID within the Caspio table. I would like to be able to associate the photos in Cloudinary to the specific unique ID of the entry within Caspio. In simpler terms: Client uses a Caspio form to make a submission >> client needs to include pictures for the submission >> client can thereby use Cloudinary widget to select their photo >> client submits the form >> submission creates unique ID per the design already implemented >> that unique ID becomes part of the public ID, or perhaps tag, of the Cloudinary image. Cheers and thank you very much!
  13. Do records inserted through REST API execute triggered actions?
  14. I love Caspio! I have a MySQL DB whose data is managed by a custom user interface. I want to access the data (read only) to pull out records for a variety of purposes. Can anyone advise me how to go about doing this? Is there some feature that can pull specified tables or new/updated records through into Caspio. Any suggestions welcome so long as they’re polite ones! James
  15. Hello! Studying the "Caspio Bridge Microsoft .Net Framework Sample", that is a general example of WS API usage in C# .Net Windows applications and demonstrates the object de-serialization and usage of SelectDataXML and ListObjects WS API methods, we could connect to our Caspio Bridge tables via WS API and Select our field values. The sample code below is working perfectly! using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Timers; using dataPhase.com.caspio.c0bkr041; using System.Web.Services.Protocols; using System.Xml; namespace dataPhase { public partial class Form1 : Form { private static CaspioBridgeAPI soapClient; public Form1() { InitializeComponent(); soapClient = new com.caspio.c0bkr041.CaspioBridgeAPI(); } private void button1_Click(object sender, EventArgs e) { string sXML; IDictionary<string, string> sRecord = new Dictionary<string, string>(); XmlDocument mXMLDoc = new XmlDocument(); XmlNodeList mList; XmlNode mNode; sXML = soapClient.SelectDataXML("AccountID", "Profile", "Password", "My_Users", false, "", "User_ID=" + textBox3.Text, "", false, false, true, false); mXMLDoc.LoadXml(sXML); mXMLDoc.Save("My_Users.xml"); mNode = mXMLDoc.SelectSingleNode("// My_Users"); mList = mNode.SelectNodes("./*"); foreach (XmlNode mFieldNode in mList) { sRecord[mFieldNode.Name] = mFieldNode.InnerText; } textBox1.Text = sRecord["First_Name"]; textBox2.Text = sRecord["Last_Name"]; textBox5.Text = sRecord["Phone"]; textBox4.Text = sRecord["Address"]; } private void Form1_Load(object sender, EventArgs e) { textBox3.Text = "Enter User ID"; } } } Now we would like to learn how to insert and update data in our Caspio Bridge database! Please, Could someone show us how to add a new user information using the same approach? and how we could update a specific user information? Best Regards! Luiz
  16. Hellow everyone, I have implemented a sign in form an button in html: <ons-button onclick="login()">Sign in</ons-button> The following Javascript is as follows: var token_ var userName = "clientID"; var passWord = "secretKey"; // app clientSecret var caspioTokenUrl = "https://xxx123.caspio.com/oauth/token"; var request = new XMLHttpRequest(); function getToken(url, clientID, clientSecret) { var key; request.open("POST", url, true); request.setRequestHeader("Content-type", "application/json"); request.send("grant_type=client_credentials&client_id="+clientID+"&"+"client_secret="+clientSecret); // specify the credentials to receive the token on request request.onreadystatechange = function () { if (request.readyState == request.DONE) { var response = request.responseText; var obj = JSON.parse(response); key = obj.access_token; //store the value of the accesstoken token_ = key; } } } getToken(caspioTokenUrl, userName, passWord); var login = function CallWebAPI() { var params {"ClientID" : "username", "ClientSecret" : "password"}; var request_ = new XMLHttpRequest(params); request_.open("GET", "https://xxx123.caspio.com/rest/v1/tables", true); request_.setRequestHeader("Authorization", "Bearer "+ token_); request_.send(); request_.onreadystatechange = function () { if (request_.readyState == 4 && request_.readyState == 200) { var response = request_.responseText; var obj = JSON.parse(response); } } } It still does not work for me and I'm not quite sure what I am doing wrong. Any help is very much appreciated! Thank you all!
  17. Hello, I would like to place the results of an API request into Caspio table record fields. I have been successful in accomplishing this with google address geocoding. However, I would like to use a reverse geocoding API from the Census Bureau and I cannot insert the results. I seem to be able to receive the proper response using the Chrome console. But, I cannot receive the request and insert it into a table record field. Right now, I am just to try to insert one response value. Below is the script that I am inserting into the Footer (with fixed lat/long values to test). Thanks, Anthony <script> var longitude = '-78.8904516' var latitude = '36.0054348' var url1 = 'https://geocoding.geo.census.gov/geocoder/geographies/coordinates?x=' + longitude + '&y=' + latitude + '&benchmark=4&vintage=4&layers=10&format=jsonp' function gogeo() { $.ajax({ url: url1, dataType: 'jsonp', success: function(Response) { console.log(Response); successCallback(Response) }, error: function(error) { console.log(error); } }); return Response.result; function successCallback(Response){ var geoid1 = Response.result.geographies["Census Block Groups"]["0"].GEOID; geoid1 = Number(geoid1); document.getElementById("InsertRecordgeoid").value =geoid1; } } gogeo() </script>
  18. This may be of use to people. This is pulled out of a project I'm working on. It's a PHP library that manages the low-level integration with the Caspio REST API. If I have time I'll pull more classes out of the project that might be helpful and integrate them into this library. But it demonstrates the basics of interacting with the Caspio REST API via PHP. https://github.com/moksamedia/caspio-rest-api-lib
  19. Hi All, I have tried calling authentication API to get token Key but I am always gettinf it as bad request. Can anyone please help me on this , if I am missing something here. Please refer below screen on what all data is passed during calling.I have used postman tool of google. Thanks Baharul Islam
  20. Hello! I am using the HTTP basic authentication method for my mobile app and have followed the POST request as outlined on the website. My ajax call is as follows: $(document).ready (function () { $('button').click(function () { var Client_ID = $('clientid').val(); var Client_Secret = $('clientsecret').val(); $.ajax ({ type: 'POST', url: 'Token endpoint', data: 'grant_type=client_credentials', headers: { 'Authorization' : 'Basic Q2xpZW50X0lEOkNsaWVudF9TZWNyZXQ=' }, success: function(data) { window.location.href = 'page1.html'; }, }); }); I encoded the string "Client_ID:Client_Secret" as advised too. Upon checking my network console, I'm getting a 400 error. Can anyone help?
  21. I need to download more than 1000 rows via the REST API, is there an easy way to do it? Something like "get next 1000 rows", etc.? We've written an application that downloads data to a tablet via the REST API, the user then takes the tablet to remote locations off-line. Some of the data tables have more than 1000 rows, so our users are not able to get all of their data. I'm hoping Caspio has a built in way to "get next 1000 rows" so that we don't have to alter our tables to have sequential row indexes.
  22. I'm working on a wordpress site and writing some custom PHP functions that access Caspio via the REST interface. I'm trying to figure out how to determine if the current user is logged in and get that user's info. I tried creating an HTML DataPage with the same authorization setup that simply echoed back the user info, hoping that if I logged into the website the REST request would be authenticated as well, but this didn't work. I also tried setting the PHPSESSID cookie in the request. Unfortunately, the REST request for the HTML datapage is always getting the login screen, regardless of if the user is logged in in the website. How does Caspio track user authentication? Is there a known solution to this? Thanks, Andrew
  23. Hi, I want to output a parent record and its linked child records (a variable number of records) as a JSON array to display in a html page that consists of sections. Each section contains one or more fields from either the child or parent record(s). I would like to be able to push the data upon clicking a button. Following is an example of what I mean. (NB: The actual Parent Table has 10 fields and the Child table has 60 fields, including some that are formula fields). Parent table fields: FIELD: PID PF1 PF2 PF3 TYPE (autonumber) text date number Child Table fields: FIELD: CID (autonumber) PID CF2 CF3 CF4 CF5 TYPE (autonumber) integer text date number checkbox PID is an Integer field and relationship linked to same field in Parent table. Section 1 [CF3-record1] [CF3-record2] [CF3-record3] Section 2 [CF2-record1] [CF4-record1] [CF2-record2] [CF4-record2] [CF2-record3] [CF4-record3] Section 3 [CF5-record1] [PF1] [CF5-record2] [PF1] [CF5-record3] [PF1] It would be much appreciated if someone can assist by providing some instructions and javascript if needed. Many thanks!
  24. I am new to Caspio and wonder if it is possible to get the exchange rates from an external website based on the date and currency entered by the user and return the exchange rate back the exchange rate field in a table? I don't know anything regarding api and therefore need more guideline on this. Thanks
  25. I noticed a topic from 2013 with this question but there didn't seem to be a consensus. My site is on Wordpress and we are currently using a Wordpress login. This is great because it has the ability to allow certain tabs to show up based on the login credentials, however...it requires a completely different login for Caspio. We need our users to be able to favorite things, ask for updates on things, and to be able to track their movements within Caspio so we need them to login to Caspio. I'm not very experienced with coding, aside from a lot of copy pasting JavaScript and making minor HTML tweaks, so is there a way for me to login to Wordpress and use those credentials to automatically login to Caspio as well? The simpler the language the better, thank you so much for taking a look!
  • Create New...