Hello everyone! I have built a tap for REST type o...
# troubleshooting
s
Hello everyone! I have built a tap for REST type of stream and API authentication. Created a job in with target as default mssql target and added the credentials for the same, When the job runs, I am able to see the data streams on the console the connection is also established but no records are transferred. Here is what the console displays:
Copy code
2025-04-14 09:23:39,166 - hotglue - DEBUG - Export hierarchy not set. Using original order

04/14 02:53:39 pm

2025-04-14 09:23:39,166 - hotglue - INFO - Fetching available entities

04/14 02:53:39 pm

2025-04-14 09:23:39,682 - hotglue - DEBUG - Available entity found: None

04/14 02:53:39 pm

2025-04-14 09:23:39,683 - hotglue - DEBUG - Listing folders [hotglue-prod.admin] /env_zips/tap-csv

04/14 02:53:39 pm

2025-04-14 09:23:39,803 - hotglue - DEBUG - Downloading: hotglue-prod.admin:env_zips/tap-csv/tap_csv-v0_1_7.py3_10.zip

04/14 02:53:39 pm

2025-04-14 09:23:39,949 - hotglue - INFO - Unzipping file tap-csv.zip

04/14 02:53:40 pm

2025-04-14 09:23:40,936 - hotglue - INFO - Running Subprocess: [ /home/envs/tap-csv/bin/tap-csv --config csv-config.json ] with path [ ['/home', '/usr/local/lib/python310.zip', '/usr/local/lib/python3.10', '/usr/local/lib/python3.10/lib-dynload', '/usr/local/lib/python3.10/site-packages'] ]

04/14 02:53:41 pm

2025-04-14 09:23:41,305 - hotglue.export - DEBUG - INFO Starting sync

04/14 02:53:41 pm

2025-04-14 09:23:41,305 - hotglue.export - DEBUG - INFO Sync completed

04/14 02:53:41 pm

2025-04-14 09:23:41,326 - hotglue - INFO - Running Subprocess: [ source /home/envs/target/bin/activate && cat streams.json | target-mssqltarget --config config.json > target_state.json ] with path [ ['/home', '/usr/local/lib/python310.zip', '/usr/local/lib/python3.10', '/usr/local/lib/python3.10/lib-dynload', '/usr/local/lib/python3.10/site-packages'] ]

04/14 02:53:42 pm

2025-04-14 09:23:42,938 - hotglue - INFO - (update_metadata) Started

04/14 02:53:43 pm

2025-04-14 09:23:43,028 - hotglue - INFO - (update_resources_usage_script) Started

04/14 02:53:43 pm

2025-04-14 09:23:43,311 - hotglue.export - DEBUG - 2025-04-14 09:23:43,310 | INFO     | target-mssqltarget   | Target 'target-mssqltarget' is listening for input from tap.

04/14 02:53:43 pm

2025-04-14 09:23:43,311 - hotglue.export - DEBUG - 2025-04-14 09:23:43,311 | INFO     | target-mssqltarget   | Target 'target-mssqltarget' completed reading 0 lines of input (0 schemas, 0 records, 0 batch manifests, 0 state messages).

04/14 02:53:43 pm

2025-04-14 09:23:43,312 - hotglue.export - DEBUG - 2025-04-14 09:23:43,312 | INFO     | target-mssqltarget   | Emitting completed target state {}
e
Hi @Suyash Muley! What's the Meltano command you're running, and what output do you see from
meltano invoke <your tap>
?
s
--discover command
s
Hi @Edgar Ramírez (Arch.dev) ! After using
meltano invoke <your tap>
I can see the data from the API in singer format.
e
And what's the result of
meltano run <your tap> target-mssql
?