ContributionsMost RecentMost LikesSolutionsRe: Connected Table not refreshingthe refresh options are set to "Make my data match the most recent csv" file. I also tried the switching option to append the data. Neither refresh option is working. The data refresh process keeps on refreshing the data from the original csv file that created the connected table in the first place. ------------------------------ George Romanowski ------------------------------ Pipeline - If Condition on Search read count = 1I have following if condition in a pipeline do loop. trying to determine when the search count is equal to 1. The below expression is not working. ------------------------------ George Romanowski ------------------------------ API Connection from SAS to Quickbase-Connection failedAnybody have experience connecting to a Quickbase app from SAS. I am using a PROC HTTP function following the SAS and Quickbase API documentation. However, my API connection is timing out. I am getting the following errors. Is something I need to check for on the Quickbase side? ERROR: Error connecting to 104.18.101.99:443. (The connection has timed out.) ERROR: Error connecting to 104.18.100.99:443. (The connection has timed out.) ERROR: Unable to establish connection to mycompany.quickbase.com. ERROR: Unable to connect to Web server. Here is my sas code with user token masked. proc http url=%NRSTR("https://mycompany.quickbase.com/db/mytableid?a=API_DoQuery&query={6.EX.'01-26-2022'}&usertoken=xxxxxxxxxxxxxxxxxxxxxxxxxx") headerout=headers out=response HTTP_TOKENAUTH; run; ------------------------------ George Romanowski ------------------------------ Pipelines - obtain count of records processed in a Search stepHow do you get a count of the records processed by a 'search' step within a pipeline. I would like to add this count to a 'create record' step at the end of the pipeline. ------------------------------ George Romanowski ------------------------------ Re: Pipelines Advanced Query - matching on a specific datethanks it works with this. {6.EX.'{{a.research_week_date}}'} ------------------------------ George Romanowski ------------------------------ Pipelines Advanced Query - matching on a specific dateTrying to search for records which match a specific date pulled from a previous step (a). The below advance query is not finding any records. help {6.EX.'a.research_week_date'} ------------------------------ George Romanowski ------------------------------ Re: Pipelines - Create a csv file The csv file will be sent to an sftp server. George Romanowski Ops Change Mgmt – Sr. Securites Operations 571-382-5520 1551 Park Run Drive McLean, VA 22102 The information transmitted in this e-mail is for the exclusive use of the person or entity to which it is addressed and may contain legally privileged or confidential information. If you are not the intended recipient of this e-mail, you are prohibited from reading, printing, duplicating, disseminating or otherwise using or acting in reliance upon this information. If you have received this information in error, please notify the sender at Freddie Mac immediately, delete this information from your computer and destroy all copies of the information. Pipelines - Create a csv fileCan Pipelines read a table and then create a csv output file. ------------------------------ George Romanowski ------------------------------ Pipelines Question: Start report, send file to sftp server Trying to determine if Pipelines has an option to: 1. Start a report manually by clicking a button or checking a check box 2. Send the output of that report (a .csv file) to a sftp server. George Romanowski Ops Change Mgmt – Sr. Securites Operations 571-382-5520 1551 Park Run Drive McLean, VA 22102 The information transmitted in this e-mail is for the exclusive use of the person or entity to which it is addressed and may contain legally privileged or confidential information. If you are not the intended recipient of this e-mail, you are prohibited from reading, printing, duplicating, disseminating or otherwise using or acting in reliance upon this information. If you have received this information in error, please notify the sender at Freddie Mac immediately, delete this information from your computer and destroy all copies of the information. If statement to check for numericHow do you check if a text data field only contains a number or is just numeric. I have an address field that I need to perform an If statement such as: If property address is numeric then set "Y" else set "N" ------------------------------ George Romanowski ------------------------------