Hi, I’m trying to build a custom source connector with low-code connector development, but stuck at Step 3: Connecting to the API
The error is:
{“type”: “LOG”, “log”: {“level”: “ERROR”, “message”: “Check failed”}}
{“type”: “CONNECTION_STATUS”, “connectionStatus”: {“status”: “FAILED”, “message”: “‘Unable to connect to stream list all requests - Expecting value: line 1 column 1 (char 0)’”}}
My source API is very simple. It requires only some parameters such as:
- Access token
- Created_from:
- Creared_to:
The docs of my source API is: Request Public API (section List all requests in system)
Here is my yaml:
version: “0.1.0”
definitions:
selector:
extractor:
field_pointer:
requester:
url_base: “https://request.base.com.vn”
http_method: “POST”
request_options_provider:
request_parameters:
access_token: “{{ config[‘access_token’] }}”
status: “{{ config[‘status’] }}”
created_from: “{{ config[‘created_from’] }}”
created_to: “{{ config[‘created_to’] }}”
retriever:
record_selector:
$ref: “*ref(definitions.selector)”
paginator:
type: NoPagination
requester:
$ref: “*ref(definitions.requester)”
base_stream:
retriever:
$ref: “*ref(definitions.retriever)”
list_all_requests_stream:
$ref: “*ref(definitions.base_stream)”
$options:
name: “list all requests”
primary_key: “id”
path: “/extapi/v1/request/list”
streams: - “*ref(definitions.list_all_requests_stream)”
check:
stream_names:
- “list all requests”
Python main.py spec work fined
{“type”: “SPEC”, “spec”: {“documentationUrl”: “Request Public API”, “connectionSpecification”: {“$schema”: “http://json-schema.org/draft-07/schema#”, “title”: “Basevn Request Spec”, “type”: “object”, “required”: [“access_token”, “status”, “created_from”, “created_to”], “additionalProperties”: true, “properties”: {“access_token”: {“type”: “string”, “description”: “request access token provided by Basevn, unique for each system”}, “status”: {“type”: “string”, “description”: “status value such as pending, approved, rejected, overdue”}, “created_from”: {“type”: “string”, “description”: “date request created”, “pattern”: “[0-9]{2}/[0-9]{2}/[0-9]{4}$”, “examples”: [“dd/mm/YYYY”]}, “created_to”: {“type”: “string”, “description”: “date request created”, “pattern”: “[0-9]{2}/[0-9]{2}/[0-9]{4}$”, “examples”: [“dd/mm/YYYY”]}}}}}
Hope someone can help