skip to Main Content

SQL Server JSON group

I'm trying to transform my table to JSON My table: DROP TABLE IF EXISTS #tmp CREATE TABLE #tmp(AnalyticGoodsT CHAR(6), date SMALLDATETIME) INSERT INTO #tmp(AnalyticGoodsT, date) VALUES ('000001', '20230424'), ('000002', '20230424'), ('000003', '20230424'), ('000004', '20230424') Required JSON format(i'm trying to group…

VIEW QUESTION

How to simulate equivalent amount in json

I am trying to simulate a REST api endpoint function where I want to check the endpoint for an exchange currency Trying on postman and i Do this https://api.flutterwave.com/v3/transfers/rates?amount=1000&destination_currency=USD&source_currency=KES thereafter i input my secret key I get this as response…

VIEW QUESTION
Back To Top
Search