USITC DataWeb API v2 Integration
Budget: $14 – $30 NZD
Project Task: USITC DataWeb API v2 Integration Production Ready
1. Project Overview
Integrate the USITC DataWeb API v2 Reporting Engine into an existing Workspace (3.10 App). The goal is to build a "DatawebQuery" tab that allows users to search for import data and calculate effective duty rates for specific countries.
2. Technical Stack
Frontend: React (JavaScript/TypeScript).
Backend/Proxy: Node.js (or AI Studio Environment).
API: USITC DataWeb API v2 (JSON-based Reporting Engine).
---
3. Core Requirements & Logic
Authentication: Use the provided Bearer Token in headers for all `POST` requests to the `runReport` endpoint.
Search Functionality:
Implement dual-search: Natural Language (keywords) and 8-digit HTS codes.
HTS Granularity: Ensure the query defaults to the 8-digit level for accurate US Customs data.
Targeted Parameters:
Countries: Hardcode/Filter for China (CHN), Taiwan (TWN), Philippines (PHL), South Africa (ZAF), and Nigeria (NGA).
Data Fields: Retrieve `CONS_VAL_CIF` (Customs Value) and `CONS_DUTY_CALC` (Calculated Duties).
Timeframe: Default to the most recent full years (2023-2024).
4. UI & Data Mapping (The DTO Logic)
UI Component: Implement the "DatawebQuery" tab with a search bar and a results table as per the provided design.
Data Extraction: The developer must implement a robust function to parse the nested `dto` response from USITC:
* `Path: dto > tables[0] > row_groups[0] > rowsNew`.
Calculations: Effective Duty Rate = `(Total Calculated Duties / Customs Value) 100`.
Duties must be presented as an Aggregated Total (Base + Section 301 + others).
5. Deliverables
1. Clean Code: Modular React component for the Query Engine.
2. API Handler: A secure proxy or backend function to handle the USITC request/response without exposing tokens.
3. Error Handling: Proper "Loading" states and "No Data Found" alerts for invalid HTS codes.
Delivery: 24-40 Total /hr
Budget: $25 NZD
1. Project Overview
Integrate the USITC DataWeb API v2 Reporting Engine into an existing Workspace (3.10 App). The goal is to build a "DatawebQuery" tab that allows users to search for import data and calculate effective duty rates for specific countries.
2. Technical Stack
Frontend: React (JavaScript/TypeScript).
Backend/Proxy: Node.js (or AI Studio Environment).
API: USITC DataWeb API v2 (JSON-based Reporting Engine).
---
3. Core Requirements & Logic
Authentication: Use the provided Bearer Token in headers for all `POST` requests to the `runReport` endpoint.
Search Functionality:
Implement dual-search: Natural Language (keywords) and 8-digit HTS codes.
HTS Granularity: Ensure the query defaults to the 8-digit level for accurate US Customs data.
Targeted Parameters:
Countries: Hardcode/Filter for China (CHN), Taiwan (TWN), Philippines (PHL), South Africa (ZAF), and Nigeria (NGA).
Data Fields: Retrieve `CONS_VAL_CIF` (Customs Value) and `CONS_DUTY_CALC` (Calculated Duties).
Timeframe: Default to the most recent full years (2023-2024).
4. UI & Data Mapping (The DTO Logic)
UI Component: Implement the "DatawebQuery" tab with a search bar and a results table as per the provided design.
Data Extraction: The developer must implement a robust function to parse the nested `dto` response from USITC:
* `Path: dto > tables[0] > row_groups[0] > rowsNew`.
Calculations: Effective Duty Rate = `(Total Calculated Duties / Customs Value) 100`.
Duties must be presented as an Aggregated Total (Base + Section 301 + others).
5. Deliverables
1. Clean Code: Modular React component for the Query Engine.
2. API Handler: A secure proxy or backend function to handle the USITC request/response without exposing tokens.
3. Error Handling: Proper "Loading" states and "No Data Found" alerts for invalid HTS codes.
Delivery: 24-40 Total /hr
Budget: $25 NZD