Rest Connector JS PreScript Fault Finding Techniques

When working with the JS script and the rest connector, it might be difficult to work out what the issue is if you do not have sight of the parameters being saved. You can easily find these in your MySQL database.

First thing to do is to copy the Collection ID, you can do this by going to you collection, in our example it was a Data-In, and editting.

One inside you will see a GUID show in the URL, you can copy this, this is your Collection ID.

Fetch Collection ID

This ID is 215e498c-1bb0-4ccf-8154-a6cd4540cbf7

Next is to log into you MySQL Database. Once in, you can run a query on the microservices.CollectionSourceConnectors table to find the source connector (If you are using a Data-out it will be table microservices.CollectionPublisherConnectors)

SELECT * FROM microservices.CollectionSourceConnectors
where Collection = '215e498c-1bb0-4ccf-8154-a6cd4540cbf7';

In the results you can now see the parameters sitting in the State field in your DB. This example is the second example we used and you can see the "calc" parameter here.

Hopefully this will help bring some visibility to your JS script and parameters.