{"collection":{"info":{"_postman_id":"2c85a07f-1d52-475d-b48d-ba9a0b758db4","name":"Programatic Access to SPCS","description":"This is a demo postman collection for using programatic access to connect to snowflake's snowpark container services.","schema":"https://schema.getpostman.com/json/collection/v2.1.0/collection.json","createdAt":"2024-08-02T00:14:13.000Z","updatedAt":"2025-04-29T17:22:00.000Z","lastUpdatedBy":"37391847","uid":"37391847-2c85a07f-1d52-475d-b48d-ba9a0b758db4"},"item":[{"name":"Convert keyPair to Token","event":[{"listen":"test","script":{"id":"753fa040-bbc8-49d7-a424-deda4ad89584","exec":["// Parse the response body as JSON","var responseBody = pm.response.text();","","// Store the access token in an environment or global variable","pm.collectionVariables.set(\"accessToken\", responseBody);","","   pm.environment.set(\"req\", pm.request)"],"type":"text/javascript","packages":{}}},{"listen":"prerequest","script":{"id":"1ab83264-d36b-4e5a-b8a0-2ab6688e4fb5","exec":["pm.environment.set(\"req\", pm.request)"],"type":"text/javascript","packages":{}}}],"id":"6ddaf8da-563c-45c9-a286-7cab25297dcb","protocolProfileBehavior":{"disabledSystemHeaders":{"content-type":true},"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"Content-Type","value":"application/x-www-form-urlencoded","type":"default"}],"body":{"mode":"urlencoded","urlencoded":[{"key":"grant_type","value":"urn:ietf:params:oauth:grant-type:jwt-bearer","type":"text"},{"key":"scope","value":"session:role:{{role}} {{ENDPOINT}}","type":"text"},{"key":"assertion","value":"{{keyPairJWT}}","type":"text"}]},"url":{"raw":"https://{{snowflakeAccountURL}}.snowflakecomputing.com/oauth/token","protocol":"https","host":["{{snowflakeAccountURL}}","snowflakecomputing","com"],"path":["oauth","token"]}},"response":[],"createdAt":"2024-08-02T00:15:21.000Z","updatedAt":"2024-08-02T00:49:57.000Z","uid":"37391847-6ddaf8da-563c-45c9-a286-7cab25297dcb"},{"name":"Convert Pat to Token","event":[{"listen":"test","script":{"id":"04504175-26a6-4f37-ac4d-b4ff0e32cb79","exec":["pm.environment.set(\"req\", pm.request)"],"type":"text/javascript","packages":{}}}],"id":"4b12e3ca-d900-4e29-9fdb-63d62eafdd22","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"Content-Type","value":"application/x-www-form-urlencoded"}],"body":{"mode":"urlencoded","urlencoded":[{"type":"text","key":"grant_type","value":"urn:ietf:params:oauth:grant-type:token-exchange"},{"type":"text","key":"scope","value":"session:role:{{role}} {{ENDPOINT}}"},{"type":"text","key":"subject_token","value":"{{PAT}}"},{"type":"text","key":"subject_token_type","value":"programmatic_access_token"}]},"url":{"raw":"https://{{snowflakeAccountURL}}.snowflakecomputing.com/oauth/token","protocol":"https","host":["{{snowflakeAccountURL}}","snowflakecomputing","com"],"path":["oauth","token"]},"description":"Generated from cURL: curl   --location 'https://PM-SURAJ-ENT.snowflakecomputing.com/oauth/token' --header 'Content-Type: application/x-www-form-urlencoded' --data-urlencode 'grant_type=urn:ietf:params:oauth:grant-type:token-exchange' --data-urlencode 'scope=session:role:R1 blxnazm-pm-suraj-ent.snowflakecomputing.app' --data-urlencode 'subject_token=eyJraWQiOiIyNDYxODYyNzk4NzU2NjU5OCIsInR5cCI6IkpXVCIsImFsZyI6IkVTMjU2In0.eyJzdWIiOiIzNzU2NTA0NTE5ODUiLCJhY2NvdW50SWQiOjU3MzE5NzEsIm5iZiI6MTczMzkzOTYyNCwicGF0SWQiOiI4NDdlNjU1Ny1kMGNmLTQwM2ItYTUzNS0yZDNhMjlhNzQ0MmYiLCJzcmNEZXBsb3ltZW50SWQiOjEwMDksInNyY1VzZXJJZCI6MCwiZXhwIjoxNzY1NDc1NjI0LCJ0eXBlIjoiUEFUIiwiaWF0IjoxNzMzOTM5NjI0LCJ1c2VySWQiOjM3NTY1MDQ1MTk4NX0.uC9s6QIhCGDcTB6METFwS3E7-eY5ylMPbnP8meBaH16tu-pfROW6tBIhPD3twBAehLAa8Bk0VZyHV5z7nc8SWQ' --data-urlencode 'subject_token_type=programmatic_access_token'"},"response":[],"createdAt":"2024-12-12T00:12:21.000Z","updatedAt":"2025-04-25T01:58:11.000Z","uid":"37391847-4b12e3ca-d900-4e29-9fdb-63d62eafdd22"},{"name":"Connect to Endpoint","event":[{"listen":"prerequest","script":{"id":"f8112ca8-bcf1-42f6-9bd4-548a96bee993","exec":[""],"type":"text/javascript","packages":{}}}],"id":"ef2b8d7d-c471-47df-9feb-769313708727","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"Authorization","value":"Snowflake Token=\"{{accessToken}}\"","type":"text"}],"body":{"mode":"urlencoded","urlencoded":[{"key":"input","value":"Welcome To Snowflakes' SPCS","type":"text"}]},"url":{"raw":"https://{{ENDPOINT}}/{{path}}","protocol":"https","host":["{{ENDPOINT}}"],"path":["{{path}}"]}},"response":[],"createdAt":"2024-08-02T00:18:08.000Z","updatedAt":"2024-08-02T00:51:53.000Z","uid":"37391847-ef2b8d7d-c471-47df-9feb-769313708727"},{"name":"http://pm-suraj-ent.snowflakecomputing.com/api/v2/statements?async=false","id":"88f4ad28-ca21-4ef0-bc6e-16e4c63335c9","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"},{"key":"Authorization","value":"Bearer eyJhbGciOiJSUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJJVkE5NTQ2OC5LUFVTRVIuU0hBMjU2OkpqUnhVbXJ5YWNYYkxWaDMzL0hxSDlzU25oeFhGVTFmcHdXNllUM0Q2MEE9Iiwic3ViIjoiSVZBOTU0NjguS1BVU0VSIiwiaWF0IjoxNzM4MDIwMzYxLCJleHAiOjE3MzgxMDY3NjF9.F70cgq7HXvqTJPjT0o4hgWlb0pCNrD3i-4H3he3zhq8u8bsQ6TiT7scGy9Z5rYnTmvF0UPmYvRirNgZPzSXbMzDmGOA7Wm24tICzGbomGVvxiGo8e1mRym3jIAoUHmmqpjwjxQ3Hi5N-zR_rmKEsz0WNiYXZCAu9hrqLGRltpq0GuV8JNVZ8vxGj_16VajGPLPUa1tByLMMBVMf0D60S3O4BLtuQMBvRovIxdvSdnY-8qrLDkkqLyD9WL_EN4Zw_cSYRTu1tzGNKQVJulwfE6liIwFEI1ZVCihfdeRcs5vUzK2raeGAfPFl-PE7_WB9qv6T3xclbpI4BSV-hZzJ_3g"},{"key":"Accept","value":"application/json"},{"key":"User-Agent","value":"myApplicationName/1.0"},{"key":"X-Snowflake-Authorization-Token-Type","value":"KEYPAIR_JWT"}],"body":{"mode":"raw","raw":"{\"statement\":\"select current_version();\"}","options":{"raw":{"language":"json"}}},"url":{"raw":"http://pm-suraj-ent.snowflakecomputing.com/api/v2/statements?async=false","protocol":"http","host":["pm-suraj-ent","snowflakecomputing","com"],"path":["api","v2","statements"],"query":[{"key":"async","value":"false"}]},"description":"Generated from cURL: curl -X POST --location \"http://pm-suraj-ent.snowflakecomputing.com/api/v2/statements?async=false\"     -H \"Content-Type: application/json\"     -H \"Authorization: Bearer eyJhbGciOiJSUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJJVkE5NTQ2OC5LUFVTRVIuU0hBMjU2OkpqUnhVbXJ5YWNYYkxWaDMzL0hxSDlzU25oeFhGVTFmcHdXNllUM0Q2MEE9Iiwic3ViIjoiSVZBOTU0NjguS1BVU0VSIiwiaWF0IjoxNzM4MDIwMzYxLCJleHAiOjE3MzgxMDY3NjF9.F70cgq7HXvqTJPjT0o4hgWlb0pCNrD3i-4H3he3zhq8u8bsQ6TiT7scGy9Z5rYnTmvF0UPmYvRirNgZPzSXbMzDmGOA7Wm24tICzGbomGVvxiGo8e1mRym3jIAoUHmmqpjwjxQ3Hi5N-zR_rmKEsz0WNiYXZCAu9hrqLGRltpq0GuV8JNVZ8vxGj_16VajGPLPUa1tByLMMBVMf0D60S3O4BLtuQMBvRovIxdvSdnY-8qrLDkkqLyD9WL_EN4Zw_cSYRTu1tzGNKQVJulwfE6liIwFEI1ZVCihfdeRcs5vUzK2raeGAfPFl-PE7_WB9qv6T3xclbpI4BSV-hZzJ_3g\"     -H \"Accept: application/json\"     -H \"User-Agent: myApplicationName/1.0\"     -H \"X-Snowflake-Authorization-Token-Type: KEYPAIR_JWT\"     -d '{\"statement\":\"select current_version();\"}'"},"response":[],"createdAt":"2025-01-27T23:34:52.000Z","updatedAt":"2025-01-27T23:34:52.000Z","uid":"37391847-88f4ad28-ca21-4ef0-bc6e-16e4c63335c9"}],"event":[{"listen":"prerequest","script":{"id":"9bc59ef4-b3a3-493d-845c-b1568ec749e3","type":"text/javascript","packages":{},"exec":[""]}},{"listen":"test","script":{"id":"a5b82819-fbb9-4963-85d4-1527cafacc54","type":"text/javascript","packages":{},"exec":[""]}}],"variable":[{"key":"snowflakeAccountURL","value":"ACCOUNT_NAME"},{"key":"role","value":"ROLENAME (CASE SENSITIVE)"},{"key":"ENDPOINT","value":"PUBLIC_ENDPOINT.snowflakecomputing.app"},{"key":"keyPairJWT","value":""},{"key":"accessToken","value":""},{"key":"path","value":"ui"},{"key":"PAT","value":"PAT_TOKEN_FROM_SNOWFLAKE","type":"string"}]}}