VBA REST API to GET SMS from Twilio

[GraeagleBill]

The table "TWLog" created by DoCmd.TransferText acLinkDelim, , "TWLog", "C:\GCC\TWLog.csv", True doesn't contain any fields upon which to create a query, which leaves me really lost at this point.

IGNORE THE ABOVE

Not being familiar with the DoCmd.TransferText functionality, I completely missed the assumption that Colin's code would have to be run first so that the csv file was properly loaded, so all is well with what you had intended that I try.



Last question, I think, do you have some thoughts on how to handle the situation where the "Body" of a message contains commas?

[pbaldy]

I'm not surprised. Have you examined the variable with the response text in it? Does it have anything in it? You're only showing a tiny bit of the, which is fine until there's a problem before that point.

[pbaldy]

Last question, I think, do you have some thoughts on how to handle the situation where the "Body" of a message contains commas?

Mentioned one method earlier. First thing I would try is saving it to a text file with a csv extension and try the linking code on that file.

[GraeagleBill]

At this point I have a table populated from the CSV file and a query to view the resulting table. I'm burned out for the day so I'll ponder the issue about commas in the Body tomorrow.

[pbaldy]

Can you attach or send me the csv file? If it's comma delimited, the third line should result in a table with all the fields in it.

[GraeagleBill]

At this point I have a table populated from the CSV file and a query to view the resulting table.

I was trying to tell you in post #34 that I was successful in the use of DoCmd.TransferText to create a table from the CSV file.

[isladogs]

Hi Bill
Sorry but I've been busy and not checked this thread for a while.
Do you still have any specific questions about using my code that I may be able to assist with?

[GraeagleBill]

Hi Colin,

No. Between the successes with your code and some valuable coaching from Paul plus some input from the techs at Twilio regarding how to use filters with the "GET" function, I'm almost ready to mark this issued resolved.

What's left is to bring together everything I've learned about the nuances with Twilio and their XML/CSV logs is to code a coherent module that will act like a server in support of the major Access app. That module will run as a scheduled task and periodically "GET" the message log from Twilio looking for incoming requests.

The app's users more often than not send requests to the app using their cell phones. When doing that, they will now send their requests as a text via the Twilio phone number assigned to the Twilio account. Optionally, they can also enter such requests directly from the app's UI, an Access form designed specifically for that purpose functionally similar to what Rader posted eons ago.

As usual you're a significant help, so I thank you.
Bill

[pbaldy]

I was trying to tell you in post #34 that I was successful in the use of DoCmd.TransferText to create a table from the CSV file.

Ah, this threw me off:

"I'll ponder the issue about commas in the Body"

Post back if you're still stuck on the last part.

[GraeagleBill]

Okay thanks.