[Help] API inventory reading with a filter | API Development |…
  • Forum Main Main
  • API Development API
  • [Help] API inventory reading with a filter Thread

[Help] API inventory reading with a filter

​

  • TNL
    Wenno [2757277] Wenno
    • Wenno [2757277]
    • Role: Civilian
    • Level: 100
    • Posts: 1,150
    • Karma: 4,397
    • Last Action: 1 minute
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Thread created on 12:55:07 - 27/03/22 (2 years ago)
    |
    Last replied 02:56:28 - 05/04/22 (2 years ago)
    I wanted to make a small, personal sheet so that I can easily see the stock of my filtered items. I was going to use it for flower/plushy sets so I can see which I need to get. I have no experience with this stuff and don't have any idea how to filter the response, since I don't have any use for other items like candies ect. Is this something that's pretty simple to do? I'm using API Connector for Google Sheets.

    Wenno-forum-sig-by-TRUC.png

  • Patient [2131539] Patient
    • Patient [2131539]
    • Role: Civilian
    • Level: 90
    • Posts: 3,001
    • Karma: 6,951
    • Last Action: 10 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 02:56:28 - 05/04/22 (2 years ago)
    Post link copied to clipboard Copy post link

    Wenno [2757277]

    I wanted to make a small, personal sheet so that I can easily see the stock of my filtered items. I was going to use it for flower/plushy sets so I can see which I need to get. I have no experience with this stuff and don't have any idea how to filter the response, since I don't have any use for other items like candies ect. Is this something that's pretty simple to do? I'm using API Connector for Google Sheets.
    I'm not super familiar with Google sheets, so I'm not 100% sure how it works.

    But couldn't you just set a filter to the item ID column to only show the items you want?

    You should just be able get the ID's of the items(all the plushy and flower types you need) and set up your spreadsheet to only show those you're looking for.

    If you want to filter the API first, you'd probably need to run it through a custom script first.
Reply
Thread Title: