To create a JSON file using a URL resource, you need to follow JSON formatting rules:
1. Use double quotes for keys and string values
2. Don't use quotes for numbers or booleans
3. Format properly with commas between key-value pairs
For example: LBKS{ "name": "John", "age": 30, "url": "[URL]" }LBKSCould you share the specific JSON you're working with so I can help troubleshoot?
Hey there Joe thanks for reaching out, sorry for the delay here, looking at the API documentation here you would need to change the endpoint to look like the following. where after "lead=" you enter in the column for company name
(11 kB)
Creating JSON Data from ClinicalTrials.gov API Guide | Clay