Thanks strongm. Appreciate it. I did get it working but with something I had paid for a few years back.
https://www.example-code.com/vb6/rest_form_data_upload.asp
Thanks.
Swi
I found this online but still no luck. BAsically it return a 200 success but if I check the responsetext it is not a response but the whole webpage of the API. Any ideas?
Sub UploadFile()
Dim url As String
Dim filePath As String
Dim fileContent As String
Dim boundary As...
Hi,
I have the following curl but I've never posted a CSV file to a REST API this way. I am stuck on the part shown below. Any ideas?
curl --request POST "https:/xxxxxxxx.com/api/reports/upload" --header "Authorization: Bearer {YOUR_AUTH_KEY}" --header "Content-Type...
Hi,
It would be based on the previous 12 months but this inventory has only been received since November of last year. I mentioned 3 in this case which I could see would cause confusion. Thanks for your patience.
Swi
Yes, I understand your frustration however a sick child took the priority. I apologize for the wait. This is the end result.
Part Number Total Usage Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Average Monthly Usage
TEST1 1831 0 0 0 0 0 0 0 0 0 0 497 1334 916
This is the data...
Apologies, I did leave out the SKU part. You are correct. This would need to be done by SKU. Let me post back tomorrow when I am near a laptop as opposed to my phone. Thanks.
Swi
Correct, I would want the average usage across 12 month prior to the current date.
Meaning.
11/3/23 - 10
11/20/23 - 20
12/1/23 - 10
12/15/23 - 40
1/15/24 - 50
So
11/23 = 30 total
12/23 = 50 total
1/24 = 50 total
I would want the average of these three months (in the real scenario I would look...
I have a Access database that has a shipment_date, SKU and plannedQty field.
I would like to do a 12 month rolling average of how much is being used of each SKU. What is the best way to accomplish this? thanks.
Swi
BTW, strongm had most if not all of this code previously in the post. Basically my version filters the results down a bit and has a bit of error handling. Just wanted to give credit where credit was due. Thanks.
Swi
Here you go. This pulls all orders in a JSON format that you will then need to parse. This will pull all orders for the current day that have a status of open, unfulfilled and are paid. I hope this helps. Thanks.
' Build API call based on criteria and the current date
APICall =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.