@rajeevchauhan8 Example code is already available at https://codingislove.com/google-sheets-database/

Perhaps if I show a copy of my simple little worksheet, some kind soul could suggest the proper code to trigger an email to the original Requestor when the task has been completed. The Requestor is in column B and I would build a lookup table associating the requestor with their email address. The code - in my imagination) would use the lookup table to get the Requestor's email and send him/her the completion email.

Thanks!

Skip

To know more you can contact- https://semidotinfotech.com

Thanks for sharing.

You should hire a chatbot development company like us.

Have your try Safari?

Thanks for the information.

Hello,

You can also have a look at Strategic Use of CRM For eCommerce Start-ups’ Growth

@nector You should understand the code instead of copy-pasting. Above code neither generates JSON nor posting any data. I've already mentioned that posting data is done by sending it with send method using http.send data

You can do something like this

Dim postData As New Dictionary postData("id") = 1 postData("name") = "codingislove" http.send ConvertToJson(postData, Whitespace:=2)

Above code will post {"id: 1, "name": "codingislove"} data to the API
Copy pasting the code won't work. Do understand the code and implement it as required.

Sorry I got stuck again on Json String format , how is it done??????

Dear Experts

Kindly see how you can help again in my final part of this Ms Access /Json project, now I want the data in the query below to be posted to the site as per link in the VBA. The problem I have right now is how to format the data in a query into Json so that it can be posted successfully
Qry1

SELECT tblInvoice.Customer, tblCustomers.TaxID, tblCustomers.Address, tblInvoice.INV, tblInvoice.InvoiceDate, tblInvoicedetails.Product, tblInvoicedetails.Qty, tblInvoicedetails.Price, tblInvoicedetails.VAT, (([Qty][Price])(1+[VAT])) AS TotalPrice
FROM tblProducts INNER JOIN ((tblCustomers INNER JOIN tblInvoice ON tblCustomers.ID = tblInvoice.Customer) INNER JOIN tblInvoicedetails ON tblInvoice.INV = tblInvoicedetails.INV) ON tblProducts.PDID = tblInvoicedetails.Product
WHERE (((tblInvoice.INV)=[Forms]![frmInvoice]![INV]));

Below is the VBA that I have prepared requiring completing the Json data formatting:

Private Sub CmdSales_Click()
Dim http As Object
Dim db As Database
Dim rs As Recordset
Set db = CurrentDb
Dim JSON As Object
Dim i As Integer
Dim item As Object
Set rs = db.OpenRecordset("SELECT * FROM Qry1 Where Qry1.ID = " & Me.INV, dbOpenDynaset, dbSeeChanges)
http.Open "POST", "http://jsonplaceholder.typicode.com/users/?id=" & Me.INV, False
http.send
Set JSON = ParseJson(http.responseText)
i = 2
End Sub

Kindly see how this can be done!

Thank you so much

@dhilsha-s There's already an example here - Parse URLs in VBA

Hi @peteb1 That external URL might have a parameter to take page number. Pass the page number in the URL to pull the next 50 rows. It might be something like url/?page=2 or url/?offset=50