NOTE: Use the API endpoints available at https://jsonplaceholder.typicode.com/ to get the data required in these exercises. HINT: Read the documented Resources and Routes. Also the guide: https://jsonplaceholder.typicode.com/guide/ /////////////////////// 4) Create a function named "getUser". This function needs to accept a "userID" parameter. Use Fetch with Async/Await to request the data for the requested user. The function should return JSON data.

NOTE: Use the API endpoints available at https://jsonplaceholder.typicode.com/ to get the data required in these exercises. HINT: Read the documented Resources and Routes. Also the guide: https://jsonplaceholder.typicode.com/guide/ /////////////////////// 4) Create a function named "getUser". This function needs to accept a "userID" parameter. Use Fetch with Async/Await to request the data for the requested user. The function should return JSON data.

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter8: Working With Advanced Functions

Section: Chapter Questions

Problem 4.4CP

See similar textbooks

Similar questions

Instructions at the top of page for what functions can be used. Answer question 1 only please.
Q1. Write a reference, in VBA code, to each of the following ranges. (You can assume that each of these ranges is in the active worksheet of the active workbook, so that you don’t have to qualify the references by worksheet or workbook.) Here’s an example. Question: The cell one column to the right and two rows below Cell A1. Answer: Range (“A1”).Offset(2,1) The fifth cell of the range B1:B30. The cell at the intersection of the 25th row and 5th column of the range A1:Z100. The cell at the intersection of the 25th row and 5th column of the range that has been set to a Range object variable named SalesRange. The entire column corresponding to cell C5. A range of employee names, assuming the first is in cell B2 and they extend down column B (although you don’t know how many there are). Q2. Write a VBA program (consisting of a single subroutine) to check existence of a given value in a list. Specifically, you are given a list of product IDs in column A, as follows: You don’t know…
javascript please //20. function initPage//a. Dependencies: getUsers, populateSelectMenu//b. Should be an async function//c. No parameters.//d. Call await getUsers//e. Result is the users JSON data//f. Passes the users JSON data to the populateSelectMenu function//g. Result is the select element returned from populateSelectMenu//h. Return an array with users JSON data from getUsers and the select element//result from populateSelectMenu: [users, select] html <body> <header> <h1>Acme Blogs</h1> <form id="filterForm"> <select id="selectMenu"> <option selected>Employees</option> </select> </form> </header> <main> <p class="default-text">Select an Employee to display their posts.</p> </main> <footer> <p>Acme Company</p> </footer> <div id="mocha" class="testResults"></div>…
9. Write a SELECT statement that uses aggregate window functions to calculate the total due for all vendors and the total due for each vendor. Return 3 Columns: The vendor id from the Invoices table. The balance due (invoice_total-payment_total-credit_total) for each invoice in the invoices table with a balance greater than 0. The total balance due for all vendors in the Invoices table. Modify the column that contains the balance due for each vendor so it contains a cumulative total by balance due.
6. Create a table-valued function named fnDateRange, similar to the stored procedure of exercise 3. The function requires two parameters of data type date. Don’t validate the parameters. Return a result set that includes the InvoiceNumber, InvoiceDate, InvoiceTotal, and Balance for each invoice for which the InvoiceDate is within the date range. Invoke the function from within a SELECT statement to return those invoices with InvoiceDate between October 10 and October 20, 2019.
please use store procedures to answer the following question Create a procedure to update Job Title for a given JOB_ID This procedure is called Update_Job_Title will have two INPUT parameters. p_job_id as VARCHAR2 as INPUT parameter and also p_new_job_title as VARCHAR2 as INPUT parameter. In BEGIN and END executable section Execute UPDATE command on JOBS table to change title of a JOB_ID Here is the command that you can use in BEGIN and END UPDATE JOBS SET job_title= p_new_job_title WHERE job_id= p_job_id; Test your code by executing procedure for below job_id. Currently in Jobs table you have Job_id = ‘MK_MAN’ and job_title=’ Marketing Manager’ Change title from Marketing Manager to Marketing Sr. Manager execute Update_Job_Title(‘MK_MAN’, ‘Marketing Sr. Manager’ )
Explain the role and purpose of the two codes provided below. Create or Replace Trigger Purchase_EntryAfter Insert or Update of Purchase_Amt on PURCHASE_AGREEMENTFor Each RowBegin if(:New.Purchase_Amt < 0) Then RAISE_APPLICATION_ERROR(‐20100, 'Cannot enter a purchase agreement amount less than zero.'); end if;End; insert into PURCHASE_AGREEMENT values (559, '27 May 2020', ‐1, 12350,'C122',1
In this function, you will try to update the given user's bank account with the given amount. bank is a dictionary where the key is the username and the value is the user's account balance. log_in is a dictionary where the key is the username and the value is the user's log-in status. amount is the amount to update with, and can either be positive or negative. To update the user's account with the amount, the following requirements must be met: - The user exists in log_in and his/her status is True, meaning, the user is logged in. If the user doesn't exist in the bank, create the user. - The given amount can not result in a negative balance in the bank account. Return True if the user's account was updated. For example, if Brandon has 115.50 in his account: - Calling update(bank, log_in, "Brandon", 50) will return False, unless "Brandon" is first logged in. Then it will return True. Brandon will then have 165.50 in his account. - Calling…
''' In this function, you will try to update the given user's bank account with the given amount. bank is a dictionary where the key is the username and the value is the user's account balance. log_in is a dictionary where the key is the username and the value is the user's log-in status. amount is the amount to update with, and can either be positive or negative. To update the user's account with the amount, the following requirements must be met: - The user exists in log_in and his/her status is True, meaning, the user is logged in. If the user doesn't exist in the bank, create the user. - The given amount can not result in a negative balance in the bank account. Return True if the user's account was updated. For example, if Brandon has 115.50 in his account: - Calling update(bank, log_in, "Brandon", 50) will return False, unless "Brandon" is first logged in. Then it will return True. Brandon will then have 165.50 in his account. - Calling…
How important are access restrictions today? Please include two access constraints in your answer.
Make the functions below according to the attached class diagram and GUI program mockup. No The function to be made 1 Create Transaction Order_ID = 1 Order_Date = 11-2-2021 Customer_ID = 2 Customer_RefNo = 001 / I / S / 2021 When the TextField 'txtCustomerID' is filled and we click the 'View' Button, then the TextField 'txtViewCustomerName' will display the 'Customer_Name' field from the Customer's Table according to the input Customer_ID. If the data is not found, a notification will appear “Customer not registered”. 2 Fill in the List Combo Box Product_ID by retrieving data from the Product Fied Table Product_ID 3 If the button ‘Tambah Item’ is clicked, then data from Product_ID, txtProduct_Name, txtQuantity, txtPrice will be saved to the 'Order Detail' Tabke (according to the mockup), then also enter the Sub Total field in the 'Order Detail' table with the calculation of txtQuantity * txtPrice. 4 When the ‘Hapus’ button is clicked, data from…
Python please starter code: # Web App to Get Stock Market Data from AlphaVantage Serviceimport requests#Function that gets stock info from API# Returns results in list of two strings# DO NOT EDIT THIS FUNCTION EXCEPT TO INSERT YOUR API KEY WHERE INDICATEDdef getStock(symbol):baseURL = "https://www.alphavantage.co/query?function=GLOBAL_QUOTE&datatype=csv"keyPart = "&apikey=" + "REPLACE WITH YOUR API KEY" #Add API keysymbolPart = "&symbol=" + symbolstockResponse = requests.get(baseURL+keyPart+symbolPart)return stockResponse.text #Return only text part of response#Function that computes and displays resultsdef main():# Add code that meets the program specifications (see instructions in Canvas)#Code that starts the appmain()