Jump to content

Search the Community

Showing results for tags 'API'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Caspio Bridge
    • 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

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


MSN


Website URL


ICQ


Yahoo


Skype


Location


Interests

Found 20 results

  1. Do records inserted through REST API execute triggered actions?
  2. 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
  3. 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.
  4. 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/
  5. 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
  6. 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!
  7. 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>
  8. 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
  9. 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
  10. 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?
  11. 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!
  12. 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.
  13. 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.
  14. 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
  15. 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!
  16. 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
  17. 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!
  18. I created a profile. Put my client_id and client_secret into POSTMAN along with the parameter "grant_type" and the value "client_credential". All I can get from Caspio is { "error": "invalid_client" } What other information do I need to include with the request? I've read the documentation. http://howto.caspio.com/caspio-bridge-rest-api/authenticating/ grant_type=client_credentials&client_id=<Client Key>&client_secret=<Client Secret> That list of URL Parameters is exactly what I'm sending. I've gone back into Caspio Access Permissions and refreshed my client_id and client_secret and saved the changes. With the new id and secret, I'm getting exactly the same error message. Please Help
  19. There doesn't appear to be any way to bulk insert records in the API - is there a way to achieve that other than to loop through in the code at the other end?
  20. Hello all, I've been able to access the Caspio API via PHP to update my tables from my external web server. Is it possible to do this from within a Caspio datapage? I mostly want to use caspio datapages as is, but I would like to occasionally add functionality via the API if possible. The solution I have found so far is to write the PHP code on our server and then open the page as an iFrame on the datapage, which is cumbersome. Any thoughts? Thanks! Piper
×
×
  • Create New...