TW-Request-Agri data open platform-daily market sheep pricing

This workflow automates the process of fetching agricultural transaction data from the Taiwan Agricultural Products Open Data Platform and storing it in a Google Sheets document for further analysis.

Key Features 1. Manual Trigger: Allows manual execution of the workflow to control when data is fetched. 2. HTTP Request: Sends a request to the Open Data Platform's API to retrieve detailed transaction data, including: - Pricing (Upper, Middle, Lower, Average) - Transaction quantities - Crop and market details 3. Split Out Node: Processes each record individually, ensuring accurate handling of every data entry. 4. Google Sheets Integration: Appends the data into a structured Google Sheets document for easy access and analysis.

---

Node Configurations

1. Manual Trigger - Purpose: Start the workflow manually. - Configuration: No setup needed.

2. HTTP Request - Purpose: Fetch agricultural data. - Configuration: - URL: https://data.moa.gov.tw/api/v1/SheepQuotation - Query Parameters: - Starttime: 2024/12/01 - Endtime: 2024/12/31 - MarketName: 台北二 - apikey: <yourapikey> - Headers: - accept: application/json

3. Split Out - Purpose: Split the API response data array into individual items. - Configuration: - Field to Split Out: Data

4. Google Sheets - Purpose: Append the data to Google Sheets. - Configuration: - Operation: Append - Document ID: <yourdocumentid> - Sheet Name: Sheet1 - Mapped Fields: - TransDate, TcType, CropCode, CropName, MarketCode, MarketName - UpperPrice, MiddlePrice, LowerPrice, AvgPrice, TransQuantity