Questions tagged [api]
15 questions
5
votes
1 answer
System.Web in SQL Server CLR Function
I have done some light research into this topic and I would like to know what are all the pro's and con's or enabling/registering this particular .dll within SQL Server?
Back information - we are integrating with a third party application (not my…
Doug Coats
- 349
- 2
- 10
2
votes
0 answers
What should the schema look like for an API-based SaaS product?
I'm building a developer tool product, which will be accessible solely by APIs. Following are a few features I've identified that will be needed:
Issuing/refreshing API keys
Purchasing API credits
Subscriptions for API credits
Monitoring usage of…
Aditya Anand
- 121
- 3
1
vote
1 answer
Am I abusing Row Level Security? (RLS)
I have set up a classic SQL Server Multi Tenant DB, Shared Database, Shared Schema, will be cloud hosted in Azure. All access to the DB is via a minimal api.
Every row has a tenantId, with a SQL Server security policy setup so tenants can only see…
Lindsay Mathieson
- 11
- 2
1
vote
1 answer
Listing function input and output details for stored functions in Postgres 11.5+
I'm trying to build a query that extracts the input and output definitions for the functions in a schema. We've got multiple client types written in multiple languages, and plan to move many queries into stored functions. That way, each client can…
Morris de Oryx
- 939
- 6
- 18
0
votes
1 answer
Can you 'monitor' curl/ HTTP requests to Snowflake API to see issues?
I'm using a 3rd party tool that can 'connect' to Snowflake API but is throwing errors. They are translating/ botching something on their end, as I can get the Snowflake API easily working with about 5 other tools.
As a Snowflake admin, can I see…
user45867
- 1,739
- 5
- 24
- 41
0
votes
0 answers
How do I store a password in such a way that I can obtain the plain-text password again?
Consider the following scenario:
My app is utilizing a third-party API which requires a username and password for authentication. Unlike most APIs, which have one username and password set for the developer to make calls, this API has a unique…
JCollier
- 101
- 3
0
votes
1 answer
How to use sp_execute_external_script to fetch USD Rate from an API and update a table?
I have this code that gives this error
-- Set the API URL
SET @url = 'https://www.banxico.org.mx/SieAPIRest/service/v1/series/SF43718/dato/oportuno?token=734b37b3a5099a9d2d39d06478d47e359a9568cd6693116d95b710e6b8be0008';
-- Use built-in SQL Server…
Luis Avalos
- 25
- 3
0
votes
2 answers
Growing SQL Server Data Warehouse - How to reorganize efficiently?
we've been using SQL Server for quite a while now in our company to host all application data. We use a typical set-up with data being loaded from various data sources into a Staging Area, which afterwards feeds different datamarts for their…
Benny
- 3
- 3
0
votes
1 answer
Does the BigQuery API offer a way to retrieve info on scheduled queries?
Using the BigQuery C# API, I can retrieve a list of job IDs:
BigQueryClient _client = BigQueryClient.Create(...);
...
foreach (var page in _client.ListJobs(projectId).AsRawResponses())
if (page.Jobs != null) // This does happen occasionally
…
Jon of All Trades
- 5,987
- 7
- 48
- 63
0
votes
1 answer
MySQL's mysql_affected_rows() detects `SELECT INTO` as affected row
Dump of the test database:
-- MariaDB dump 10.19 Distrib 10.9.6-MariaDB, for Linux (x86_64)
--
-- Host: localhost Database: book
-- ------------------------------------------------------
-- Server version 10.9.6-MariaDB
--
-- Table structure…
Delicious Bacon
- 99
- 1
0
votes
1 answer
MariaDB Maxscale REST API can't show result
hi i have already setup maxadmin on maxscale can access from rest api this is my configuration
…
febry
- 57
- 2
- 11
0
votes
1 answer
ORDER from 2 tables to achieve a specific order returned by an API
There's an external API that returns image similarities, based on an "image ID" and a "image version" (a same image can have multiple versions).
The similarity ORDER is given by the API.
The API returns something like this:
+---------+---------+
| …
Daaaaa
- 3
- 1
0
votes
0 answers
[Linux LEAP 15.1][mariadb 10.4.3][C API] The UTF8 characters are not handled as before (10.2.9)
This C source code extract is expected to execute a query... but even if I change the name of the table from "Localités" to "Localites", the program no longer display the utf8 characters as the database could when I execute the same query in command…
0
votes
1 answer
Possible to update rows with data only accessible via API call?
I'm not good at what I'm working on so apologies if some of my terminology is off. Also not sure if this belongs here, or in a more programming oriented area.
I am looking for options to update rows of a mysql database with data only accessible…
AaronJAnderson
- 535
- 2
- 7
- 13