T3 API question
Hello, recently upgraded to T3 and I'm using the API function to get live data to a spreadsheet, by using the IMPORTDATA tutorial you guys posted, something that would be helpful for the data imported would be the column for "LT Status" Lab Testing, with that column i could easily share with my sales team what is available for sale at the exact moment, and what's still awaiting testing and those sorts of things, maybe even the category column for other similar reasons
- MMatt Frisbie @mattfriz
This is already possible! I assume you're referring to a Packages report endpoint. If so, you'll just need to specify the fieldnames that you want included in your report. The field name you want is
labTestingStateName. So, for example, you would add this to your URL:&fieldnames=label,locationName,item.name,quantity,unitOfMeasureAbbreviation,labTestingStateNameLet me know if this helps!
- BBobby Jankowski @BobbyJ
i got it to work thank you! and what is the name for category, i tried just &category and that broke it.
- MIn reply toBobbyJ⬆:Matt Frisbie @mattfriz
You would add on
,item.productCategoryNameHere's the docs:
https://api.trackandtrace.tools/v2/docs/#/Reports/get_v2_packages_active_reportScroll down to "Responses" to see a list of what can be included in
fieldnames.