Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [api]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
50 views

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 ...
JCollier's user avatar
  • 101
0 votes
1 answer
77 views

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=...
Luis Avalos's user avatar
0 votes
0 answers
24 views

Database design question around nested columns vs separate tables

I am working with an API endpoint in Power Query where the data is a bunch of nested tables. When I expand all of those columns I am getting duplicate data (the total count of the rows is nearly 8 ...
21200506's user avatar
0 votes
2 answers
86 views

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 ...
Benny's user avatar
  • 3
0 votes
1 answer
28 views

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....
Jon of All Trades's user avatar
1 vote
1 answer
485 views

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 ...
Lindsay Mathieson's user avatar
0 votes
1 answer
130 views

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 ...
Delicious Bacon's user avatar
2 votes
0 answers
48 views

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 ...
Aditya Anand's user avatar
0 votes
1 answer
466 views

MariaDB Maxscale REST API can't show result [closed]

hi i have already setup maxadmin on maxscale can access from rest api this is my configuration ..... [CLI_Service] type=service router=cli [CLI_Listener] type=listener service=CLI_Service ...
febry's user avatar
  • 47
1 vote
1 answer
835 views

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 ...
Morris de Oryx's user avatar
0 votes
1 answer
76 views

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 ...
Daaaaa's user avatar
  • 3
0 votes
0 answers
19 views

[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 ...
Hurukan Imperial Stepper's user avatar
5 votes
1 answer
854 views

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 ...
Doug Coats's user avatar
0 votes
1 answer
116 views

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 ...
AaronJAnderson's user avatar