Edits history of script submission #9325 for ' Executes a Sql SELECT statement against the database (aero_workflow)'

  • bun
    One script reply has been approved by the moderators
    Ap­pro­ved
    //native
    type Aero_workflow = {
    	apiKey: string
    }
    
    export async function main(
    	auth: Aero_workflow,
    	accountId: string,
    	body: { key?: string; query?: string; validKey?: false | true }
    ) {
    	const url = new URL(`https://api.aeroworkflow.com/api/${accountId}/Sql/Select`)
    
    	const response = await fetch(url, {
    		method: 'POST',
    		headers: {
    			'Content-Type': 'application/json',
    			apikey: auth.apiKey
    		},
    		body: JSON.stringify(body)
    	})
    
    	if (!response.ok) {
    		const text = await response.text()
    		throw new Error(`${response.status} ${text}`)
    	}
    
    	return await response.json()
    }
    

    Submitted by hugo697 581 days ago