ShadiHashem1
Qrew Cadet
Joined 7 years ago
User Profile
User Widgets
Contributions
Save API Response
Hello, I have an issue with saving an API response to a quickbase field. Posting here hoping someone have a suggestion for how to solve this. Description I have created a webhook which fires upon a record modification. - The webhook takes record data from Quickbase and sends it to an external system. this works just fine - The external system creates the record with the webhook payload - This works just fin - The external system generates an API response - Here is the problem - How do I save that response into a dedicated quickbase field. Should look something like this: ------------------------------ Shadi Hashem ------------------------------Re: Currency exchanges / API
Hi Chayce, Thanks for your responds. It sounds like the best way, but I would then have to export the table from QB into Azure in order merge the tables. Which API call would be the best for extracting an entire table into azure ? The logic will look something like this: A) Call Currency endpoint & create csv table B) Export the QB table to Azure and join with the currency table C) Create post request to QB with the merged table using API_ImportfromCSV Best regards ShadiCurrency exchanges / API
Hi, I am trying to update currency rates on a daily basis with an API from the following endpoint. https://api.exchangerate-api.com/v4/latest/USD I currently have a Table called Currenices -> Exchange rates. Each Base currency has its own exchange rate conversion table with multiple records. eg. USD to DKK, USD to SEK etc.. I am currently following this logic, 1) Creating an http call for each currency in the exchange table by sending a Request to an Endpoint I have created in Azure cloud which will pass the #record id and currency code. 2) I then create a new http request from azure logic app to get the updated rates from the endpoint above. 3) Then send a new post request back to QB using API_Editrecord with the record id, name and new currency rate. Problem is I have to create a new http request for each and every conversion. Is there any way I could simplify maybe just create 1 request and then update all my records from this request ? Hope you guys can help with any good suggestionsUpdating QB field with from an javacript request
Hi, I need to edit an existing field with a jwt token from an external system. To do this I have created a javascript calling the AUTH process to request the jwt token. My request code looks like this: $.ajax({ type: 'POST', url: "https://api.endpoint.url";, processData: true, data: {login: "username, password: "password"}, dataType: "JSON", success: function (data) { processData(data); } }); function processData(data){ var token = (data.sessionData); console.log (token) } How can I save the variable "token" to a field in QB. I need to recurrently update the same field with the token string as the token expires. Hope anyone can help Best regardsSave a responseText to field after API Post request
I have created a code page to handle following post request: $.ajax({ type: 'POST', url: "https://API.Endpoint";, processData: true, data: {login: "XXXXX", password: "XXXX"}, dataType: "json", success: function (data) { processData(data); } }); function processData(data){ //Do some stuff with the data } I get a reponse like following: {readyState: 1, setRequestHeader: ?, getAllResponseHeaders: ?, getResponseHeader: ?, overrideMimeType: ?, ...} abort: ? (a) always: ? () complete: ? () done: ? () error: ? () fail: ? () getAllResponseHeaders: ? () getResponseHeader: ? (a) isRejected: ? () isResolved: ? () overrideMimeType: ? (a) pipe: ? (a,b,c) progress: ? () promise: ? (a) readyState: 4 responseText: "{"returnCode":"9999","return":" response generated and valid until .","returnData":null,"sessionData":"XXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXX"}" setRequestHeader: ? (a,b) state: ? () status: 200 statusCode: ? (a) statusText: "OK" success: ? () then: ? (a,b,c) __proto__: Object I need to save the 16. responseText to a table, more specifically the "sessionData" to a field. The "sessionData" contains a token, which I need to use in other API calls from inside quickbase. How can I retrieve the sessionData in Quickbase and store it to a field, using the same code page as described above ? Thanks in advanceDesigning Tables & Forms
Is it just me or does quickbase lack design options. Tables only seems to allow a vertical column split between fields across the entire form. It does not seem to be possible to have 1 row with a wide field column and on the next row having 2 narrow field in the same column. The width of dropdown fields don't seem to react on the field width settings either. Any workarounds for this ?
